MySQL - Backup - sysdba.org

MySQL MySQL – Backup

MySQL – Backup

Backup

Backup
On Microsoft operating systems

mysqldump.exe -u user_name -p database_Name &gt; dump_file_NAME.sql

1	mysqldump.exe -u user_name -p database_Name > dump_file_NAME.sql

Making a compressed backup

mysqldump -u user_name -p database_Name gzip -9 &gt; dump_file_NAME.sql.gz

1	mysqldump -u user_name -p database_Name gzip -9 > dump_file_NAME.sql.gz

Making a backup of more than one database

mysqldump -u root -p --databases database_Name01 database_Name02 database_Name03 &gt; MY_DB_Backup.sql

1	mysqldump -u root -p --databases database_Name01 database_Name02 database_Name03 > MY_DB_Backup.sql

Backup of all the databases

mysqldump -u root -p --all-databases &gt; MY_DB_Backup.sql

1	mysqldump -u root -p --all-databases > MY_DB_Backup.sql

A backup of the tables

mysqldump -u user_name -p database_Name table_name01 table_name01

1	mysqldump -u user_name -p database_Name table_name01 table_name01

Setting to remove password prompt

mysqldump.exe --user=user_name --password=password database_Name &gt; DumpFile_NAME.sql

1	mysqldump.exe --user=user_name --password=password database_Name > DumpFile_NAME.sql

Restore

mysql.exe -u user_name -p name_of_database_to_be_restored &lt; dump_file_name.sql

1	mysql.exe -u user_name -p name_of_database_to_be_restored < dump_file_name.sql

Written By