Can I reset wordpress without losing posts, comments, media and widgets?

admin管理员组

文章数量:1025218

I a having too many errors on my blog recently. I tried everything (including posting in this forum), but couldn't sort it out. Would it be possible to reset my WordPress website without losing posts, comments, media and widgets?

I have installed a plugin called WordPress Database Reset, but not sure about what options I should pick to keep posts, media, etc.

I a having too many errors on my blog recently. I tried everything (including posting in this forum), but couldn't sort it out. Would it be possible to reset my WordPress website without losing posts, comments, media and widgets?

I have installed a plugin called WordPress Database Reset, but not sure about what options I should pick to keep posts, media, etc.

• reset

Share Improve this question edited Sep 7, 2016 at 18:45 Ethan Rævan 4,02955 gold badges2727 silver badges5555 bronze badges asked Sep 7, 2016 at 12:54 justinajustina 2111 silver badge22 bronze badges 1

• Has this question been resolved? – Ethan Rævan Commented Sep 13, 2016 at 19:39

Add a comment  | 

4 Answers 4

Sorted by: Reset to default 1

Would it be possible to reset my WordPress website without losing posts, comments, media and widgets?

First thing first, please make a backup before make permanent changes...

If you want to keep just your posts, comments, media and widgets these tables are ones you do not want to reset:

• wp_post and wp_postmeta - pages, posts, media, custom posts, etc
• wp_comments and wp_commentmeta - all comments
• wp_options - widgets

Also, if you reset wp_users table, make sure you can login...

Looking at your screenshot above, the plugin you have installed should be able to do it. In order to keep your posts & media and comments you would need to leave out the posts, postmeta and comments options. The one related to postmeta will contain everything to do with who posted it, post id, media included etc, although I would advocate the option I set out next, as it is less likely to mess everything up.

A separate option is install a fresh copy of WordPress, and then export your current blog into your new one. This will mean you can keep everything you need, but you get a fresh database etc to use.

The options are under Tools --> Export to export the blog (you can pick what to export) and Tools --> Import to bring everything into your new WordPress install (This does require a plugin, but it is mentioned on the import page).

No.

Data is spread around, and the name of the table is not a very good indication of where the data in it is used. Any core table you delete might end up in unusable site.

1. Back up your entire database and files first.

2. Use the export functionality that comes native with WordPress to download all of your posts, media, and widgets.

3. After you've finished exporting everything you want to keep, follow the instructions in this link to uninstall and re-install WordPress.

4. Once you're finished, use WordPress Importer to import all those files back into your system.

It's all gravy from there.

I a having too many errors on my blog recently. I tried everything (including posting in this forum), but couldn't sort it out. Would it be possible to reset my WordPress website without losing posts, comments, media and widgets?

I have installed a plugin called WordPress Database Reset, but not sure about what options I should pick to keep posts, media, etc.

I a having too many errors on my blog recently. I tried everything (including posting in this forum), but couldn't sort it out. Would it be possible to reset my WordPress website without losing posts, comments, media and widgets?

I have installed a plugin called WordPress Database Reset, but not sure about what options I should pick to keep posts, media, etc.

• reset

Share Improve this question edited Sep 7, 2016 at 18:45 Ethan Rævan 4,02955 gold badges2727 silver badges5555 bronze badges asked Sep 7, 2016 at 12:54 justinajustina 2111 silver badge22 bronze badges 1

• Has this question been resolved? – Ethan Rævan Commented Sep 13, 2016 at 19:39

Add a comment  | 

4 Answers 4

Sorted by: Reset to default 1

Would it be possible to reset my WordPress website without losing posts, comments, media and widgets?

First thing first, please make a backup before make permanent changes...

If you want to keep just your posts, comments, media and widgets these tables are ones you do not want to reset:

• wp_post and wp_postmeta - pages, posts, media, custom posts, etc
• wp_comments and wp_commentmeta - all comments
• wp_options - widgets

Also, if you reset wp_users table, make sure you can login...

Looking at your screenshot above, the plugin you have installed should be able to do it. In order to keep your posts & media and comments you would need to leave out the posts, postmeta and comments options. The one related to postmeta will contain everything to do with who posted it, post id, media included etc, although I would advocate the option I set out next, as it is less likely to mess everything up.

A separate option is install a fresh copy of WordPress, and then export your current blog into your new one. This will mean you can keep everything you need, but you get a fresh database etc to use.

The options are under Tools --> Export to export the blog (you can pick what to export) and Tools --> Import to bring everything into your new WordPress install (This does require a plugin, but it is mentioned on the import page).

No.

Data is spread around, and the name of the table is not a very good indication of where the data in it is used. Any core table you delete might end up in unusable site.

1. Back up your entire database and files first.

2. Use the export functionality that comes native with WordPress to download all of your posts, media, and widgets.

3. After you've finished exporting everything you want to keep, follow the instructions in this link to uninstall and re-install WordPress.

4. Once you're finished, use WordPress Importer to import all those files back into your system.

It's all gravy from there.

本文标签： Can I reset wordpress without losing postscommentsmedia and widgets