Hi Alex.

I something like the following before my amanda backup runs:

<snip>
d="`date +%d.%m.%Y`"
mysqldump --all -c database_name > "/path/to/backup/$d.sql"
</snip>

I have not had any problems (yet) ;)

Alex Thurlow wrote:

I need to start backing up MySQL tables on one of my machines, but I've heard that to you run the risk of table corruption if you just copy the mysql directory while MySQL is running. Stopping the database is not an option, and the only solution I've come up with is having another script do a mysql dump and then backing up that. It seems like a waste of time and resources to basically do 2 backups though. I was just wondering what anyone here does for MySQL backups on their own systems?

Alex Thurlow

--
# Bartho Saaiman
# Network Administrator
# Stellenbosch Automotive Engineering
# Tel :: 27 21 882 8820 x 215
# Cell :: 27 82 551 2703
# Email :: bartho @ cae.co.za