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?
Can WordPress use MyISAM only? (6 posts)
-
DesignerBill
Posted 1 year 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.
-
Posted 1 year 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?
-
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.
-
davidmstokes
Posted 1 year 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!
-
emilygrrl
Posted 1 year 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.
