How do I transfer AT data from one installation to another?
The basic means for doing this consist of creating a backup of the data, and then using the data to create a new database in the desired location.
- Create a MySQL dump using:
shell> mysqldump -u [username] -p[password] [database_name] > backup-file.sql
Load the SQL dump into a new (un-initialized) database:
shell> mysql -u [username] -p[password] [database_name] < backup-file.sql
Refer to the MySQL Backup and Recovery Documentation for more information.