[HELP]MySQL Tables read-only

[untold4you]

I'm moving to a new server and offcourse i want to move my vb, now i've uploaded all my mysql tables to the new server. When i do a 'analyze' on a table it keeps on saying that the table is read only. Does anyone know how i can make those tables readable again?

Tnx in advance!

Gr3³Tz...

[filburt1]

Maybe the table has a lock on it. I don't know exactly what that means or how to fix it, so that was helpful, but I know it can block a table from access.

[untold4you]

What i did was, i took a backup of the mysql files itself, meaning the .MYD, MYI and .frm files. And copied these onto my new server. Hmm maybe i'll have a look on how i can do it thru ssh. I guess i would have to take a complete backup in .sql format or not ?

[untold4you]

Found a nice program to do the job, Navicat www.navicat.com