MySQL Error : Table 'datastore' is read only

[alein]

hello  when i  enter  to my site  that  i see error

 

in mysql  error

 

 

 

i want dns name to Link Domain mt4serv.com to helionet.org

 

can tell me what is it nameserves

 

thanks you

[wolstech]

InnoDB support is broken on Johnny: https://www.helionet.org/index/topic/31947-innodb-is-in-read-only-mode/

 

To add a new domain, use the name servers ns1.heliohost.org and ns2.heliohost.org.

[alein]

ALTER TABLE table_name ENGINE = MyISAM

 

not working

[wolstech]

Back the database up, then make a copy of the backup. Alter the copied .sql file in a text editor to change the engine to MyISAM, and import the altered copy into a new database.

 

In read only mode, you cannot drop your existing database, convert it, or edit it in any way.

[alein]

i fix it now thanks you

Edited March 3, 2018 by alein

[alexteal]

How can I import more than one table at once?

 

I either get the error Database in Read Only or theres duplicate files because only one table uploads at a time

Edited March 4, 2018 by alexteal

[Krydos]

The database backup should contain all of the tables in the entire database. You should only need to create an empty database through cpanel, and then import the one database .sql file and all of the tables will be there.

[michaeltim]

In my case, mysql config file had innodb_force_recovery = 1. Commenting that out solved the issue. Hope it helps someone.

[wolstech]

That's typically how it gets taken out of read only. The thing is, in our experience, when we do that, MySQL either won't start anymore, or just corrupts everything. In the past, we had to discard the innodb data to get it working again.

[alein]

How can I import more than one table at once?

 

I either get the error Database in Read Only or theres duplicate files because only one table uploads at a time

you can backup your sql Database

then by programs named is

 

Notepad++

 

open your sql file with this programs

 

fine this

ENGINE = InnoDB

change it with this

ENGINE = MyISAM

 

after you save change import the one database .sql

if you have big sql used bigdump.php

 

to import the database .sql if was big saiz

that only any help im here