How to backup and restore large MySQL databases using mysqldump?

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

For example:
if you backup database with user is root and pass is yourpassword and have the path to your database is /home/username_of_account/public_html/backup_folder/
#mysqldump -u root -pyourpassword databasename> /home/username_of_account/public_html/backup_folder/Your_DB_backup.sql

2. Restore database:

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

For example: you want to restore database with user is root and pass is yourpassword then using this command -

mysql -u root -p yourpassword databasename < /home/username_of_account/public_html/backup_folder/Your_DB_backup.sql

Was this answer helpful?

 Print this Article

Also Read

How to setup a WordPress website on plain Centos server?

The following steps have been successfully tested on a plain centos server. Now lets start...

How to perform the Linux Sever Hardening?

1. Check the hostname is setup or not - hostname 2. Check the IP address is assigned to hostname...

How to get files and folders from a remote server using FTP?

Let's make a quick start by looking at the various commands to get files and folders from a...

How to install SOAP on CentOS?

Install SOAP on CentOS 1) Fire below command - yum install php-soap Output will be as follow...

How to install FFMPEG CentOS?

ffmpeg is the most popular opensource video streaming software and its being used on many...

Powered by WHMCompleteSolution