alein Posted February 27, 2018 Share Posted February 27, 2018 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 Quote Link to comment Share on other sites More sharing options...
wolstech Posted February 28, 2018 Share Posted February 28, 2018 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. Quote Link to comment Share on other sites More sharing options...
alein Posted March 1, 2018 Author Share Posted March 1, 2018 ALTER TABLE table_name ENGINE = MyISAM not working Quote Link to comment Share on other sites More sharing options...
wolstech Posted March 1, 2018 Share Posted March 1, 2018 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. Quote Link to comment Share on other sites More sharing options...
alein Posted March 3, 2018 Author Share Posted March 3, 2018 (edited) i fix it now thanks you Edited March 3, 2018 by alein Quote Link to comment Share on other sites More sharing options...
alexteal Posted March 4, 2018 Share Posted March 4, 2018 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Krydos Posted March 4, 2018 Share Posted March 4, 2018 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. Quote Link to comment Share on other sites More sharing options...
michaeltim Posted March 5, 2018 Share Posted March 5, 2018 In my case, mysql config file had innodb_force_recovery = 1. Commenting that out solved the issue. Hope it helps someone. Quote Link to comment Share on other sites More sharing options...
wolstech Posted March 5, 2018 Share Posted March 5, 2018 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. Quote Link to comment Share on other sites More sharing options...
alein Posted March 7, 2018 Author Share Posted March 7, 2018 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 Quote Link to comment 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.