Problem with "read-only" tables Mysql

Muageto

I am currently working on a port from a MySQL 3.23.49 database running on Windows to a MySQL 4.0.12 running on Mac OS X.

When and I copy and paste the .frm, .myd and .myi and try to make an update to one of the bases MySQL says the table is read_only.

I've changed the permissions to 777 on all tables and for user mysql.

I'm working on it for 3-4 hours now and I haven't even find where the problem comes from.

Please Help

superwormy

You shouldn't be copying those files.

Dump the database with mysqldump at the command line ( or use phpMyAdmin ) and reload it with the source command in MySQL ( or use phpMyAdmin )

Muageto

What do you mean exactly by "source command" ??

superwormy

Are you on a *nix system?

At shell prompt, type mysql

Enter username, password

use yourdatabasenamehere
source /full/filepath/to/source/sql/file.sql

It'll run any SQL command in 'file.sql' on whatever database you are using.

Use mysqldump at the shell prompt to dump your database ( send it to a file by using > /path/to/file.sql ) and then reload it with teh srouce command from inside mysql.

Hope that helps.

Search Google too...
http://www.devarticles.com/art/1/62/2
http://www.juicystudio.com/tutorial/mysql/start.html

Muageto

Thanks a lot