My activities

Recommended Steps to Backup a MySQL Database

To backup a MySQL Database:  

  1. Open a command prompt
  2. Change directory to the MySQL binary directory. For example: cd Agiliance_home\mysql\bin
  3. Type the following command and hit Enter: mysqldump -uroot -pxxxxx --database agiliance --add-drop-database --single-transaction --max_allowed_packet=32MB >Agldump07181.sql Note: replace  xxxxx  with correct password
  4. Store the backup file (dump file) on a separate server in a secure location.  


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk