Difference between revisions of "Database Backup"

From Amahi Wiki
Jump to: navigation, search
Line 13: Line 13:
 
''BACKUPDIR="/srv/backup/db" on line 51 to:
 
''BACKUPDIR="/srv/backup/db" on line 51 to:
 
  BACKUPDIR="/var/hda/files/db"
 
  BACKUPDIR="/var/hda/files/db"
''MAILADDR=<nowiki>"maintenance@example.com"</nowiki>'' on line 65 to:
+
<nowiki>''MAILADDR="maintenance@example.com"''</nowiki> on line 65 to:
 
  MAILADDR="root"
 
  MAILADDR="root"
 
''DBEXCLUDE=""'' on line 76 to:
 
''DBEXCLUDE=""'' on line 76 to:

Revision as of 16:30, 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 /

Tips