WordPress.org

Ready to get started?Download WordPress

Forums

Can WordPress use MyISAM only? (6 posts)

  1. DesignerBill
    Member
    Posted 2 years ago #

    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?

  2. esmi
    Forum Moderator
    Posted 2 years ago #

    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.

  3. DesignerBill
    Member
    Posted 2 years ago #

    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?

  4. esmi
    Forum Moderator
    Posted 2 years ago #

    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.

  5. davidmstokes
    Member
    Posted 2 years ago #

    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!

  6. emilygrrl
    Member
    Posted 2 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic