WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Backup to Dropbox
[resolved] Version 1.2.2 No Longer Backing up Database (18 posts)

  1. sclough
    Member
    Posted 1 year ago #

    For some reason the latest version of this plugin is no longer backing up my database. I don't see a sql file in the backup folder on the server and the on in my Dropbox account is dated July 31st.

    http://wordpress.org/extend/plugins/wordpress-backup-to-dropbox/

  2. maurisrx
    Member
    Posted 1 year ago #

    So do I. I don't see any database file in my dropbox account. Is it bug or the feature has been removed?

  3. maurisrx
    Member
    Posted 1 year ago #

    Just found this on another support thread

    I found this in the FAQ:
    "Where is my database SQL dump located?
    The database is backed up into a file named '[database name]-backup.sql'. It will be will be found at the path 'wp-content/backups' within the App folder of your Dropbox."

    I found mine

  4. sclough
    Member
    Posted 1 year ago #

    Yes, but see my original post. Mine hasn't been updated since July 31st. It's not updating the SQL backup.

  5. Michael De Wildt
    Member
    Plugin Author

    Posted 1 year ago #

    How big is your database?

    Are you getting any errors in the Plugin, WordPress or Server logs?

  6. sclough
    Member
    Posted 1 year ago #

    Well, the last sql backup I have (dated July 31) is only 3.1 MB so the database can't be that big.

    No errors in the server logs I have access to. When I go to the plugin page it just says the backup ran. Any idea where else I could look for errors?

  7. Michael De Wildt
    Member
    Plugin Author

    Posted 1 year ago #

    3.1 megabytes for a small blog sounds about right. My blog is only 3.9 megabytes and my other site around 500k.

  8. scruffy1
    Member
    Posted 1 year ago #

    same here no longer working

    Backup error on 2012-09-07 at 08:58:18: Exception - Error creating sql dump file.
    Backup started on 2012-09-07 at 08:58:09
    Backup error on 2012-09-07 at 08:38:26: Exception - Error creating sql dump file.
    Backup started on 2012-09-07 at 08:38:17

  9. scruffy1
    Member
    Posted 1 year ago #

    the big problem is you have no idea it has failed as no error message shows unless you click on the settings to see the history.

  10. sclough
    Member
    Posted 1 year ago #

    On my setting page is says it completed successfully. It shows no errors, it just doesn't create a new sql dump file.

  11. MyMacGuffin
    Member
    Posted 1 year ago #

    Same issue but with added complications. No SQL (or any) backup since Aug 28, as per the 'wp-content/backups' list in Dropbox/Apps:

    1. The settings link has disappeared on the plugin page. It just shows 'deactivate' and 'edit'.

    2. After deactivating/reactivating and then deleting and reinstalling this plugin, there is still no apparent way to access 'settings' or solve the problem as to resuming daily backups.

    Now running WP 3.4.2 but the problem started before upgrade. Also I recently installed some additional plugins as an extra layer to stop persistent bots and spammers, including an IP Filter and Bad Behaviour. They're doing the job but just wondering if these are contributing to the problem in some way.

    Help please....

  12. MyMacGuffin
    Member
    Posted 1 year ago #

    Okay, ignore my first post - solved (hopefully)! Always right after one presses 'post'...sigh..

    I forgot that access to backup settings is via the WPB2D tab on the main menu bar on the left of the dashboard. However, what became apparent is that one has to re-authorise the Dropbox link AFTER upgrading to 1.2.2....

    Duly authorised...move along citizens...back to work, nothing doing here.

    Yeah. I know. PIBKAC.

    [Problem Is Between Keyboard And Chair]

  13. MyMacGuffin
    Member
    Posted 1 year ago #

    ...and also then reschedule backups. I suspect that I needed to do this after reinstalling the plugin, so this may only apply if you resorted to that measure.

  14. Michael De Wildt
    Member
    Plugin Author

    Posted 1 year ago #

    Gday all....

    The error "Exception - Error creating sql dump file." is usually due to file permissions, yo u need to make sure that the wp-content/backups directory is writable by the server.

    Thanks for your feedback regarding logging, Better logging is now the most requested feature that I plan to better in the next release.

    Cheers,
    Mikey

  15. scruffy1
    Member
    Posted 1 year ago #

    my folder is set to 755 there is no way on this planet i will set it to 777, the thing is it worked before so why would it suddenly stop working?

    the other thing is the little bit of wording telling us to get a coffee should also report the error there as i left it for 2 hours + not knowing it was even working frustrated ! lol

    thanks

  16. sclough
    Member
    Posted 1 year ago #

    Ok, the more I look at this, the issue isn't that it's not creating a sql file, it's not doing the backup at all. However, when a backup runs the admin page shows this:

    Backup completed on 2012-09-09 at 09:38:14
    Backup started on 2012-09-09 at 09:38:13

    There is nothing in my error logs, but nothing is backing up. Any ideas where to start? I've used this plugin a long time and not had an issue for a long time.

  17. Katherine Semel-Munson
    Member
    Posted 1 year ago #

    I'm also not seeing a sql dump generated on the server, but the rest of the files are backed up properly.

    I'm getting these error message in my WP debug.log which look related. (Log messages slightly modified to keep my system info private):

    PHP Notice: Undefined index: dump_location in /wp-content/plugins/wordpress-backup-to-dropbox/Views/wp-backup-to-dropbox-options.php on line 43

    WordPress database error Table 'MY_DB_NAME.wp_sitecategories' doesn't exist for query SHOW CREATE TABLE wp_sitecategories made by do_action_ref_array, call_user_func_array, run_dropbox_backup, WP_Backup->execute, WP_Backup_Database_Core->execute, WP_Backup_Database->backup_database_tables

    WordPress database error Table 'MY_DB_NAME.wp_sitecategories' doesn't exist for query SELECT COUNT(*) FROM wp_sitecategories made by do_action_ref_array, call_user_func_array, run_dropbox_backup, WP_Backup->execute, WP_Backup_Database_Core->execute, WP_Backup_Database->backup_database_tables

    This is happening only on a blog within my WP network with 1.2.2. It works with 1.2 on that blog and the 1.2.2 code appears to work on a standalone blog as well.

  18. Michael De Wildt
    Member
    Plugin Author

    Posted 1 year ago #

    I am closing this thread because a lot of these issues should have been fixed in the latest version.

    If not please repost the issue in a new thread.

    Cheers,
    Mikey

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic