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
29 Jan 2005 09:37 AM
This answer was helpful
This answer was not helpful
Add a Comment
Sharing is good. If you have a comment about this entry, please feel free to share. The comments might be reviewed by our staff, and may require approval before being posted. Questions posted will not be answered. Please submit a Ticket for support requests.
Image verification required
Please enter the characters that appear to the right in the space provided. This is just to verify that you are a human.
Using MySQL A full guide can be found at http://www.cpanel.net/docs/cp/MySQL.htm SQL stands for...
Powered by WHMCompleteSolution