Help - Search - Members - Calendar
Full Version: mysql databases and tables checker
The Planet Forums > Control Panels > cPanel/WHM
naiad
does ne1 know a mysql database/tables checker?

it's like a "check table and then repair if it's bad" checker for all tables/databases...

i have searched but no results icon_razz.gif
nsp
This is what I use
mysqlcheck --check --quick --auto-repair --all-databases -u root -p

Replace with yours
naiad
yes , i knew that...
but it's full of:

"The handler for the table doesn't support repair"

"warning : 1 client is using or hasn't closed the table properly"

"error : Couldn't fix table with quick recovery: Found wrong number of deleted records
error : Run recovery again without -q"

that's because ... icon_razz.gif
naiad
any other alternatives ? icon_smile.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.