database - How to backup my site and restore my wordpress site

admin管理员组

文章数量:1291732

My site, 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?

My site, http://www.forerunnerintl 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?

• database
• backup

Share Improve this question edited Oct 12, 2016 at 20:28 Thom asked Oct 12, 2016 at 20:11 ThomThom 15711 silver badge1010 bronze badges 1

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

Add a comment  | 

3 Answers 3

Sorted by: Reset to default 1

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.

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.

You can use free migration plugins

1. https://wordpress/plugins/wp-clone-by-wp-academy/
2. https://wordpress/plugins/all-in-one-wp-migration/

本文标签： databaseHow to backup my site and restore my wordpress site