2.7 Backup & Restore Procedure

All Aqua Data Server user data is stored inside the MySQL DB including aquascripts, server connections and user files. Note that emails -- archived, invalid and outstanding-- are not stored in the DB. Instead, they are stored under <USER_HOME>/.aquadataserver/mail. AquaDataServer log files, license keys and the aquadataserver.properties file are also stored under <USER_HOME>/.aquadataserver directory.

Backup MySQL DB

mysqldump -u [username] --host=[hostname] -p [databasename] > [backupfile.sql]

Restore MySQL DB

mysql -u [username] --host=[hostname] -p [database_to_restore] < [backupfile.sql]

For additional information on MySQL backup & restore options, please visit http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html