[Solved] MySQL error 1036: table is read only

When you create a new table, and you insert it with some rows, but you get these error. It’s mean that your new table can’t be write. Otherwise, your other old tables is fine, writable.

Instead of change your mysql folder permisson, you might to:


Change your new table Storage Engine. You can do it on Operation menu on your phpmyadmin or other mysql visual administrator. Compare it with your old tables Storage Engine.
In my case, my new tables Storage Engine is default set to MRG_MYISAM. My old tables is InnoDB. So I change my new table Storage Engine to InnoDB, then it works, writable.

Categories: IT | Tags: , | 4 Comments

Post navigation

4 thoughts on “[Solved] MySQL error 1036: table is read only

  1. Kavya

    Thanks.. Your post helped me.

  2. jthinksabout

    Thank you very much it did help me a lot

  3. thanks . it works ..

  4. Thank you for this post.

Tinggalkan Jejakmu berupa komen

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: