Jump to content

MySQL Query Help

sychn
sychn
in Classic self-hosted technical help

Featured Replies

Posted

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!

 

    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.

    • 2 weeks later...
    • Author

    Thank you m8s, I tried to make a command list to batch excute it.

    • 4 years later...

    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

     

    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;
    •

    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;

    • 3 weeks later...

    Is it safe to upgrade to InnoDB from Myisam? 

    • Community Expert
     

    Is it safe to upgrade to InnoDB from Myisam? 

    Yes, it is safe. However, make a backup of your database before the conversion. 

     

    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.

     

    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

     

    • 3 months later...
    • 1 month later...
    Go to topic listing

    Recently Browsing 0

    • No registered users viewing this page.