Bug #21323 There should be a unix command to check the database.

• Submitted: 27 Jul 2006 21:20
• Modified: 2 Aug 2006 5:05
• Reporter: Dave Yost
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.22
• CPU Architecture: Any
• Tags: Backup, check, integrity, verify

[27 Jul 2006 21:20] Dave Yost

Description:
There should be a simple way to verify the integrity of the data files all at once, with the database quiesced.

How to repeat:
Try to figure out how to do this from reading the docs.

Suggested fix:
A new command:

mysql/support-files/verify

would pause the database, check everything, then resume the database.

See also
http://bugs.mysql.com/bug.php?id=21309

To prevent use of this command as a denial-of-service attack, execute permissions on the command must be restricted.

[27 Jul 2006 21:32] Jim Winstead

Sounds like mysqlcheck to me.

http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html

[2 Aug 2006 1:41] Dave Yost

mysqlcheck requites a root password on the command line, no?  That would make it unsuitable as part of a backup script.

[2 Aug 2006 1:42] Dave Yost

mysqlcheck requires a root password on the command line, no?  That would make it
unsuitable in a backup script, which is the intended use.

[2 Aug 2006 5:05] Jim Winstead

mysqlcheck can read the password from a configuration file.

http://dev.mysql.com/doc/refman/5.0/en/password-security.html