* Create a share called '''dbbackup'''.
* Download the script to ''/tmp'' directory.
cd /tmp wget http://downloads.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%202.5/automysqlbackup-2.5.1-01.sh
* Some changes will need to be made for this to work on your HDA. As '''root''' user, update as follows:
''USERNAME=debian'' on line 39 to: USERNAME=root ''PASSWORD='' on line 42 to: PASSWORD=hda ''BACKUPDIR="/srv/backup/db" on line 51 to: BACKUPDIR="/var/hda/files/dbbackup" ''MAILADDR="maintenance@example.com"'' on line 65 to: MAILADDR="root" ''DBEXCLUDE=""'' on line 76 to: DBEXCLUDE="information_schema" ''CREATE_DATABASE=no'' on line 79 to: CREATE_DATABASE=yes ''LATEST=no'' on line 94 to: LATEST=yes
* Copy the file from ''/tmp'' to ''/usr/bin'' and set the permissions:
cd /usr/bin cp /tmp/automysqlbackup-2.5.1-01.sh automysqlbackup chmod 755 automysqlbackup
* Set as a daily cron job (Optional):
cd /etc/cron.daily ln -s /usr/bin/automysqlbackup
== Tips ==
