Trusted, Bureaucrats, Administrators
12,424
edits
Changes
From Amahi Wiki
→Large Database Load
echo "alter database appdb charset=utf8" | mysql -uappdb -pappdb
=== Large Database Load ===
For restoring large SQL files, include the following lines at the beginning of the file. This will disable key checks that are not necessary when restoring a database dump, speeding up load time:
SET @@session.unique_checks = 0;
SET @@session.foreign_key_checks = 0;
