Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
46 lines (37 sloc) 1.32 KB
layout title date author categories modified_time blogger_id blogger_orig_url
post
automatic mysql backups
2012-06-14T15:10:00.000Z
Tim Abell
howto
mysql
linux
2012-06-14T15:12:25.991Z
tag:blogger.com,1999:blog-5082828566240519947.post-7356368576752162435

On a debian server with mediawiki installed and running with a local mysql.

root@myserver:~# apt-get install automysqlbackup

root@myserver:~# crontab -e

# m  h  dom mon dow   command
  5  4  *   *   *     automysqlbackup

root@myserver:~# automysqlbackup
root@myserver:~# cd /var/lib/automysqlbackup/
root@myserver:/var/lib/automysqlbackup# find .
.
./weekly
./weekly/wikidb
./weekly/information_schema
./daily
./daily/wikidb
./daily/wikidb/wikidb_2012-06-14_16h03m.Thursday.sql.gz
./daily/information_schema
./daily/information_schema/information_schema_2012-06-14_16h03m.Thursday.sql.gz
./monthly

Result! No longer need to write a custom cron script each time.

Ducklings at henley-on-thames

Project homepage: http://sourceforge.net/projects/automysqlbackup/

You can’t perform that action at this time.