Help with database problems

[neilbla]

My present host has moved servers and moved all my data. One databse is causing problems. The host has tried several times to move the database over again but still the same problems.
When checking database in phpmyadmin it checks out ok. But when i try to do a repair on the databse i am getting loads of errors.

Table 'ibf_adminmessage' is read only

Getting this read only error on most tables.

Anyone have any idea why this is. My host cannot sort this out.

neilbla Reviewed by neilbla on 15th Jun 2011. Help with database problems My present host has moved servers and moved all my data. One databse is causing problems. The host has tried several times to move the database over again but still the same problems. When checking database in phpmyadmin it checks out ok. But when i try to do a repair on the databse i am getting loads of errors. Table 'ibf_adminmessage' is read only Getting this read only error on most tables. Anyone have any idea why this is. My host cannot sort this out. Rating: 5

[Gavo]

Sounds like you need to chown the files in /var/lib/mysql/yourDB to mysql

If that doesnt fix it check the error log (maybe the filesystem was set to read only due to an error)

[neilbla]

Thanks gavo for the information. I cannot get into var/lib but i found another way of doing it. I created a new empty database and then copied all the tables from the old database into the new one and this sorted the problem.

All fixed.