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

Categories: IT | Tags: , | 1 Comment

Post navigation

One thought on “[Solved] MySQL error 1036: table is read only

  1. Kavya

    Thanks.. Your post helped me.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: