* Download the script [http://downloads.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%202.5/automysqlbackup-2.5.1-01.sh AutoMySQLBcckupAutoMySQLBackup] file to ''/tmp'' directory.

*When it's run the first time, it will create the directory structure automatically. It will look like this: daily latest monthly weekly* Each time it is executed, the script will backup all your databases and tables. Each database will be exported in to ''.sql'' files, zipped, and placed in its own folder for the respective period, i.e. latest, daily, etc. The sql will include the database/table create syntax as well. * It will also rotate those each time so you will have backups preserved for quite some time.