cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New

How to disable Read Only option for Mysql Server

Hi

How can i disable read only option?

 

When I enter my site, there is problem with database connection: Error displaying the error page: Application Instantiation Error: The MySQL server is running with the --read-only option so it cannot execute this statement...

 

I checked conf file in Joomla directory. Everything is OK. And i ca'nt do nothing in phpMyAdmin.

Please help. How to disable Read Only option for Mysql Server ?

10 REPLIES 10

Re: How to disable Read Only option for Mysql Server

The same thing happened to the site I manage a day ago,  but resolved itself after a few hours. It has happened again now.

I checked in mysqladmin and the server setting for 'read only' is showing up as 'on'.

 

Hopefully it will resolve itself again, but I would like to know why this happened and how to stop it. 

The server I am on is 166.62.8.13   Are you on the same server? 

Re: How to disable Read Only option for Mysql Server

Just been chatting to GoDaddy support. Looks other people have been reporting the problem since the 9th.  They are working on it.  No ETA. 

 

Re: How to disable Read Only option for Mysql Server

10 hours later and they have not resolved the problem.  Not impressed.

New

Re: How to disable Read Only option for Mysql Server

I have just chatted with Godaddy support team. They answered that: ‘As per the error that were getting here, we currently have an ongoing issue about MySQL database. Our team is working on it now to fix the issue‘.

Re: How to disable Read Only option for Mysql Server

Well, it is now over 36 hours and my site is still dead.  Seriously unimpressed.

Re: How to disable Read Only option for Mysql Server

I am having the same issue...

"SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --read-only option so it cannot execute this statement"

Was working fine at 8:30 EST Friday Nov 11 

Now receiving this error 7:00 EST Sat Nov 12

Also not impressed.

Also checked and Read Only variable set to ON

I will contact GoDaddy.  

 

New

Re: How to disable Read Only option for Mysql Server

I have 6-7 sites in this server.

What did I do?
Opened new database.
Copied from SQL my database, witch I backed up 1 months ago (I can't backup current DB).

Edited configuration file of site.

Site is working...
But some of my sites still dead

Re: How to disable Read Only option for Mysql Server

I don't understand how that worked for you. 

The server has been set to read only, so did you change servers? 

 

Re: How to disable Read Only option for Mysql Server

Oh, I get it. 

Creating a new database automatically chose a different server without asking!

I am trying your trick now. Thanks for the tip. 

Re: How to disable Read Only option for Mysql Server

my site keeps doing this Smiley Sad i added a bunch of widgets yesterday to add some more educational tools. is this why?