[SOLVED] wordpress mysql structure

[bobcooper]

hi there,

 

I am trying to access information from the wordpress mysql database that I have set up on my domain. I am using amfphp to access the info, but I can't seem to find any information on the table structure of the wordpress database.

 

Does anyone know any information on this or where I can find out more?

 

Thanks,

 

Bob

www.bobcooper.org.uk

[JasonLewis]

Open phpMyAdmin, if you have it, and you can look at the structure for the tables through that.

[bobcooper]

Hi thanks for that, I have managed to get the table structure from the following address:

 

http://codex.wordpress.org/Database_Description

 

So I am now importing post_title and post_content from wp_posts and yes the blog details are there, the only problem is that the order is very strange and the posts are duplicated, I am assuming this is for different categories, but I can't figure out how to sort it out!

 

Cheers,

 

Bob

www.bobcooper.org.uk

[SharkBait]

I found it easier to export your posts etc in XML formatted to Wordpress' liking and import it via the admin panel.

 

If you don't have a full understanding of how the schema works for WordPress it will botch pretty good.

 

Importing via XML format will ensure posts/comments etc are still linked properly together

[bobcooper]

Ahhh, I figured it out, wordpress is set to save all revisions to a post as well which messes up the order, and adds duplicates.

 

Thanks for your help.

 

Bob

www.bobcooper.org.uk