HelioHost Posted March 2, 2018 Posted March 2, 2018 Username: alexteal, Server: Johnny, Main domain: tealcraft.com I've made a new database but its still saying its in read only mode :/ https://prnt.sc/ilwn9k I cant work out how to edit the database to MyISAM ________________________________
Krydos Posted March 2, 2018 Posted March 2, 2018 Change lines like this CREATE TABLE `oxtb_accounts` ( `account_id` mediumint(9) NOT NULL, `account_type` varchar(16) NOT NULL DEFAULT '', `account_name` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; to CREATE TABLE `oxtb_accounts` ( `account_id` mediumint(9) NOT NULL, `account_type` varchar(16) NOT NULL DEFAULT '', `account_name` varchar(255) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
alexteal Posted March 2, 2018 Posted March 2, 2018 Ok, I've updated my download to have that. Is there a date for when the servers go back on to Read & Write?
Krydos Posted March 2, 2018 Posted March 2, 2018 We'll post it on the news here at helionet, facebook, and twitter. MyISAM tables are read/write already. Just InnoDB tables are read only.
alexteal Posted March 2, 2018 Posted March 2, 2018 Is there a way i can upload my backup with MyISAM or do i have to wait untill everything is back up?
wolstech Posted March 2, 2018 Posted March 2, 2018 Just create a new database, then go into PhpMyAdmin and import the edited .sql file. Then configure whatever software is using the database to use the new one instead.
alexteal Posted March 2, 2018 Posted March 2, 2018 When I upload my backup I get this error. https://prnt.sc/im10d6
Recommended Posts