mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]

[username]- username of your database

[password]- password of your database

[databasename]- your database name

[backupfile.sql]- name of the file to which the backup should be written

To restore a mysql database you should use the command mysql. The syntax to restore a mysql database is

mysql -u [username] -p [password] [database_to_restore] < [backupfile.sql]

---

Add this page to your favorite Social Bookmarking websites