View previous topic
::
View next topic
|
Author |
Message |
ramon fincken Site's programmer
 Get a free globally recognized avatar It's free!
Joined: 03 Aug 2007 Posts: 412 Location: A'dam/Diemen, The Netherlands
|
Posted: Sat Feb 20, 2010 3:04 pm Post subject: [solution][ubuntu] ubuntu mysql #1036 - Table 'xx' is read only |
|
|
I moved some database files from my backup to my ubuntu pc with mysql running.
So far so good. I visited PhpMyadmin, database is there and tables too jay
But when deleting, editing/ adding some row/entry I got stuck with this message:
Code: | Mysql Said #1036 - Table 'xx' is read only |
The solution is this:
-
Move your files to /var/lib/mysql/[database_name]
Now . make sure every directory/file is owned by Mysql and NOT root or your username !
Exit nautilus
Code: | $ sudo service mysql restart |
And you're done!
Read on:
http://ubuntuforums.org/showthread.php?t=411338
http://www.bigresource.com/Tracker/Trac...-ZZHBnJJf/ |
|
Back to top |
|
 |
Google adsense Advertisement
|
Posted: Sat Feb 20, 2010 3:04 pm Post subject: [solution][ubuntu] ubuntu mysql #1036 - Table 'xx' is read only |
|
|
Advertisement
|
|
Back to top |
|
 |
GravityForms Advertisement
|
Posted: Sat Feb 20, 2010 3:04 pm Post subject: [solution][ubuntu] ubuntu mysql #1036 - Table 'xx' is read only |
|
|
Advertisement
 |
|
Back to top |
|
 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|
|