bobcooper Posted November 21, 2008 Share Posted November 21, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/133638-solved-wordpress-mysql-structure/ Share on other sites More sharing options...
JasonLewis Posted November 21, 2008 Share Posted November 21, 2008 Open phpMyAdmin, if you have it, and you can look at the structure for the tables through that. Quote Link to comment https://forums.phpfreaks.com/topic/133638-solved-wordpress-mysql-structure/#findComment-695266 Share on other sites More sharing options...
bobcooper Posted November 21, 2008 Author Share Posted November 21, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/133638-solved-wordpress-mysql-structure/#findComment-695372 Share on other sites More sharing options...
SharkBait Posted November 21, 2008 Share Posted November 21, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/133638-solved-wordpress-mysql-structure/#findComment-695700 Share on other sites More sharing options...
bobcooper Posted November 22, 2008 Author Share Posted November 22, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/133638-solved-wordpress-mysql-structure/#findComment-696133 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.