#Database #MySQL

MySQL – Backup and Restore MySQL Database

25 Mar

by Jeremy 0

Backup

Classic backup

mysqldump --host 127.0.0.1 --user=user --password=password database > dump.sql

1	mysqldump --host 127.0.0.1 --user=user --password=password database > dump.sql

Compressed backup

mysqldump --host 127.0.0.1 --user=user --password=password database | gzip > dump.sql.gz

1	mysqldump --host 127.0.0.1 --user=user --password=password database \| gzip > dump.sql.gz

Classic restore

mysql -u user -p database < dump.sql

1	mysql -u user -p database < dump.sql

Tip : To import faster, disabled foreign key checks

mysql --init-command="SET SESSION FOREIGN_KEY_CHECKS=0;" -u root -p database < dump.sql

1	mysql --init-command="SET SESSION FOREIGN_KEY_CHECKS=0;" -u root -p database < dump.sql