I'm shortly going to be recieving an SQL dump of a wordpress website with a few thousand posts, attachments to those posts and so forth.

I am building a bespoke user based website with PHP and mySQL backend.

Does anyone have any experience on how best, easily and efficiently to migrate posts from a wordpress SQL dump into a custom database?

From what I can see, wordpress puts everything in a posts table. This includes seperate entries for attachments and revisions.

Ideally on my setup I will be having a different table for posts, different table for attached files and a different table for categories. All inter-relational.

Any help or pointers to some information / tools would be great

Thanks for listening

 

Depending on the data structure you may be able to pull out data via CSV, (via PHPMyAdmin). You may find some data that can't easily be abstracted, in which case you may need to install Wordpress, connect it to the databse, then write some templates (XML or CSV) to grab the data that way.

Thanks for the reply. I'll see how it goes when the time comes