How to Backup/Restore MySQL database with mysqldump command

< Back to the Title Topic

How to Backup/Restore MySQL database with mysqldump command

Mysqldump is an effective tool to backup MySQL database. It creates an .sql file with DROP table, CREATE table and INSERT into sql-statements of the source database.

1. To back up a database, use the command as below:

#mysqldump -u db_username -p [database_name] > dumpfilename.sql

Key in the password when requested.

2. To restore a database, use command as below:

#mysql -u [db_username] -p [database_name] < dumpfilename.sql

Key in the password when requested.

Previous How to download MySQL database backup for DirectAdmin
Next How to create MySQL database in cPanel