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

Posted on 2005-04-18
Last Modified: 2011-08-18
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

Question by:foreverdita
    LVL 1

    Assisted Solution

    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:
    LVL 10

    Expert Comment

    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.
    LVL 6

    Accepted Solution

    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.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (…
    More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now