I have a MySQL database with 71 tables. It houses news, galleries, slideshow data, page content, products, customers, shipping, discount codes, ( basically a full store build on a PHP shop).
I want to migrate over to WP. I’m new to wordpress, how easy/difficult will this be? I can do a SQL dump of the database easily. But how easy will it be to map the tables, structure and data to wordpress tables? Is there any plugin that can help?
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 1
Unfortunately it’s not really and easy process. It’s not about just having a table. The tables in WordPress will have different names, fields, and relationships than the cms you’re pulling your table from. That’s just for the content. Then to mirror appearance will definitely be starting over all the same.
It would likely be a much easier process to create a new wordpress install with a clean install and manually set up new pages with the old content.
Without knowing more about your current CMS or how much content you have I’d strongly suggest you go this route. Sorry for the bad news, but good luck and you’ll love wordpress.
UPDATE BASED ON COMMENT
While by no means an endorsement, you may want to check out wpallimport. It will let you set up imports based on CSV files and let you import them into any post type. It doesn’t have that steep of a learning curve, but it will even let you attach photos to the posts to update!
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0