AutoMySQLBackup Installation..
The install is as simple as editing a few variables in the AutoMySQLBackup file. The full setup is documented in the AutoMySQLBackup script file below the variables section..
Here is a quick minimum setup step by step..
1. Download automysqlbackup.sh and place it into your /etc/cron.daily directory or your home directory.
2. Edit (at least) the following lines :-
# Username to access the MySQL server e.g. dbuser
USERNAME=dbuser
# Username to access the MySQL server e.g. password
PASSWORD=password
# Host name (or IP address) of MySQL server e.g localhost
DBHOST=localhost
# List of DBNAMES for Daily/Weekly Backup e.g. "DB1 DB2 DB3"
DBNAMES="all"
# Backup directory location e.g /backups
BACKUPDIR="/var/backup/mysql"
# Mail setup
MAILCONTENT="quiet"
You can also run the script manually:
./automysqlbackup.sh.2.5
3. Make the file executable :- chmod u+rwx
4. Create the following directory.
/backups
5. That's it.. Now you can run it using the command line "./automysqlbackup.sh" or if it is in /etc/cron.daily it will run each day when cron runs.
but probably you will want to enable it in cron and run daily. You can just dump it in the /etc/cron.daily/ folder and you should be done. .
Myself I like to place it in /opt and create a symlink to the file (to help with future updates of the script):
ln -s automysqlbackup.sh.2.5 automysqlbackup.sh
and run it from cron by placing in /etc/crontab something like:
#MySQL Daily backup
45 5 * * * root /opt/automysqlbackup.sh >/dev/null 2>&1
Tags:
| How many users connected to the Database< Prev | Next >MySQL 5.4 Download |
|---|
