[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:

changestorageengine

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.

Advertisements
Categories: IT | Tags: , | 3 Comments

Post navigation

3 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 ..

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

Blog at WordPress.com.

%d bloggers like this: