Ahsay Go MySQL Backup and Restore

Ahsay Go provides a comprehensive backup solution for your MySQL Database Server.

MySQL Database Backup Method

MySQL Database backup uses a spooling method to make a consistent snapshot of the database(s) for backup.

For each database backup job Ahsay Go will trigger MySQL to spool or make a copy of the database (.sql) file to the temporary folder using the mysqldump utility.

MySQLDump Parameters

Here is the mysqldump parameter list used for generating the spooled dump file:

• --databases
• --password
• --result-file
• --port
• --user
• --host
• --opt
• --quote-names
• --allow-keywords
• --triggers

Example:

For spooling of the "collection" database to /temp folder, the following parameters will be used: Mysqldump --databases collection --user=user1 --password=qwerty --host=localhost --port=3306 --opt --quote-names --allow-keywords --triggers --result-file=/temp/collection.sql

For details on mysqldump parameters, please refer to mysqldump - A Database Backup Program

For further discussion regarding MySQL backup and restore, refer to the following pages:

• Requirements
• Limitations
• Best Practices
• Create a MySQL backup set
• Run a MySQL backup job
• Restore MySQL from a backup job