WordPress.org

Support

Support » Installation » Can WordPress use MyISAM only?

Can WordPress use MyISAM only?

  • DesignerBill

    @designerbill

    I’m new to WordPress and have developed a site on my local PC. I now need to migrate it to my web host. Most of the WP MySQL tables are set to use the InnoDB engine, but my hosting company supports the MyISAM engine only. What does this mean for my ability to migrate the database to the web host? Can I modify the database so all the tables use MyISAM only?

Viewing 5 replies - 1 through 5 (of 5 total)
  • esmi

    @esmi

    Forum Moderator

    I wouldn’t recommend it. Try exporting all of your content from your local site via Tools->Export and importing it into your remote site via Tools->Import.

    DesignerBill

    @designerbill

    Thanks for your reply. Do I need to re-install WP on the remote site, or could I just copy all the files and folders from my PC with FTP and then import the content? If I reinstall, how do I keep WP from creating InnoDB tables? Will it work ok with MyISAM tables and is there a configuration option to use MyISAM only?

    esmi

    @esmi

    Forum Moderator

    Do I need to re-install WP on the remote site

    No.

    could I just copy all the files and folders from my PC with FTP and then import the content?

    You could upload the current theme folder and possibly any plugins you were using but anything else would be pointless. All of your site’s content is stored in the database.

    Will it work ok with MyISAM tables

    Yes

    is there a configuration option to use MyISAM only

    Yes but that’s normally selected/chosen when you set up the database.

    Please note that as of MySQL 5.5 the default storage engine for MySQL is InnoDB. And please upgrade to 5.5 as it is 20% faster than 5.1!

    Wouldn’t it be simple to just extract the db into a .sql file and find/replace /innodb/myisam/ ?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Can WordPress use MyISAM only?’ is closed to new replies.