Support » Fixing WordPress » Export posts from mysql

  • Resolved carnold


    How do you export only and all the posts from the mysql database? Is it wp_posts? Looking to delete all my posts and then restore them back 1 by 1.

Viewing 11 replies - 1 through 11 (of 11 total)
  • Carnold,

    If your prefix is “wp_” then yes your post are stored in “wp_posts”. However when you are restoring, please note that the following tables will also have to be updated properly so that things don’t break.



    So, i was going to just delete all the posts via the WP adminpanel but i should be able to “drop” the contents of wp_posts using phpmyadmin (your plugin by the way and very nifty one). I have also backed-up the entire database using phpmyadmin, just in case.
    *EDIT* Ooppss. Get this error when trying to restore the DB:
    Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 14016534 bytes) in /srv/www/htdocs/somefolder/libraries/read_dump.lib.php on line 91

    Thanks for that (about the plugin)!!!

    I don’t quite get what you will do. You have backed everything up and are going to do a drop on the ‘wp_posts’ table. Then what? What is your purpose in redoing the posts table?

    Well, i think i have a post issue that pushes my posts down when using IE (mozilla and others show fine but not IE). I have done a validator and do not have any open div’s or the like that would cause this. So, i am thinking i must have a “post/image width” problem. When users are using IE and have a screen resolution of 1024×768 or less, the posts are pushed down. If they “up” their resolution past 1024×768, posts are put back the way they are suppose to be. So, i thought i would delete all the posts and then restore them back 1 by 1 to see which one is the problem post/image.
    In case you meet the requirments,


    Before you do that you might want to check 2 other areas because purging the DB seems quite extreme. I looked at you site in both browsers and noticed the following.

    1)The calendar is expanding beyond it’s div boundary
    2)Your google ads are expanding beyond their div boundary

    This is seen in FF while IE basically lets everything move and thus your posts float to the bottom.

    Just a suggestion as these may not be the problem.

    Hope it does work though!

    Nice call, slipstream!!! I knew the calendar was part of the problem but i removed it and had the same problem. But with the removal of calendar and google ads, now it looks right. Do you mind going back and verifying that it looks right in your browsers? Thanks again!!

    I went back to your site but the calendar section had the following error:

    Warning: bp_draw_column(/srv/www/htdocs/wp-content/themes/bloxpress2/blocks/calendar.php) [function.bp-draw-column]: failed to open stream: No such file or directory in /srv/www/htdocs/wp-content/themes/bloxpress2/system/bloxpress.php on line 143

    Warning: bp_draw_column() [function.include]: Failed opening ‘/srv/www/htdocs/wp-content/themes/bloxpress2/blocks/calendar.php’ for inclusion (include_path=’.:’) in /srv/www/htdocs/wp-content/themes/bloxpress2/system/bloxpress.php on line 143

    You might want to fix this before we try to check again.


    The error I mentioned is still there, but if I close the calendar box then everything looks good. Guess you won’t need to redo the DB now… lol…

    Yea, the calendar is back working now and did not have to redo the DB. I did, however, delete about 30 posts before the fix 🙁
    Do you know of a way to bust open the backup db.sql file to restore the posts i deleted? I have looked through phpmyadmin and dont see a way short of importing the whole DB again.

    The db.sql file can be opened in a normal text editor. It should contain the sql statements in individual lines, so you can just choose the line pertinent to the posts you want to restore and copy them to the ‘SQL’ box in phpMyAdmin to execute them individually. Let me know if you need help with this in case you don’t know your was around the db.

    By the way, it might be better to close this post and mark it resolved and to start a new one with a new title like ‘Need help restoring specific posts from backup’. We’ve moved away from your initial topic and starting a new one can make it easier for other users to search and use the information later.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Export posts from mysql’ is closed to new replies.