Currently I backup my MyISAM tables every night by running a shell
script that does the following:
Run:
Mysqlanalyze, mysqlrepair, mysqloptimize on all the tables
Then shutdown mysql
Then tar all the .MYI, .MYD and .frm files from the database's directory
to a backup director Start MySQL again.
Later on an outside backup device connects and backs up the tar file for
archiving.
Question:
Is it safe to do this without actually shutting down the mysql db?
Perhaps putting a write lock on all the tables first so that they can be
read but not written to during the tar. Does it matter if I'm tar'ing a
file while mysql has it open?
Thanks,
Jeff
