Mysql check table...

4 posts / 0 new

Topic locked

Last post

#1 Sat, 06/27/2009 - 07:14

neorf

i've error when i start mysql server telling:

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

#2 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

#3 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

#4 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