WordPress.org

Ready to get started?Download WordPress

Forums

iThemes Security (formerly Better WP Security)
Restore from a backup made with Better WP Security (22 posts)

  1. Sassinack
    Member
    Posted 1 year ago #

    How do I restore from a backup made with Better WP Security?

    Thanks!

    http://wordpress.org/extend/plugins/better-wp-security/

  2. Lawn Dude
    Member
    Posted 1 year ago #

    Great question, I came looking for the answer.
    Will it restore content in widgets.

  3. Big_Rich
    Member
    Posted 1 year ago #

    Did you find out how to restore from a Better WP Security backup yet?

  4. Lawn Dude
    Member
    Posted 1 year ago #

    No not yet, if this backup/restore service works easily and well I will not need to subscribe to another backup plugin.

  5. flashbuddy
    Member
    Posted 1 year ago #

    I don't see where there is a restore backup facility within BWPS. I would expect that one would have to retrieve the backup file (from email attachment or from /wp-content/plugins/better-wp-security/backups) and manually restore via phpMyAdmin (or similar).

  6. Lawn Dude
    Member
    Posted 1 year ago #

    Thank you for responding, I was also wondering before I invest the time and money in more software if they were thinking of adding a restore feature in the near future, possibly even as a premium feature. Do management ever respond to these posts?
    Cheers, Happy St. Valentines Day

  7. flashbuddy
    Member
    Posted 1 year ago #

    My experience is 'seldom'.

  8. Handoko
    Member
    Posted 1 year ago #

    Yes, they seldom. I think the plugin author is too busy coding and fixing bugs. That's why we come here to help each others.

  9. funsail
    Member
    Posted 1 year ago #

    So anyone know?
    I have the backup zip file. I cna't restore it

    phpMyAdmin says
    MySQL said: Documentation
    #1046 - No database selected

  10. Handoko
    Member
    Posted 1 year ago #

    I think I know your problem. That kind of error usually happens if you're trying to restore a database backup file without choosing a database.

    The correct steps to restore a backup database using phpMyAdmin:
    1. Login to your cPanel.
    2. Click phpMyAdmin.
    3. On the right panel, click the database you want to restore.
    4. You may need to delete all records or tables before import.
    5. On the menu (top) click Import.
    6. Click choose to browse the file.
    7. Click go to start the process.
    8. Done.

    The #1046 error will happen if you do not perform step no. 3.

    Sometimes, you may need to delete existing records even tables, that why you need step no. 4.

    Good luck.

  11. funsail
    Member
    Posted 1 year ago #

    OK that worked now, thanks.
    My site is still dead tho, so I guess I didn't expect it was a DB fault.

  12. Handoko
    Member
    Posted 1 year ago #

    My site is still dead tho, ...

    Is there any error message?

  13. LingoSam
    Member
    Posted 11 months ago #

    My site is still dead tho, so I guess I didn't expect it was a DB fault.

    I assume you've fixed this as the post is quite old, but to anyone else that has killed their site, this might be useful:

    Did you change the database prefix using the Better WP Security plugin after creating the backup you are restoring?

    If so:

    Open the file called 'wp-config.php' which is located in the site root, and look for the bit called '$table_prefix ='. You need to change the prefix here to match the one from the backup, more than likely it will need to be changed to 'wp_' (the standard install prefix) and re-uploaded to the site.

    Otherwise, your site is trying to find a database that isn't technically there anymore.

    At the same time, delete the file in the root called .htaccess. This is an important file, you can get WordPress to restore it once your back in by going to Settings>Permalinks and hitting Save again.

  14. Handoko
    Member
    Posted 11 months ago #

    Very useful! This forum need people like you, welcome to this forum. Thanks for sharing your knowledge.

  15. zebra4
    Member
    Posted 11 months ago #

    While changing the database prefix using the Better WP Security plugin things went wrong. I was redirected to the wordpress install.php page. I installed WP again.

    I then restored my backup. But only my home page is loading. For all other pages I get a Not Found error.

    In phpmyadmin I see that my tables have been duplicated. The original tables wp_ and the same tables with a new prefix created by the Better WP Security plugin.

    I have changed the table_prefix in the wp_config file to the new prefix and deleted the .htaccess as described by LingoSam. But that didn't fix it.

    How can I fix this? Do I have to delete the duplicated tables?

    Thanks in advance!

    Steven

  16. zebra4
    Member
    Posted 11 months ago #

    Site is up again.

    Changed Settings -> Permalinks from Post Name option to Default option. Then back to my custom settings. Uploaded htaccess.

    Steven

  17. Handoko
    Member
    Posted 11 months ago #

    Glad to hear your website is up again.

    Yes, you should delete the duplicates. But remember, do backups before you delete.

  18. gilbert87
    Member
    Posted 7 months ago #

    wow! i am glad i found this! i have some question.

    how do you find the prefix set by better wp security in the backup? my wp-config is set to wp_ but i need to key in the actual prefix from the backup to get it working right?

  19. gilbert87
    Member
    Posted 7 months ago #

    i deleted the .htaccess file and now i cant enter my wp-admin.. T_T

  20. Handoko
    Member
    Posted 7 months ago #

    .htaccess file is a very important file. You should restore it.

  21. gilbert87
    Member
    Posted 7 months ago #

    i am confused... Didnt lingo sam say delete the .htaccess file?

  22. Handoko
    Member
    Posted 7 months ago #

    Okay, I see.

    You said you can't access your wp-admin. What was the error message? Have you tried yourwebsite.com/wp-login.php ? Normally you should login via wp-login.php not wp-admin directly.

    Do you remember, did you change the database prefix? If no, everything should working correctly.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic