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