common Posted August 15, 2010 Share Posted August 15, 2010 Hi On my xampp server's database I get the warning that my database is read-only when I try to insert something into a table. I think I may know what cause this, because I created an export/import app that exports/import important data to the database... How can I remove the read-only from the database, because I am scared that the same thing might happen to my server's database? And is there a mysql query that test if the database is read-only? Thanks in advance Quote Link to comment https://forums.phpfreaks.com/topic/210775-mysql-database-read-only/ Share on other sites More sharing options...
wildteen88 Posted August 15, 2010 Share Posted August 15, 2010 The table is not set to read only. It is most probably the mysql account you've logged into MySQL with, which doesn't have the necessary privileges for inserting records into the table. Quote Link to comment https://forums.phpfreaks.com/topic/210775-mysql-database-read-only/#findComment-1099501 Share on other sites More sharing options...
ignace Posted August 15, 2010 Share Posted August 15, 2010 Or you selected Archive as an export option which sets the Archive engine which is read-only. Quote Link to comment https://forums.phpfreaks.com/topic/210775-mysql-database-read-only/#findComment-1099503 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.