Re: Backing up MySQL tables
2003-04-05 14:26:07
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
|
|
|