Van wrote:
Greetings:
I have a 600M data file that never gets backed up. The following error
occurs in the cron job:
tar: /data/mysql/"my_db_name"/"my_large_table_name".MYI: file changed as
we read it
Is there a way I can set this one table to read-only prior to the backup
without affecting other db writes during this operation?
Thanks,
Van
Look at mysqlhotcopy.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]