Currently I backup my MyISAM tables every night by running a shell
script that does the following:
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
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?