19.10.2009 20:49, Tim Legg kirjoitti:
Hello again!
I would like to shutdown mysql periodically to make backups of the
databases. I would like to know what is the official Debian way of
stopping and restarting MySQL.
You might also consider a backup method which does not require MySQL to
be stopped. Here's what I use, as I have some InnoDB tables:
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
For some databases, daily:
#!/bin/bash
OF=/data/smb1/backups/mysql/important-$(date +%Y%m%d).sql.bz2
mysqldump -u backup -psecret --databases verses finance Calendar
domestic music MasterDirectory | bzip2 > $OF
or all of them, less often:
#!/bin/bash
OF=/data/smb1/backups/mysql/databases-$(date +%Y%m%d).sql.bz2
mysqldump -A -u backup -psecret | bzip2 > $OF
All my databases are human-driven and the backup jobs run when nothing
else will be happening, so I don't bother locking things, but you
obviously can. This all happens at the database level, so there's no
flushing to disc to worry about.
If you use phpMyAdmin, that can also backup and restore databases online
remotely using a browser, but I don't think it can be scripted locally.
--
Joe
--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
