Mysql check table...

4 posts / 0 new
Topic locked
Last post
#1 Sat, 06/27/2009 - 07:14
neorf

Mysql check table...

i've error when i start mysql server telling:

  • Checking for corrupt, not cleanly closed and upgrade needing tables.

i'd want to use: mysqlcheck --repair --all-databases

how can i do via ssh? i use mysql -u username -p password -h localhost but then shell tells: password db doesnt exist?

thanks

neorf

Sat, 06/27/2009 - 10:48
andreychek

When MySQL starts on certain Linux distros, it does indeed say:

"Checking for corrupt, not cleanly closed and upgrade needing tables."

That in itself is not an error or warning, it's just checking things out.

Are you seeing an error message of some sort though?

If so, can you paste it in?

-Eric

Sun, 06/28/2009 - 07:31
neorf

i'm on ubuntu 8.04, and then i don't see any errors, everything seems to work. however to access mysql via shell, how could i do? just to know...

thanks

neorf

Sun, 06/28/2009 - 09:14
andreychek

To access MySQL via the shell, you can type:

mysql -u USERNAME -p

And then it'll prompt you for a password.

That'll give you the MySQL shell :-)

-Eric

Topic locked