sychn Posted June 13, 2016 Share Posted June 13, 2016 Hi, m8s, I tried to change the storage engine to InnoDB of my tables, but some of my tables are large and it returns 500 error. Does anyone know how to do it by 1000 lines per round? ALTER TABLE core_search_index ENGINE=InnoDB; Thanks! SeNioR- 1 Link to comment Share on other sites More sharing options...
MADMAN32395 Posted June 13, 2016 Share Posted June 13, 2016 500 error? are you doing this through the SQL Toolbox or something else? I personally use mySQL Workbench to get stuff done; easier than having to worry about timeouts or various other webserver errors. Link to comment Share on other sites More sharing options...
ASTRAPI Posted June 13, 2016 Share Posted June 13, 2016 Just run it from ssh MADMAN32395 1 Link to comment Share on other sites More sharing options...
sychn Posted June 27, 2016 Author Share Posted June 27, 2016 Thank you m8s, I tried to make a command list to batch excute it. Link to comment Share on other sites More sharing options...
media Posted September 12, 2020 Share Posted September 12, 2020 what is SSH (command line) code for this???? I have same problem I have access to command line but i need to know what code to run? Thanks Link to comment Share on other sites More sharing options...
Afrodude Posted September 12, 2020 Share Posted September 12, 2020 1 hour ago, media said: what is SSH (command line) code for this???? I have same problem I have access to command line but i need to know what code to run? Thanks ALTER TABLE databasename.tablename ENGINE=InnoDB; media 1 Link to comment Share on other sites More sharing options...
media Posted September 13, 2020 Share Posted September 13, 2020 I was able to convert all my myisam tables to innoDB Here is a complete code for ssh mysql -u [username] -p Enter your password. Again, without the brackets, enter the command: use [databasename]; Enter the command: show tables; The run this: alter table [table_name] ENGINE=InnoDB; Link to comment Share on other sites More sharing options...
Iwooo Posted October 3, 2020 Share Posted October 3, 2020 Is it safe to upgrade to InnoDB from Myisam? IP-Gamers 1 Link to comment Share on other sites More sharing options...
Miss_B Posted October 3, 2020 Share Posted October 3, 2020 2 hours ago, Iwooo said: Is it safe to upgrade to InnoDB from Myisam? Yes, it is safe. However, make a backup of your database before the conversion. Link to comment Share on other sites More sharing options...
bfarber Posted October 5, 2020 Share Posted October 5, 2020 On 10/3/2020 at 4:16 AM, Iwooo said: Is it safe to upgrade to InnoDB from Myisam? Yes and it's strongly recommended. That said, you may wish to verify with your webhost that their MySQL configuration is optimized for InnoDB. Link to comment Share on other sites More sharing options...
media Posted October 5, 2020 Share Posted October 5, 2020 Yes it is safe, but I went thru some problems... Here is one of them Quote 2020-09-18 9:23:28 0 [ERROR] InnoDB: (Duplicate key) writing word node to FTS auxiliary index table. and i fixed it. I have repaired the DB using mysqlchecks Link to comment Share on other sites More sharing options...
IP-Gamers Posted January 6, 2021 Share Posted January 6, 2021 On 10/3/2020 at 11:16 AM, Iwooo said: Is it safe to upgrade to InnoDB from Myisam? I needed to transfer tables from innoDB to myISAM, no problems were found. Iwooo 1 Link to comment Share on other sites More sharing options...
Rick Vasquez Posted February 6, 2021 Share Posted February 6, 2021 https://www.percona.com/doc/percona-toolkit/3.0/pt-online-schema-change.html You should use pt-osc if you don't want to take downtime while doing this. Link to comment Share on other sites More sharing options...
Recommended Posts