Migrate a Non WordPress database to wordpress

The question:

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?

The Solutions:

Below are the methods you can try. The first solution is probably the best. Try others if the first one doesn’t work. Senior developers aren’t just copying/pasting – they read the methods carefully & apply them wisely to each case.

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

Leave a Comment