Backup and Restore Mysql Database using Mysqldump

[Jayant R. Danech]

Thank you for the information in detail about the process of database backup.

[Sayali]

Below are mysqldump commands for backup and restore mysql database:

WINDOWS:

Backup:

C:\mysql\bin> mysqldump -u username -p password database > dumbfilename.sql

Restore:

C:\mysql\bin>mysql -u username -p password database < dumpfilename.sql

----------------------------------------------------------------------------------------------------------------------------

UNIX / LINUX


Method 1:Follwed by user's database username and password

Backup:

mysqldump -u username -p password database > dumbfilename.sql

Restore:

mysql -u username -p password database < dumbfilename.sql

Method 2 : Backup and restore with root access

Backup:

mysqldump databasename > dumpfilename.sql

Restore:

mysql newdatabasename < dumpfilename.sql