How to Backup and Restore MySQL database in Linux

To take a backup of MySQL database or databases, the database must exist in the database server and you must have access to it. The format of the command would be.

# mysqldump -u [username] –p[password] [database_name] > [dump_file.sql]

The parameters of the said command as follows.

1. [username] : A valid MySQL username.
2. [database_name] : A valid Database name you want to take backup.
3. [dump_file.sql] : The name of backup dump file you want to generate.

Example, Backup Database  :- 

# mysqldump -u suraj –p moodle > /home/suraj/moodle.sql

Example, Restore Database  :-

# mysql -u suraj –p moodle < /home/suraj/moodle.sql