My site, http://www.forerunnerintl.org is down hard. It looks like a problem with Wordpress. I want to back up my posts, etc. and then wipe everything and restore it to a fresh wordpress instance.

Googling for backup and restore wordpress instance generated a zillion pages, but most are for backing up using a plugin or backing up all of the themes and everything else, which I wish to dump.

Some docs say my posts are stored in MySQL databases, but where? I haven't found them.

Also, I want to have a normal website for my root and move wordpress to a subdirectory when I pave and nuke the site.

So how do I backup just my posts and restore them in the new wordpress instance?

  • Themes are generally stored in the wp-content/themes directory. The database only holds the name of the theme currently in use. – Pat J Oct 12 '16 at 20:23

you can use this SELECT * FROM databasename.wp_posts in mysql to view all your post; Then export it and then on the new database you can import the post.

| improve this answer | |
  • OK, where's the wp_posts file? – Thom Oct 12 '16 at 21:01
  • 1
    Wp_posts isn't a file. It's a table. You would need to login to your providers cPanel (or equivalent) and use the DB admin tool to run the query. – Greg McMullen Oct 12 '16 at 21:17
  • For windows server: go to mysql and click on your database and expand the databse, you would see the wp_post table – Charles Xavier Oct 13 '16 at 17:15

Following the link you provided, I found the error message: Fatal error: Cannot redeclare class WP_Post in /home/forerunn/public_html/wp-includes/class-wp-post.php on line 22

First, I would not assume it's a corrupted database. (If it is, you can usually access the database through PHPmyadmin; that's how you would backup the database, all of it or select tables.)

Recall what you did right before you discovered the error. Did you add new plugins? Update Wordpress? Try to undo any changes to see if things work again. Then google that error message and see if any of the results match your situation.

| improve this answer | |
  • So, I see two databases blah_main and blah_wrdp1. Do I need both of these? – Thom Oct 13 '16 at 0:20
  • I wouldn't know without browsing through them both, but I would think "wrdp1" is short for "wordpress1". I would look for the wp_posts table there. – scott Oct 13 '16 at 15:40

You can use free migration plugins

  1. https://wordpress.org/plugins/wp-clone-by-wp-academy/
  2. https://wordpress.org/plugins/all-in-one-wp-migration/
| improve this answer | |
  • Not looking for a plugin – Thom Oct 13 '16 at 12:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.