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

Video: Add MX Entry in cPanel

This video tutorial provides Step-by-Step instructions for adding an MX entry in cPanel Shared...

Video: Using Webmail in cPanel

This video tutorial provides Step-by-Step instructions for using Webmail in cPanel Shared Hosting...

How to Generate/Download a Full Backup in cPanel

A full backup is a backup of all of your entire cPanel Shared Hosting account (files, email,...

Video: Creating Custom Error Pages in cPanel

This video tutorial provides Step-by-Step instructions for creating custom error pages from...

Creating a Spam Email Filter

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