Jump to content

MySQL Query Help

Recommended Posts

  • 2 weeks later...
  • 4 years later...

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

  • 3 weeks later...

Yes it is safe, but I went thru some problems... Here is one of them


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

  • 3 months later...
  • 1 month later...
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...