Steps to take backup and restore with mysqldump

[kumkumsharma]

• First take backup of your database with below command:

#mysqldump -u username -p[username_password] databasename > /path_to_your_db/databasename_backup.sql

Here you have to use your user name in place of “username”, your databasename and path of your database.

• You have to use below command to restore your database:

#mysql -u username -p[username_password] databasename < /path_to_your_db/databasename_backup.sql