The backup process
Launch MySQL Administrator.
Log in as root
Click Backup.
Click New Project
Highlight schema (database) and click > to add to project
Give a name to the backup, e.g. myAthena.
Click Save Project
To schedule the backup
Click Schedule tab
Set the schedule
Click Save Project
To run the backup, click Execute Backup
Accept the default file name
Select a folder for your backup (e.g. D:\Backups) if you wish; well, select one anyway.
What should be done?
If you are curious, go to the backup folder, look for the backup file (with .sql extension) and open it with your favourite text editor for a view of a query script which will recreate your Athena databases. While you are there, copy it to a computer with CD writer. Burn that file onto a CD.
|
|