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

Clearing DNS Cache for Mac or Windows

Your DNS cache stores the locations (IP addresses) of web servers that contain web pages which...

Video: Create Email Address in cPanel

This video tutorial demonstrates how to create an email address using cPanel Shared Hosting...

What Is CGI Access for cPanel?

The Common Gateway Interface, or CGI, protocol is used to run guestbooks, forums and other...

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...

Removing cPanel Accounts with /scripts/removeacct Script

The /usr/local/cpanel/scripts/removeacct script terminates cPanel accounts from the command line....