need some mysql help here

[alex79]

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

[Baker Rd]

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.

[com]

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

[FuqALot]

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

[MickeyG]

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

[GFX Wiz]

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

That's my thought too

[mikesouth]

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.