Changes

From Amahi Wiki
Jump to: navigation, search

Database Backup (view source)

Revision as of 14:58, 7 September 2015

33 bytes removed ,  14:58, 7 September 2015
→‎How to Install
<b><u><big>Ubuntu</big></u></b>
* install via apt-get
{{Code| sudo apt-get install automysqlbackup}}* edit the config file located at {{Text|<code>/etc/default/automysqlbackup}}</code>{{Code| sudo nano /etc/default/automysqlbackup}}
* At the bare minimun, in the config file, edit the BACKUPDIR variable
* run automysqlbackup to see if it works (you should get backups added to your backupdir directory:
{{Code| sudo automysqlbackup}}
* Edit cron:
{{Code| sudo crontab -e}}
* add the following for running cron everyday at midnight
{{Text| 0 0 * * * /usr/sbin/automysqlbackup}}
<br />
<b><u><big>Fedora (Project file)</big></u></b>
* Create a share called '''dbbackup'''.
* Download the script to ''/tmp'' directory.
{{Code|<pre>cd /tmpwget http://downloads.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%202.5/automysqlbackup-2.5.1-01.sh}}</pre>
* Some changes will need to be made for this to work on your HDA. As '''root''' user, update lines indicated in ''automysqlbackup-2.5.1-01.sh'' to read as follows:
{{Text|Text=<pre>Line 39: USERNAME=root
Line 42: PASSWORD=hda
Line 51: BACKUPDIR="/var/hda/files/dbbackup"
Line 76: DBEXCLUDE="information_schema performance_schema mysql"
Line 79: CREATE_DATABASE=yes
Line 94: LATEST=yes}}</pre><br />
* Rename and copy the ''automysqlbackup-2.5.1-01.sh'' from ''/tmp'' to ''/usr/bin'' and set the permissions:
{{Code|<pre>cd /usr/bin
cp /tmp/automysqlbackup-2.5.1-01.sh automysqlbackup
chmod 755 automysqlbackup}}</pre>
* Set ''automysqlbackup'' as a daily cron job (Optional):
{{Code|<pre>cd /etc/cron.dailyln -s /usr/bin/automysqlbackup}}</pre>
== Tips ==
Bigfoot65
Trusted, Bureaucrats, Administrators
12,424

edits

Retrieved from "https://wiki.amahi.org/index.php/Special:MobileDiff/95511"