Message-
From: Steve Staples [mailto:sstap...@mnsi.net]
Sent: Monday, September 13, 2010 7:03 AM
To: mysql@lists.mysql.com
Subject: Crashed Table - How to report/prevent?
Good day MySQL!
I had a table that crashed last night. There is a cron function that
goes out every 6 hours or so
Good day MySQL!
I had a table that crashed last night. There is a cron function that
goes out every 6 hours or so, that does a quick table backup (it's also
replicated, it's just something that we have running now). ANYWAY, I
think it crashed early in the evening, but when the backup ran, it
Why not use the mysql tool, mysqlcheck:
http://dev.mysql.com/doc/refman/5.1/en/mysqlcheck.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
From what I read, it puts a lock on the tables (read lock). the tables
in one of the databases are continuously being written/read/updated, so
I dont want to lock them if at all possible.
Are there any other ways?
Steve
On Mon, 2010-09-13 at 15:11 +0100, a.sm...@ukgrid.net wrote:
Why not use
On Mon, Sep 13, 2010 at 4:32 PM, Steve Staples sstap...@mnsi.net wrote:
From what I read, it puts a lock on the tables (read lock). the tables
in one of the databases are continuously being written/read/updated, so
I dont want to lock them if at all possible.
Are there any other ways?