need some mysql help here
 

i've copyed the files of a mysql database from a server to another (server1: /var/lib/mysql/database/files to server2: /var/lib/mysql/database/files)

i can access the database on the new server but all the tables are read only.. i made a chown mysql /var/lib/mysql/database/files and chmod 777 /var/lib/mysql/database/files but all tables are still in readonly format.. what do i have to do so i can have full access on the database on the server2?

thanks

Did you copy the files while mysql was still running? That would be why they are read-only. You should stop the mysql service before copying database files.

You can also try doing a FLUSH TABLES.

make sure the group setting is correct chown user:group or chgrp

Try to see if the mysql account you're using has enough permissions to write.

wouldn't it have been better/easier to use mysql dump?

That's my thought too

exactly...why would you copy files?

export and import the database....thats the only reliable way to do it...mysql keeps its system catalogs in tablescopying files is a sure way to get those ginked up.