Title: WordPress Database Backup Plugin Last modified: August 18, 2016 --- # WordPress Database Backup Plugin * [skippy](https://wordpress.org/support/users/skippy/) * (@skippy) * [20 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/) * Announcing the WordPress Database Backup Plugin: [http://www.skippy.net/blog/2005/07/12/wordpress-database-backup/](http://www.skippy.net/blog/2005/07/12/wordpress-database-backup/) * This is an easy-to-use plugin to quickly backup your WordPress database. You may download the backup file, or have it emailed to the address of your choice. Viewing 15 replies - 16 through 30 (of 74 total) [←](https://wordpress.org/support/topic/wordpress-database-backup-plugin/?output_format=md) [1](https://wordpress.org/support/topic/wordpress-database-backup-plugin/?output_format=md) 2 [3](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/3/?output_format=md) [4](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/4/?output_format=md) [5](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/5/?output_format=md) [→](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/3/?output_format=md) * Thread Starter [skippy](https://wordpress.org/support/users/skippy/) * (@skippy) * [20 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/2/#post-234606) * See Podz’s response, immediately above mine. If you’re using FTP, tell us which FTP client you use and we’ll try to help. * [oncidium](https://wordpress.org/support/users/oncidium/) * (@oncidium) * [20 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/2/#post-234607) * Well I thought I had a revelation…but then more problems. Part of the issue is that there was no backup folder in the wp-content directory. I created a new folder named “backup” then right clicked on it and enabled read/write and execute for owner only. That did get rid of the “not writable” error. Then when I tried to back it up I got a TON of errors: * A bunch of these: Warning: fwrite(): supplied argument is not a valid stream resource in: a database error and a few of these * Warning: fwrite(): supplied argument is not a valid stream resource in /home/ content/c/h/e/cherylkemp/html/blog/wp-content/plugins/wp-db-backup.php on line 155 * It is such a long list I wasn’t sure whether I should post it here or not. I usually just use the “my network places” in windows for ftp and I also have Frontpage 2003, although I haven’t really been suing it much since I got WordPress going… easier just to do the simple ftp. * Thanks. * [oncidium](https://wordpress.org/support/users/oncidium/) * (@oncidium) * [20 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/2/#post-234608) * It also give this statement: Backup Successful! Your backup file: cherylkemp_wp_20050802_797. sql should begin downloading shortly. * then this after I click the link cherylkemp…etc: Forbidden You don’t have permission to access /blog/wp-content/backup/cherylkemp_wp_20050802_797.sql on this server. * Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. * [pineapplemike](https://wordpress.org/support/users/pineapplemike/) * (@pineapplemike) * [20 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/2/#post-234609) * installed it. when i look at the downloaded file, should it look all messy? * [oncidium](https://wordpress.org/support/users/oncidium/) * (@oncidium) * [20 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/2/#post-234610) * Oh…sorry I didn’t try this sooner. I had checked all of the following boxes for additional components: You may choose to include any of the following tables: sk2_blacklist snipe_gallery_cat snipe_gallery_data snipe_gallery_frames wp_bad_behavior_log wp_sk2_logs wp_sk2_spams * If I don’t check any of them, it works. It would be great though if there is a way to do it all at once. * Sorry for the multiple posts * Thread Starter [skippy](https://wordpress.org/support/users/skippy/) * (@skippy) * [20 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/2/#post-234611) * pineapplemike: did you select gzip compression? If you did, then yes it should look messy. Unzip it first. * oncidium: did you read the included wp-db-backup.txt ? I explain the documentation why I will not support automatic selection of all the additional tables. * [oncidium](https://wordpress.org/support/users/oncidium/) * (@oncidium) * [20 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/2/#post-234612) * no I didn’t read it but I will. * Guess that means there is no easy way…with that many errors there is no way I can figure it out (nor would it be worth the timek). I think I finally did get myPHP to save it like I wanted. I just want to make sure when I switch servers, I don’t mess anything up. * Thread Starter [skippy](https://wordpress.org/support/users/skippy/) * (@skippy) * [20 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/2/#post-234613) * There’s no reason to backup the following tables if you’re moving servers: sk2_blacklist wp_bad_behavior_log wp_sk2_logs wp_sk2_spams * All of the information in those tables is likely to change with some regularity. * [TH](https://wordpress.org/support/users/th/) * (@th) * [20 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/2/#post-234615) * In wp-db-backup 1.5 I get the error message: * “The script to backup your database is too large for PHP to load entirely into memory, and so cannot be compressed within PHP. Your database was too large to compress. Your backup has been saved uncompressed.” * I read on Skippy dot net about PHP memory limit, but that can’t be it because I have don’t have more than a few posts. Besides… It worked before. I think it stopped working when I upgraded to the latest version. Any ideas why? I guess I don’t need to have it zipped, but it’s a bit annoying that the gzip feature is always selected. I just know that I’ll try it once each time before I remember to uncheck it. * [tqn69](https://wordpress.org/support/users/tqn69/) * (@tqn69) * [20 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/2/#post-234616) * TH, I have exactly the same problem: very small number of total posts; initially the plugin compressed my .sql backups; now (starting a week later) it returns the “too large for PHP to load entirely into memory” message. What gives? * The changed behavior very likely coincided with my upgrading to version 1.5. * I’d love to know if this can be fixed. * [hooverdst](https://wordpress.org/support/users/hooverdst/) * (@hooverdst) * [20 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/2/#post-234617) * TH and tqn69, yeah I’ve had the same problem (I’m running WP 1.5) but if I uncheck the gzip feature, I don’t get the error. * [tqn69](https://wordpress.org/support/users/tqn69/) * (@tqn69) * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/2/#post-234618) * Hoover, agreed. However, I prefer getting a compressed backup since I’m having them sent daily to my Gmail account. It’d save bandwidth. * [hooverdst](https://wordpress.org/support/users/hooverdst/) * (@hooverdst) * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/2/#post-234621) * tqn69, yeah I know what you mean. I’m sure Skippy will fix the issue in the next release. * [TH](https://wordpress.org/support/users/th/) * (@th) * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/2/#post-234622) * Well… HooverDST, I’m sure you’re right about that. This all indicates that there are more of us with this problem. For once I think I have actually been the victim of a bug and not my own stupidity (that tends to screw up even the most simple directions). * [tqn69](https://wordpress.org/support/users/tqn69/) * (@tqn69) * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/2/#post-234626) * 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/](http://asymptomatic.net/wp/2005/07/22/1775/wp-database-backup-v15/) Viewing 15 replies - 16 through 30 (of 74 total) [←](https://wordpress.org/support/topic/wordpress-database-backup-plugin/?output_format=md) [1](https://wordpress.org/support/topic/wordpress-database-backup-plugin/?output_format=md) 2 [3](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/3/?output_format=md) [4](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/4/?output_format=md) [5](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/5/?output_format=md) [→](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/3/?output_format=md) The topic ‘WordPress Database Backup Plugin’ is closed to new replies. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * 74 replies * 29 participants * Last reply from: [xyverz](https://wordpress.org/support/users/xyverz/) * Last activity: [19 years, 5 months ago](https://wordpress.org/support/topic/wordpress-database-backup-plugin/page/5/#post-234729) * Status: not a support question ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics