Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: guestHH on August 23, 2002, 01:59:10 AM

Title: mysql backup
Post by: guestHH on August 23, 2002, 01:59:10 AM

Anybody any comment/suggestions/reommedations on this:
http://worldcommunity.com/opensource/utilities/mysql_backup.html

Regards,
guestHH

Title: Re: mysql backup
Post by: Darrell May on August 23, 2002, 04:32:22 AM

The standard SME backup script (/sbin/e-smith/backup) already performs a complete mySQL backup to /home/e-smith/db/mysql using these built-in events:

/sbin/e-smith/signal-event mysql-delete-dumps
/sbin/e-smith/signal-event mysql-dump-tables

Darrell

Title: Re: mysql backup
Post by: Geoff Bennion on September 04, 2002, 12:48:54 PM

or

mysqldump dbname > filename

or

mysqldump -A > alldbsfilename