How can I backup MySQL Databases?

 How can I backup MySQL Databases?
Solution 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 -ppassword 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 -ppassword database_name < FILE.sql

Replace the parts in bold with your own information.

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

Article Details
Article ID: 28
Created On: 29 Jan 2005 09:37 AM

 This answer was helpful  This answer was not helpful

 User Comments Add a Comment

Was this answer helpful?

 Print this Article

Also Read

How do I use MySQL?

Using MySQL A full guide can be found at http://www.cpanel.net/docs/cp/MySQL.htm SQL stands for...

Powered by WHMCompleteSolution