URGENT - PLEASE HELP!!! How Do I change a Read only table in MYSQl to be writable?

I have a table that was transferred from another server, and it made it read only when it uploaded to the new server.

How can I set this table back to be writable?

The error I get is this:

Invalid SQL: DELETE FROM strikes WHERE striketime < 1113840509 mysql error: Table 'strikes' is read only

mysql error number: 1036

PLEASE HELP!!!
foreverditaAsked:
Who is Participating?
 
ThomasFrankeConnect With a Mentor Commented:
make sure the table data itself is writable for the mysql-process.

check the filesystem rights for the mysql-datadir. try a chmod on the directory and its contents.
don't forget to restart the mysql-service after changing the settings.
0
 
NeonDevilConnect With a Mentor Commented:
I found this, hope it helps:
If you encounter "ERROR 1036: Table 'xxx' is read
only", this may be due to a corrupt internal setting in
MySQL. This can occur if, for example, you upload a
new table from a Windows-based MySQL database
directly to a Linux/Unix database. The solution is to
use 'dumpmysql' to dump the databases, THEN be
sure to DROP TABLE for the 'read only tables' or the
internal config will not be properly reset! Deleting the
table files is not sufficient. Once the tables are
dropped, feed the dump file back to mysql, and it will
create the tables anew, and they will be writable.

got it from:
http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/INSERT.html
0
 
kupra1Commented:
You should use mysqldump to dump the database from your another server to this new server.  
After that drop those tables which are read only. Once you drop the tables, use the mysqldump again to dump your database.
This will create the writable tables.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.