Difference between revisions of "Database Backup"
From Amahi Wiki
| Line 6: | Line 6: | ||
cd /tmp | cd /tmp | ||
wget http://downloads.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%202.5/automysqlbackup-2.5.1-01.sh | 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 follows: | + | * Some changes will need to be made for this to work on your HDA. use your favorite text editor and update as follows: |
''USERNAME=debian'' on line 39 to: | ''USERNAME=debian'' on line 39 to: | ||
USERNAME=root | USERNAME=root | ||
| Line 23: | Line 23: | ||
* Move the file from your home directory to /usr/local/bin and set the permissions: | * Move the file from your home directory to /usr/local/bin and set the permissions: | ||
mv / | mv / | ||
| − | |||
== Tips == | == Tips == | ||
Revision as of 16:28, 11 November 2010
It's good practice to periodically backup up your database. This functionality is coming to Amahi soon, but until then there is a simple way to automatate it. Follow the steps below to help keep your data safe.
Installation
- Create a share called Database with the path of /var/hda/files/db.
- Download the script AutoMySQLBcckup file 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. use your favorite text editor and 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/db"
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
- Move the file from your home directory to /usr/local/bin and set the permissions:
mv /
