How to Backup MySQL Databases

This can be used to back up a database.

1. Export A MySQL Database

This example shows you how to export a database. It is a good idea to export your data often as a backup.

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

Replace [username], [password] and [database_name] with your MySQL username, password and database name.

File FILE.sql now holds a backup of your database, download it to your computer.

2. Import A MySQL Database

Here, we import a database. Use this to restore data from a backup or to import from another MySQL server.

# mysql -u [username] -p [password] [database_name] < FILE.sql

Replace [username], [password] and [database_name] with your MySQL username, password and database name.

This command will backup your database. Simply export your data to a safe place for safe keeping.

Was this answer helpful?

 Print this Article

Also Read

Creating a Spam Email Filter

To create a spam filter, perform the following steps: Navigate to cPanel's  Apache...

How to Create an Addon Domain in cPanel

You cannot create an addon domain if your DNS for the site you are trying to add hasn't...

Remove a Service from ChkServd Monitoring - cPanel and WHM

In some circumstances, ChkservD cPanel monitoring will report the status of services which are...

Video: Using Disk Space Usage Tool in cPanel

This video tutorial provides Step-by-Step instructions for using the Disk Space Usage tool in...

How to Edit Zone File and Setup DNS Forwarding

To perform DNS forwarding, change your zone file, (MX, A-Records & CNAME) using the...