WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Database Backup Plugin (75 posts)

  1. tqn69
    Member
    Posted 8 years ago #

    Guys, I found something that will help. Looks like someone has updated the code in Skippy's absence (he's on vacation apparently). I've installed this and gzip works again (Whoopee!), and allows really huge blogs to be backed up irrespective of the server's memory limits. Apparently the file is being hosted at the moment at redalt.com

    Asymptomatic » Blog Archive » WordPress Database Backup v1.5
    http://asymptomatic.net/wp/2005/07/22/1775/wp-database-backup-v15/

  2. I believe that Skippy's v1.5 of the plugin already includes the changes made by Owen in his v1.5:

    http://www.skippy.net/blog/category/wordpress/plugins/wp-db-backup/

  3. skippy
    Member
    Posted 8 years ago #

    No, Owen's 1.5 is different from my 1.5. Tricky, isn't it?

    I've literally just finished fixing a few (small) bugs introduced by Owen's rewrite, as well as introducing a few small new features.

    I plan to release 1.6 either tonight or tomorrow.

  4. TH
    Member
    Posted 8 years ago #

    That is exciting news, skippy! Thank you!

  5. Dgold
    Member
    Posted 8 years ago #

    Skippy, since you're working on it now, I have a little suggestion for your Installation Instructions. I got it through trial-and-error.

    Step #3 of your instruction... Clarify... Change to "Put wp-db-backup.php in your wp-content/plugins folder, and put the other 2 (?) files in the wp/content/backup/ directory you created. Then go to your Admin>Plugins page and Activate the plugin." It was confusing to me, admittedly new at this, when the Installation Instructions included the line:

      "Install and activate the plugin."

    I never had to do Step #2. I was afraid of that step before downloading, because I knew I did not understand. Where would I type those commands, if I needed to?

    I love the plugin so far. It was MUCH easier to install than I feared when I was reading-up on it. Thank you.

    Installation

    Please be sure to read the installation instructions included in the zip file. For the impatient, here they are:

    1. Create a directory /wp-content/backup/ inside your WordPress directory.
    $ cd wordpress/wp-content
    $ mkdir backup
    2. Make this directory writable by your webserver.
    $ chgrp www-data backup
    $ chmod g+w backup
    3. Insall and activate the plugin
    4. Navigate to Manage -> Backup
    5. Backup!

  6. Lorelle
    Member
    Posted 8 years ago #

    And for those worried about "size issues" ;-) with their backups, with the latest version I was able to gzip over 30 megabytes of WordPress database stuff.

    Worked like a charm!

    Thanks ringmaster and skippy for this brilliant plugin. Backing up WordPress Database is so darn easy now.

  7. skippy
    Member
    Posted 8 years ago #

    Note that when Lorelle says "latest version", she is in fact referring to the unreleased version that I said was coming soon.

    Lorelle was kind enough to help me test this plugin through its development, and she continues to get dibs on the new versions. =)

  8. tqn69
    Member
    Posted 8 years ago #

    Well I can't wait for 1.6 then.

  9. skippy
    Member
    Posted 8 years ago #

  10. tqn69
    Member
    Posted 8 years ago #

    Huzzah! Great work Skippy and Owen. I have been looking for this kind of functionality since I adopted WordPress. And I'm sure other WP users had the same need. Thank you very much for your terrific work.

  11. HooverDST
    Member
    Posted 8 years ago #

    Yeah you guys rock! It's people like you that keeps this whole community that much better :)

  12. TH
    Member
    Posted 8 years ago #

    Great! Thank you!!! This has become quite an impressive plugin! I wouldn't be surprised if you are asked/begged to have it included in the next WordPress version.

    Personally I find MySQL commands about as easy to understand as ancient Egyptian hiroglyphs, so I would be helpless without this kind of help.

  13. Dennisabm
    Member
    Posted 8 years ago #

    <confused mode ON>

    OK, I've placed the wp-db-backup.php file in my /wordpress/wp-content/plugins folder, created a /wordpress/wp-content/backup folder (checking with my webhost tech support folks to make sure it was set to writeable), activated the plugin and hit BACKUP. Nothing happens...the progress bar just sits at one tick. I've tried all three options, email/download and save to folder...same results.

    What incredibly simple/silly step am I missing?

    <confused mode OFF>

  14. skippy
    Member
    Posted 8 years ago #

    Can you please check your webserver's error log for any interesting information? I've received at least two other reports of this behavior, but no one has yet been able to show me any error logs to help me diagnose it. Since I can't reproduce the error, there's nothing I can do until I get some clue as to the cause.

  15. Dennisabm
    Member
    Posted 8 years ago #

    I tried to run the backup again and then looked in the errorlog for the last entry:

    [Sat Aug 13 16:35:15 2005] [error] [client 68.164.226.137] File does not exist: /var/www/html/wordpress/wp-content/themes/redpageformat/divider.gif

    I'm in way over my head, but that doesn't seem like that is the problem to me. There were 4 files in the plugin zipfile I downloaded from you...was there a purpose for the PowerPoint template file and the .MO file? Was I to copy them into a folder somewhere?

    Like most of my issues, I won't be suprised to find this is yet another "mindware" problem. :)

  16. Beel
    Member
    Posted 8 years ago #

    Don't think that has anything to do with the plugin.

  17. skippy
    Member
    Posted 8 years ago #

    The .pot file is not a PowerPoint template, but a source file used to provide localized translations of the plugin. The .mo file is also used for translating the plugin's display.

    Please double check your error log. Feel free to send the whole thing to me, and I'll parse it for relevant information. You have my solemn promise that I'm not interested in any kind of malfeasance -- I merely want to debug my plugin.

  18. Jack
    Member
    Posted 8 years ago #

    I'm having some difficulties with this plugin, and several questions I'm afraid :).

    I installed several plugins. A few of them are wp-cron and short-stats. First I tried making a backup including the two tables that short-stats had created in the database. But when I import the file in a dummy database, the two tables of short-stats are not there?

    When disabling the wp-cron plugin and short-stats I get a error message at the bottom of my testpage:

    WordPress database error: [Table 'spoenk.wp_ss_stats' doesn't exist]
    INSERT INTO wp_ss_stats (remote_ip,country,language,domain,referer,resource,user_agent,platform,browser,version,dt) VALUES ('127.0.0.1','Indeterminable','en-us','','','/spoenk/index.php?p=375','Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.10) Gecko/20050716 Firefox/1.0.6','Windows XP','Firefox','1.0.6',1124021878)

    while I did NOT include those tables.

    Also a question about character encoding. My site has always been encoded iso-8859-1. Now when making a dummy database I get the option to what charset/encoding I want to set the database (collate?) and when importing I get some same question about what kind of encoding the sql-file is. I find this all very confusing, and when testing the results I can see that something is wrong there because all my é and è are now question marks.

    One final question and perhaps the most important one:
    When I export my database using the phpmyadmin from my provider I get a sql-file of 797 Kb. When I use gzip and extract this file on my computer I get a sql-file of just 392 Kb. And when looking at the extracted version of the backup that wp-backup has made I get a sql-file of just 294 Kb. In the last two cases a whole lot of posts are missing! Only in the first case I get a good backup, the rest seems to be broken.

    Am I missing something here?

  19. Jack
    Member
    Posted 8 years ago #

    Correction: Some of my problems must have to do with a wrong setup of that dummy database, because when importing the zipped backupfile directly into my online beta-website everything seems to be OK, but still I don't understand it. When I open both files (the sql-file of 797 kb and the 294 kb file) and search for a word from one of the posts, I can find that word in the first but not in the smaller file.

    Needless to say I don't trust the second file at this moment :(.

  20. nmallory
    Member
    Posted 8 years ago #

    Is there a way to set this up to do the backup 2x a week rather than nightly?

  21. skippy
    Member
    Posted 8 years ago #

    nmallory: no, it's daily or not at all. That kind of variable delay is more trouble than it's worth to include in WP-Cron.

    moxie: I made two backups, one using phpMyAdmin with the default export settings, and one using WP-DB Backup. I selected only one additional non-core table for both of them. The gzipped downloads are 539K (phpMyAdmin) and 561K (WP-DB Backup).

    Unzipped, the files were 1.7M (phpMyAdmin) and 1.7M (WP-DB Backup).

    The contents of the backup files are slightly different. phpMyAdmin uses --- as a comment, whereas WP-DB Backup uses #. WP-DB Backup is also slightly more verbose in its commenting.

    If you'd like to send me your backups, I can try to compare them to see what's missing, and where. This is the first report that I've heard that some data gets lost.

  22. korereactor
    Member
    Posted 8 years ago #

    Skippy,

    On the main backup page, in the Backup Options section, I'm showing the following error:

    WordPress database error: [You have an error in your SQL syntax near '-_wordpress' at line 1]
    SHOW TABLE STATUS FROM korereactor_com_-_wordpress

    Warning: Invalid argument supplied for foreach() in /wp-content/plugins/wp-db-backup.php on line 754

    Any ideas on how to fix? The backup does seem to work fine, would just like to get rid of the error message. Thanks!

  23. skippy
    Member
    Posted 8 years ago #

    SHOW TABLE STATUS FROM korereactor_com_-_wordpress -- the dash in the table name is technically illegal. I don't know how you got that dash in there, but my experience has always been that dashes are bad.

    The foreach error most likely is the result of an empty table. Do all your tables have rows in them? (I thought we had fixed this with 1.6, but perhaps not.)

  24. skippy
    Member
    Posted 8 years ago #

    Update: dashes are legal in database names as long as you use backticks around the name. Guess what WP-DB Backup forgot to put around database names?

    A new version should be released shortly. This new version should also hopefully help those folks with the "stuck" status bar. Stay tuned.

  25. korereactor
    Member
    Posted 8 years ago #

    Looking forward to it. Thanks!

  26. skippy
    Member
    Posted 8 years ago #

    I've just released WP DB Backup v1.7! If you had trouble with 1.6, please try this version!

  27. korereactor
    Member
    Posted 8 years ago #

    Works perfectly now! Great work! Thanks!

  28. bianca
    Member
    Posted 8 years ago #

    I installed WP-Backup a few days ago to work with WP-Cron. the scheduled backup worked fine the first few days but since then I am receiving several emails in one day with a backup database. Often it is the exact same email sent multiple times. Has anyone else had this problem?

  29. skippy
    Member
    Posted 8 years ago #

    bianca: I've been using WP-Cron to drive WP-DB-Backup since July, and I've only received duplicate emails once. It was last night when the time went back an hour for Daylight Savings Time.

  30. Vryce
    Member
    Posted 8 years ago #

    Up until today, I've never received duplicate emails. For some reason, last night with the time change, I received 10-15 duplicates.

    No big deal, they were easy enough to delete.

    But I have been extremely happy with the plugin and using it the past few months.

    This is one great plugin.

Topic Closed

This topic has been closed to new replies.

About this Topic