WordPress Database Backup
Announcing the WordPress Database Backup plugin!
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.
Click Manage -> Backup:
By default, the core WordPress tabels are backed up. You may select additional tables, if any, and choose how you'd like to receive your backup file. Then simply click Download!
But wait, that's not all!
If you also have WP-Cron installed, you'll be able to schedule daily backups of your database, sent direct to your Inbox!
Installation
Please be sure to read the installation instructions included in the zip file. For the impatient, here they are:
- Create a directory
/wp-content/backup/inside your WordPress directory.
$ cd wordpress/wp-content
$ mkdir backup - Make this directory writable by your webserver.
$ chgrp www-data backup
$ chmod g+w backup - Insall and activate the plugin
- Navigate to Manage -> Backup
- Backup!
- None
- This will save the database backup in your
/wp-content/backup/directory on your server. This is provided as a convenience only. Please do not leave your database backup files lying around! - The backup file will be emailed to the address you specify. Gzip compression is strongly encouraged. Once delivered, the backup file will be deleted from the server.
- Download
- The backup file will be sent to your browser, where you can save it to your local workstation. Gzip compression is strongly encouraged. Once downloaded, the backup file will be deleted from the server.
- PHP memory limit: server operators can limit the amount of memory a PHP script may use. If the size of your database backup exceeds this limit, the backup will not succeed.
- PHP time out: server operators can limit the amount of time for which a PHP script may run. If it takes longer than this amount of time to backup your database, the backup will not succeed.
- Email attachment file size limitations: many email providers do not accept email attachments greater than a certain size. If your database backup is excessively large, it may not make it to your Inbox.
- insufficient disk space: although extremely unlikely, if your server does not have space to store the temporary backup file, the backup will not succeed.
Delivery Method Details
The Fine Print
This plugin works for me. Currently, I have about 160 posts, with a little over one thousand comments. A gzip compressed backup of my database produced with this plugin is about 460 KB. This plugin was successfully tested on another blog with 1369 posts and 4000 comments. The gzipped backup file was ahout 1.3 megabytes, and was successfully emailed and downloaded. If you have a huge database (tens of thousands of posts and comments) this plugin may not work for you, for any of the following reasons:Please note that including the database tables for your plugins in the backup is likely to introduce any (or all) of the problems listed above. Plugins like user and statistics tracking, or spam filter logs, can grow to enormous sizes.
Finally, although this plugin works for me, I will not accept any responsibility for any problems that this may cause for you. Use this plugin at your own risk.
Download WP-DB-Backup 1.4 today!
Thanks go to the following people for helping me develop and test this plugin:
157 Responses to WordPress Database Backup
About | Policies | skippy.net
[...] Skippy has just released what has to be an essential plugin - Database backup. Given that if the host’s server went boom your files and replaceable but your posts and comments are not, you need this. Very easy install and very easy to use. No messing in phpMyAdmin, no cron jobs, just an efficient way to keep your data safe - and you do want that don’t you ? ¤ Read (1) [...]
[...] Essential for you WP-blog… a back-up plugin! [...]
WordPress backup
I’m imprerssed by the multitude of addins and plugins for WordPress. This morning I’ve installed two new plugins:
WordPress Database Backup
Plugin: WP-Cron
Very cool plugins that should save me some time!HonorTagProfessional...
Looks like a very cool plugin, using phpMyAdmin can be pain so I'll give this one a go.
Wow, one link from Matt's website and I find all kinds of useful plugins! Thanks very much for all the cool stuff. This backup will be particularly useful - I can just shove it into my gmail and not have to worry. I'm totally fed up of configuring cron jobs, too!
[...] [...]
[...] Skippy has created an awesome plugin for WordPress. It’s called WordPress Database Backup. With a few clicks you can either download a backup of your database or have it sent attached to an email. It’s a very quick and simple process. In addition, if you have Skippy’s WP-Cron plugin installed, you’ll get a bonus option for the WordPress Database Backup. Under Manage->Backup in your WP admin screen you’ll have the opportunity to schedule a daily backup of your database. [...]
Great work on this Skippy. Glad I could help out.
Something like this should be built right into the core if you ask me.
This is great and I'm going to download it now. Is there a way to use this to restore and/or move a database from one server to another?
I'm about to move my weblog to a new host and was wondering if I need to use phpMyAdmin to pull your backup into the new install.
Richard: at this time, WP-DB-Backup is a backup-only plugin. It will not restore the database. You'll still need to rely on phpMyAdmin (or some other tool) for that.
[...] Here’s a util to backup your wordpress database. [...]
[...] 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. By default, the core WordPress tabels are backed up. You may select additional tables, if any, and choose how you’d like to receive your backup file. This may also be used with the WP-Cron package from Skippy to receive daily backups automatically to your email. Thanks Photomatt [...]
Thanks guys. This is a lovely plugin.
[...] Awesome plug-in to backup your database. It emails them to your email account daily and no hassel. I created a new Gmail account just for that backup so all my sites get backed up daily and are sent to that email account. Pretty sweeet. [...]
Great! Just what I was looking for.
[...] This is a great plugin written by skippy. Make sure you download it. Its easy to install and use. Making backups of your blog is important. [...]
I can confirm is works with Dreamhost with no problems. Again superb job Skippy. I have some suggestions of course, when I have modded the plugin to allow for it I will email you the changes.
Very nice. Thanks
I get the following errors when I run this plugin. Did it work or not? FYI I modified my path below with "XXXXXXX/":
Warning: Invalid argument supplied for foreach() in XXXXXXX/wp-content/plugins/wp-db-backup.php on line 177
Warning: Cannot modify header information - headers already sent by (output started at XXXXXXX/wp-content/plugins/wp-db-backup.php:177) in XXXXXXX/wp-content/plugins/wp-db-backup.php on line 45
Warning: Cannot modify header information - headers already sent by (output started at XXXXXXX/wp-content/plugins/wp-db-backup.php:177) in XXXXXXX/wp-admin/admin.php on line 10
Warning: Cannot modify header information - headers already sent by (output started at XXXXXXX/wp-content/plugins/wp-db-backup.php:177) in XXXXXXX/wp-admin/admin.php on line 11
Warning: Cannot modify header information - headers already sent by (output started at XXXXXXX/wp-content/plugins/wp-db-backup.php:177) in XXXXXXX/wp-admin/admin.php on line 12
Warning: Cannot modify header information - headers already sent by (output started at XXXXXXX/wp-content/plugins/wp-db-backup.php:177) in XXXXXXX/wp-admin/admin.php on line 13
Awesome! Thanks, I've been looking for something like this!
Nice, 'cept that the plugin does not "remember" an email address or delivery option in the first section.
Aaron
Actually, the cron delivery appears to be fubar too:
Last WP-Cron Daily Execution: 1969-12-31 @ 07:00
Next WP-Cron Daily Execution: 1970-01-01 @ 07:00
Seems to work great! I did find a couple of things confusing, being a novice user: What are the two files wp-db-backup-en_US.mo and wp-db-backup-en_US.po that were in the zip file? The instructions didn't mention those. Tried with and without them in the plugin directory, but there doesn't seem to be a difference. Or is it?
Also, the instructions say "Included with this plugin is a supplemental plugin, wp-cron-db-backup.php..."
I did find this confusing for a little bit since it seems to indicate that this should be in the same download package. I see from this page here however that this is a separate download. Just a tad confusing for slow people like me.
Don't mean to be critical. I love this! Thank you!
Seems to work fine with my el cheapo 1&1 hosting. Nice job guys!
Hey Skippy,
Thanks for this awesome plugin, very user friendly. I've been waiting for such a convenient method of backing stuff up!
boles: My guess is that your backup included a table with no rows. The foreach() loop at line 177 iterates over all the rows in the table, so if there's no rows, the foreach() will generate an error. Feel free to email me, and we can diagnose this a little further.
Aaron: No, the plugin does not save your last backup action. I do not plan to add any, at this time. The WP-Cron "Last Run" messages will be corrected tomorrow. When WP-Cron runs the daily schedule, it will update the time stamp, and everything should look fine.
Tore: the .mo and .po files are for translating the plugin, for non-English users with localized installations of WordPress. You may safely delete them. As for
wp-cron-db-backup.php: the functionality provided by the supplemental plugin has been included into the file you downloaded. I will update the documentation to remove mention of the now-non-existentwp-cron-db-backup.php.Ok Skippy. It all makes perfect sense now. I was just sitting here thinking that this sort of programming is so far beyond anything I could ever even understand. Great that there are people like yourself out there who can provide this sort of thing wrapped in an easy to use interface. It really makes life a whole lot easier. Thanks again!
[...] Ну вот, пока мы тут ручками бэкапы писали, люди уже написали соответствующий плагин для Wordpress. Бэкап делается, естественно, только wordpress-овской базы, и, чтоб можно было это дело зашедулить, надо еще и WP-Cron поставить. [...]
[...] Url: http://www.skippy.net/blog/2005/07/12/wordpress-database-backup/ [...]
[...] You use Wordpress? You want to make backups of your database? You’re tired of the old-fashioned way of backing it up? Skippy.net now offers the WP Database backup Plugin. You can download the backup or have it e-mailed. [...]
I'm getting the same error as boles, error on the foreach.
117: foreach ($table_data as $row)
Tom: I can only guess that one of the tables contains no rows. Were you trying to backup any additional tables?
On my test blog, I just deleted all the comments and links. There is only one user, one category, and a single post. I was able to execute a backup without errors.
Can you provide me information about your server configuration, blog details, and what exactly you did when attempting the backup?
Great plugin, unfortunately I too am having the "117: foreach ($table_data as $row)" error. This is using just the default table selection, no extra tables were selected. Any ideas for a possible fix?
i got the same errors as tom etc.
was trying to backup additional tables. but the errors also appeared when only backuping the standard tables
skippy: I've just looked into the foreach issue seen by boles and tom (and also korereactor on the wp-forums)
I tried to reproduce here with an empty set of comments/posts on a new install and it all worked fine.
It looks like some versions of php will happily
foreachovernull- ignore the contents of theforeach loopand other's won't. :(I'm using 4.3.11 here and it foreach's over null's fine.
A quick workaround for anyone until this is fixed by skippy is to ensure that you have a least one post/page, one comment, and one link on your site. I suspect that comments/links are the likely culprits for most people.
[...] WordPress to the rescue! There’s a WordPress Database Backup Plugin that can easily download or email database backups to you, and when tied with WP-Cron (a cron-like plugin for automating stuff), it’s fully automatable! [...]
Great plugin..
fix for the "Warning: Invalid argument supplied for foreach()" bug is as follows:
Line 177 should read:
foreach ($table_data as $row) {
Above this, put:
if( !is_array( $table_data ) ) $table_data = array();
This ensures that the "foreach" loop has a valid array to work with even if it is empty.
Do daily backups sent to your email only include the default tables? It would be nice if it could send optional tables also. Maybe it already does this, but I wasn't sure.
Allen: from the wp-db-backup.txt:
Thank you so much for this. I will sleep easier at night knowing this is working for me. I was dreading trying to figure out how to back up my wp database after spending most of the last month on the wp/blog learning curve. Bless you!
Thanks, sorry didn't see that part... any plans for the ability to include plugin tables in automated backups in future versions?
Very nice plugin, thanks alot.
Wow. Worked perfectly the first time. And I'm having the backup sent to my Gmail address, where I don't need to worry about running out of space. Sweet.
Allen: At this time I have no plans to include additional tables in the scheduled backups.
[...] Going from words on backing up WordPress to action was as simple as downloading Skippy’s WordPress Database Backup. It’s a little rudimentary (it doesn’t allow for database restoration), but it works nonetheless. Backup, y’all. [...]
I downloaded and installed the zip, but when I
Navigate to Manage -> Backup
I don't get anything. There is a tab in the Admin Menu called Backup/Restore, and that interface looks the same as Mark's old Backup/Restore plugin.
In short, I can't see any of the screenshots shown here.
I downloaded 1.3 and it works great, but the 1.4 for download here is an entirely different plugin.
Really elegant work, thank you
[...] WordPress Database Backup — плагин бэкапа базы (в сочетании с другим плагином бэкап может быть автоматизирован) [...]
Hi there,
Great plugin. I installed it and backed up my DB, and it seems it worked fine, but I got the following messages:
Warning: Invalid argument supplied for foreach() in /var/www/html/wpblog/wp-content/plugins/wp-db-backup.php on line 177
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/wpblog/wp-content/plugins/wp-db-backup.php:177) in /var/www/html/wpblog/wp-admin/admin.php on line 10
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/wpblog/wp-content/plugins/wp-db-backup.php:177) in /var/www/html/wpblog/wp-admin/admin.php on line 11
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/wpblog/wp-content/plugins/wp-db-backup.php:177) in /var/www/html/wpblog/wp-admin/admin.php on line 12
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/wpblog/wp-content/plugins/wp-db-backup.php:177) in /var/www/html/wpblog/wp-admin/admin.php on line 13
I'm (almost) a newbie, so I'm not sure what all that mumbo-jumbo means... What gives?
Cheers,
Sylvain
Sylvain: please refer to these two comments:
http://www.skippy.net/blog/2005/07/12/wordpress-database-backup/#comment-2811
http://www.skippy.net/blog/2005/07/12/wordpress-database-backup/#comment-2818
I hope to release a fixed-up version shortly.
[...] A great automation tool for backing up your Word Press database can be found at Skippy.Net. Hats off to ya as this plugin makes me a little more lazier! Once the plugin is installed and you have created your first backup, you will have an option of downloading the gzip’d file or email to an address of your choice. Cheers! [...]
[...] to automate the backups. No responses to 'backup there sonny'. RSS feed for comments and Trackback URI for 'backup there sonny'. Leave aComment [...]
[...] 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. I just installed it on my blog. [Link] [...]
[...] I have recently started backing up my site using skippy’s excellent wp-db-backup plugin. If you don’t want to use a plugin to do your backups Podz has some excellent instructions for setting up a cron job to do the backups. [...]
[...] Vía Matt descubrí WP Database Backup que te permite definir tablas, seleccionarlas y además enviar el backup por mail; sin embargo hay un gran problema: no se asegura que funcione en bases de datos con miles de comentarios y posts. [...]
Seems to be a great plugin and will give it a try. But just one query.
If I'm not comfortable with using Wp-Cron, can I schedule my own cron job to run the plugin to backup and email the files?
big thx for this great and important plugin for wordpress.
respect n tanx!
[...] Personnellement, j’utilise les plugins de skyppy, qui permettent de faire chaque jour un backup automatique de la base de données Wordpress, et de la recevoir par email. Ainsi, je peux dormir sur mes deux oreilles [...]
nice! though the CRON Job feature isnt gonna do it for me...
[...] This revised plugin was originally written by Skippy, who is currently enjoying a road trip with the family. Be sure to give Skippy props for his effort. The plugin would be hosted at his site (link to v1.4), except he’s not here and Backup Week is already upon us. [...]
yk: if you have access to -- and are comfortable with -- real cron jobs, then this plugin is largely extravagent for you. You can run a daily or weekly cron job to call
mysqldump --opton your database.that's true. But I'm helping to administrate a friend's blog and she doesn't know any scripting nor programming.
As her hosting provider's cpanel has a very intiutive cron job interface, I was just hoping to utilise the "power" of real cron jobs and the ease of use of your plugin at the same time.
Nevertheless a very useful and great plugin for all, together with wp-cron.
[...] WP database backup plugin [...]
[...] Esta tarde me puse a moverle un poco al blog, antes de que se me ocurra cambiar de layout :D, quería probar el plugin de WP para hacer los respaldos de la BD - Wordpress Database Backup - todo se veía muy claro y fácil de hacerlo en las instrucciones pero nomas no pude :s por mas que cambiaba los atributos del directorio siempre me marcó… “WARNING: Your backup directory is NOT writable!” Asi que aún estoy sin resplados del blog, si alguien ya a utlizado este plugin le agradeceré su ayuda :P Después del éxito no obtenido, me pase a moverle al plugin de Sa.bros.us - sa.bros.us badge - plugin que permite mostrar los links de tu Sa.bros.us en tu blog o en cualquier otra pagina donde los quieras mostrar, a este le moví hasta lo que no debía y ahi quedo mas o menos como lo quería, ya quedará ó.O Buscando entre las paginas de las personas que usan sa.bros.us, para ver como implementaban el plugin, me tope con este post del blog de Jesusbet, donde explica como implementar los mini-post en tu blog, ya tenía rato con es curiosidad, pero no tenía pensado que fuera tan fácil de hacerlo, asi que me puse a moverle y despues de dos o tres ajustes quedaron, se ven bien monos xD, estos los utilizaré para cuando tenga algo interesante que postear y que no precisamente seria un post entero, algun link interesante, algun dato curioso, alguna duda, al desajuste mental :) algo por el estilo. Abajito de este post esta mi primer mini-post. El último cambio fue el agregar el radio.blog, como ayer fue dia de emepetres semanal y pase bobo, y hoy no ando nada inspirado para recomendar música, me puse lo que ha estado sonando estos días en mi winamp, por si te interesa ahi esta en el menu principal la opcion, con un solo click y se carga el radio.blog [...]
I, too, received warning message on line 177. I guess I can add a check for empty array before going to the loop, or disable warning message in PHP using error_reporting() function?
Hi. It is very very usefull plugin.
Thankyou very much.
Hi
I got this error when I went to the Manage -> Backup tab.
WordPress database error: [You have an error in your SQL syntax near '-_content' at line 1]
SHOW TABLE STATUS FROM xxxxx_-_content
Warning: Invalid argument supplied for foreach() in xxx/xxx/wp-content/plugins/wp-db-backup.php on line 763
It lists the tables to be backed up then spits this out then I'm still given the option to backup and the backup worked and downloaded. Ant Ideas?
hi, great work!
when i try to create a backup, i'm running into the following error:
Fatal error: Allowed memory size of 31457280 bytes exhausted (tried to allocate 43 bytes) in /www.konfabulieren.com/wp-includes/wp-db.php on line 252
Hey! This is one great plugin. Thanks!
I would like to make a suggestion, though. How about the posibility of saving to disk the cron/schedualed backups instead of emailing them to me? Is that a posibility?
Thanks!!!!!
Rush: I'm hesitant to allow people to automatically save their backup to the server. At least now, it takes an active choice for you to click the button and leave the backup on the server.
I know Owen was kicking around the idea of automatically FTPing the backup file to some other server. And as others have pointed out, GMail makes a fine repository for storing these backup files...
I just moved hosts and the backup and restore process for my WP SQL database was erroring out left and right. I tried manually, using various plugins with no results. Finally, I found yours and I'm sure you'll be pleased to know it worked the first try. You saved my site, buddy! :)
[...] wp-db-backup es un plugin para WordPress que hace copias de seguridad de las tablas de WordPress en una base de datos. Además de crear un respaldo de tus tablas de WP, también te permite hacerlo con otras tablas que no sean de WordPress. Tn fácilcomo subir los archivos a la carpeta de plugins, activar el plugin y crear un Backup. [...]
tripleaxis' fix for line 177 worked flawlessly! Thanks for the great work guys!
http://www.skippy.net/blog/2005/07/12/wordpress-database-backup/#comment-2818
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!
Marcus: the problem you're experiencing is because the plugin is not properly applying backticks to the table names. Dahses cannot be used in database names unless the database name is surrounded in backticks. This will be addressed in the next version, along with some other minor enhancements.
Thank you very much for this great plugin!
[...] El primer paso es instalar el plugin para generar el Backup de la DB de Wordpress, para esto bajamos el plugin de Skippy.net, descomprimimos y subimos todos los archivos en nuestro servidor donde tenemos instalado WP, en el directorio de … /wp-content/plugins/, después de esto creamos una carpeta llamada backup con permisos de escritura en /wp-content/, activamos el plugin en el menú de wordpress y listo. [...]
Thats a wonderful plugin.
I am using it and feel really good about it because i am not afraid of a server crash :)
[...] Och här kan man gratis tanka ner en ypperlig plug in till WordPress för att backa upp databasen för sin blog! Filed under: Blog/IT/Gfx Comments: [...]
[...] Сразу принялся за установку плагинов, перечисленных у Дениса Перехреста в заметке “Стартовый набор начинающего Wordpress-блоггера”. Чтобы не путаться — по-порядку. Первым идёт плагин “WordPress Database Backup”, позволяющий делать бэкап базы. [...]
[...] 使用WP-DB-Backup插件对数据库进行备份，前提是你需要安装另一个插件WP-Cron。 [...]
[...] wp-db-backup es un plugin para WordPress que hace copias de seguridad de las tablas de WordPress en una base de datos. Además de crear un respaldo de tus tablas de WP, también te permite hacerlo con otras tablas que no sean de WordPress. Tan fácil como subir los archivos a la carpeta de plugins, activar el plugin y crear un Backup. [...]
thanks to skippy.
the fix by tripleaxis was required by me, and with it all is hunky-dory :)
Yes i have the same error:
Warning: Invalid argument supplied for foreach() in /home/ehecatl/public_html/ehecatl/wp-content/plugins/wp-db-backup.php on line 177
Warning: Invalid argument supplied for foreach() in /home/ehecatl/public_html/ehecatl/wp-content/plugins/wp-db-backup.php on line 177
Warning: Cannot modify header information - headers already sent by (output started at /home/ehecatl/public_html/ehecatl/wp-content/plugins/wp-db-backup.php:177) in /home/ehecatl/public_html/ehecatl/wp-content/plugins/wp-db-backup.php on line 45
Warning: Cannot modify header information - headers already sent by (output started at /home/ehecatl/public_html/ehecatl/wp-content/plugins/wp-db-backup.php:177) in /home/ehecatl/public_html/ehecatl/wp-admin/admin.php on line 10
Warning: Cannot modify header information - headers already sent by (output started at /home/ehecatl/public_html/ehecatl/wp-content/plugins/wp-db-backup.php:177) in /home/ehecatl/public_html/ehecatl/wp-admin/admin.php on line 11
Warning: Cannot modify header information - headers already sent by (output started at /home/ehecatl/public_html/ehecatl/wp-content/plugins/wp-db-backup.php:177) in /home/ehecatl/public_html/ehecatl/wp-admin/admin.php on line 12
Warning: Cannot modify header information - headers already sent by (output started at /home/ehecatl/public_html/ehecatl/wp-content/plugins/wp-db-backup.php:177) in /home/ehecatl/public_html/ehecatl/wp-admin/admin.php on line 13
This error ...
ehecatl: try using the latest version of WP-DB Backup to see if it resolves your problem.
Great plugin, thanks so much for making it!
Wow! What an AWESOME plugin, thanks a million! You coders ROCK!
This is a great plugin - thank you. I do have one small issue - I've also installed the Amazon Media Manager (AMM) plugin, which also adds a page (AMM) under WordPress's Manage menu. For some reason when I click on the AMM page, I see the WP DB-Backup page (the same page I see when I click Backup). If I deactivate DB-Backup, I can see the AMM page again, but obviously I'd prefer not to keep having to deactivate it. Any idea why these two plugins might conflict in their placement on the Manage menu? Is there a simple option I might be able to change in the code?
Robert: You're almost certainly using an older version of WordPress, and are now suffering from bug #902.
Please upgrade to version 1.5.2, the latest stable release of WordPress.
Thank you, Skippy, that's it. Duh - I'll read the WP Dashboard from now on...
Dear Skippy
I get an error when i type "chgrp www-data backup" that says: "chgrp: invalid group name `www-data'".
Any idea what might be causing this and how to get round it? (I'm using Private Shell SSH).
Cheers
Simon
Simon: different hosts will use different group names.
www-datais the group used by default on Debian systems; Red Hat uses (I think)nobody. Others may useapache, or something else.You may need to contact your host to find out.
[...] skippy dot net » WordPress Database Backup (tags: wordpress plugin 2do) [...]
Mistake in install instructions?
The directory wordpress/wp-content should be wordpress/wp-content/plugins, i think.
stephan: can you provide a more specific indication of where that problem lies? I don't see anything obviously wrong in the instructions.
[...] So the server change happened yesterday and it was successful! I now have a wonderful way to easily back up my entire journal because of Skippy’s Wordpress database backup plugin which works great! [...]
I had the same problem like Stephan. I thought the file had to go in the wordpress/wp-content/backup/ directory !
[...] Anleitung f
how do i make the backup directory writable? =\
chmod or change the permission for the directory to 777 using your CPanel/Direct Admin file manager or your favourite FTP client.
777?
Just got done reading this post, don't think I will use the script until you can change that.
http://malformed.org/2005/11/22/if-a-script-says-register-globals-should-be-on-then-dont-use-that-script/
Miles: file mode 777 is different from PHP
register_globals. The WP-DB Backup documentation specifically recommends mode 600 or 660, but as the comments here indicate some people have success only with 777. On my blog, I use this plugin just fine with mode 660.But don't take my word for it. Try it for yourself. If this plugin doesn't work for you, or if it works in a way that you find less-than-ideal, then simply don't use it. There are plenty of other ways to backup your blog.
Thanks Skippy! I will try it. Just such a nice plugin wanted to use it. Thanks for the quick reply.
Okay, thanks for the quick response. It seems to work only with 777. Thanks though.
[...] Google Sitemaps 9 Spam Karma 2 - Reloaded 5 Related Posts 3 WP-ContactForm 6 Email Notification Plugin StatTraq 2 Adsense Deluxe 5 Akismet 4 Ultimate Tag Warrier 3 Feedburner Feed Replacement 3 WP-Amazon 3 Auto hyperlink URLs 2 Page Navigation 2 Angsuman’s Feed Copyrighter 2 WordPress Database Backup 2 IImage Browser 2 Paged Comments 2 Viper’s Plugins Used 2 Popularity Contest 2 WP-Googlestats 2 Subscribe to Comments AJAX Spell Checker Recent Comments Audio Play Rate My Stuff ViewLevel2 evermore PHP Exec Most Wanted Autometa WP-Cron Quicktags WP Adsense No Duplicate Comments Polite-ifier CSS Compress Del.icio.us Bookmark This Flickr Gallery Heavyweight Categories Live Comment Preview Relative Dates RunPHP Extract Terms Terms2tags Force Word Wrapping WP-cache WordPress From/Where WP Hardened Trackback WordPress Hashcash Adsense Logger Bad Behavior Cat 2 Tag CA Chitika Chitika eMiniMalls Code AutoEscape Paged Comment Editing Optimal Title Better Feed Click Counter IP 2 Nation Random Words Transpose e-mail Batch Categories Enhanced View PXS Mail Form SH-Autolink Search Meter Search Pages Search Reloaded Smart Update Pinger Taggerati x-Dashboard CG Powerpack PhotoPress Subscribe Me Secure Image Ak-Bookmark/ak-subscribe Blogs of the Day (couldn’t find URL) Get RSS (couldn’t find URL) [...]
hi skippy! first of all thank you so much for this plugin! but please help me with this coz i'm not sure if i'm doing it right.
i've selected "download" as my delivery back up option, and i've seen that it has been downloaded in my ftp folder; however, isn't this option supposed to download the backup file on my pc? should it ask me where to save it on my pc? thanks!
eighteen: what do you mean by "it has been downloaded in my ftp folder" ? Selecting download should tell your browser that a file is coming, and your browser should ask you where you'd like to save it.
Wow that was fast. To answer your question, the browser didn't asked me where to save the backup file on my PC; however, it is saved in my /wp-content/backup/ folder. What have I done wrong?
eighteen, you can download it from your site.
ya just simply navigate to that directory to find it.
This plug in worked great for me. Okay a newbie question. How do I restore the database somewhere else?
wizz: you'd need to use command-line MySQL tools, phpMyAdmin, or something similar. No one has yet stepped up to write a plugin to restore data from this plugin's backups.
I always used PHPmyadmin to backup databases, and its a real pain.
backing up database using your plugin is eaiser than phpmyadmin.
Thank's Skippy.
Nice job. I'm not much of a MySQL guy, so this was a godsend for me.
I did run into one problem -- The backup process would time out when I included the shotstat tables, one of which was 15 megs.
To overcome this, I just created the SS table manually in the new installation. It's empty, but it works.
[...] DB BackUp http://www.skippy.net/blog/2005/07/12/wordpress-database-backup/ [...]
[...] Si alguno de ustedes esta preocupado por no tener un plugin bueno, bonito y confiable para hacer backup de Wordpress, les recomiendo el Wordpress Database Backup y el WP Cron, (el primero es un plugin para hacer backup y el segundo es para automatizar esa operación). Archivado como [...]
[...] If not - then something like the WordPress database backup plugin will allow you to backup your db locally. Again, perform the above search-and-replace steps so that 2.0 is using a fresh database install. You can then use the builtin db plugin in 2.0 to restore your db. Otherwise - create a new db in phpmysql, import the modified sql back in, update the wp-config.php with the "new _" prefix and then perform the wp-admin/upgrade.php process. This all has some very nifty advantages: [...]
[...] Automated backups Technorati Tags: wordpress backup wordpress plugin [...]
[...] skippy dot net » 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 (tags: WordPress Bloggins Tools Plugins Database) [...]
I am running WP 1.5.2 (getting ready to upgrade to 2.0 now that it is out of beta!). In preparation for the upgrade, found your plug-in to do my prep work (backups, backups, backups).
You rock. I first uploaded v1.4, but found the same looping "errors" since my site isn't fully fleshed out yet (probably some empty areas). So, pushed up v1.7 of your backup tool and it worked like a charm.
You rock Skippy.
[...] ０１－１１ 使用WP-DB-Backup插件对数据库进行备份，前提是你需要安装另一个插件 WP-Cron。 [...]
[...] Now I have 7 other blogs and sites that use WordPress and I’ve upgraded them all successfully to WordPress 2.0 without any problems. But my primary blog is the biggest and so I saved it for last. Since I had two different hosts and servers, I was able to setup everything without doing an upgrade in place. So I start by backing up the database from my current host using the WordPress backup plugin. I then use the MySQL Query Browser to upload the script and create the database and load up the content. The database creation worked but I ended up with some SQL errors in the process as it was loading data in the tables. But the MySQL query browser didn’t articulate the errors and so I assumed that the WordPress Database Backup plugin might have some issues and created the extract with some errors. So I use the MySQL Administrator to backup the original database and then restore it over on the new host and I got the same errors. So I look at the backup SQL script and I notice that some of the posts that are missing from the database have a special character in them that looks like this image. I’m guessing this is a weird issue with the textile plugin I use to create most post entries after but I am not sure. So I start manually updating the database and fixing the missing posts. After I got all of the special characters out of the SQL dump file, I recreate the database and fire up the WordPress upgrade script. As promised, the upgrade scripts spins for a while and then returns successfully with the upgraded blog now running under WordPress 2.0. [...]
This really has been a lifesaver. KUDOS to the max.
[...] In terms of platforms for this blog, I’m using WordPress v2.0 after using v1.5.2 forever or so it seems. If anyone is having second thoughts please don’t, this new incarnation of WordPress kicks motherfucking ass. There are plenty of tools out there to use to back up your database (Skippy’s being the best in my opinion) so don’t let a little technotardishness get you down. Take the plunge, it’s well worth the effort. [...]
[...] very good plugin WordPress Database Backup: http://www.skippy.net/blog/2005/07/12/wordpress-database-backup/ [...]
[...] skippy.net 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. [...]
[...] （３）コントロール MovableTypeはアーカイブの場所が直感的に分かるため、すぐにバックアップをアナログ的に？とることができる。WordPressはMySQLと連携していることなどからデータのバックアップはいまいちどうすれば良いのか迷う人もいると思います。そこでWordPressには有志でつくる数々のプラグインが用意されていて、手軽に実装することができます。便利ですね。バックアップは、skkipy.netのプラグインを利用するのも手です。また2.0からデフォルトで管理画面は日本語なので迷わずアップデートすることがまずオススメです。ソースコードの最適化の点からアーカイブのディレクトリ名称はハッシュ値のような値よりもタイトルのキーワードがベストだと思われます。日付は人間から見た点では有効ですね。 [...]
[...] Note to myself: Make sure to install a WordPress backup plugin. This one for example. Technorati Tags: dreamhost mysql site [...]
[...] WP-ContactForm WordPress Database Backup WP-Googlestats [...]
Wordpress database backup plugin...
I found this great plugin for Wordpress called wp-db-backup, which you can use to backup your databases from within Wordpress. You can set it up to save the backups to the server, e-mail it to you, or download it to your computer. If you also download...
May be It is too stupid to ask about it, but I'm running without my system administrator right now and will do that for 2 weeks more. Can I somehow suppress all those warnings and notices, described upper? If it is too stupid question, tell me, I will delay the start of the new blog and wait while he returns back.
Thanks in advance.
Uh, what is writeable by webserver, 755?
Ummm, me again. I went with 755, but I see from scrolling through other comments that I may have to go with 777. But my new question is this:
When I go to Manage | Backup, what I get is Gatekeeper instead. I wonder if I should deactivate Gatekeeper first, then give it another try.
The back-up plug-in must have come with the latest version of Wordpress as I seem to have it already ... but the Cron plug-in will really come in handy
Hi Skippy, could you please tell me what is the difference between your plugin and the backup plugin that is included with Wordpress 2.0?
This plugin saved my bacon a lot of times. Thanks a million for this one!
[...] Backupmyblog is a a new service which enables you to backup your MySQL blog within minutes. Brian Benzinger has written about it here. I find this an interesting service, but the fact that it only backs up databases and will be a paid-for service once launched has made me stick with my traditional WordPress plugin. WP Cron + WordPress Database Backup + a Bulk GMail Account does the trick more than well enough. Comments [...]
Yeah, I also gave up my phpMyAdmin. Thanks! Great job!
[...] قم بأخذ نسخة من قاعدة البيانات، إذا حصلت أي مشكلة أثناء الترقية سوف تستفيد من النسخة الإحتياطية في إستعادة قاعدة البيانات. بإمكانك الحصول على نسخة احتياطية لقاعدة البيانات بواسطة برنامج إدارة قواعد البيانات في لوحة تحكم موقعك، في الغالب سيكون البرنامج هو PhpMyAdmin، أو يمكنك إستخدام إضافة النسخ الإختياطي لقاعدة البيانات الموجودة مع ووردبريس 2.0. هذه الخطوة مهمة جداً. [...]
[...] skippy dot net’s WP-DB Backup 1.7 plugin [...]
[...] A continuación, y sólo por si acaso, lo recomendable es realizar una copia de seguridad de nuestra base de datos. Así, en caso de cometer algún error durante el proceso, no perderíamos nada de lo que hayamos publicado hasta la fecha. Para tal efecto, yo recomiendo el empleo del estupendo WordPress Database Backup. Con un poco de suerte, este paso será meramente testimonial. [...]
Wordpress Database Backup...
Today I installed few wordpress plugins, namely: WP-DB-Backup, WP-Cron and WP-Googlestats.
WP-DB-Backup is a plugin to backup your mySQL database (not only blog-related entries) to save it either on your webspace or mail it to your inbox. Backup Files ...
[...] Yuck - having WordPress go “splarf” on me was a bummer…my apologies for taking so long in getting things back up and running. Thank goodness for the Backup plug-in that saved *everything* — I wound up just doing a complete re-install of WordPress, and then restored the backup (which was literally push-button simple). Whew! [...]
This is great. Thanks so much for your hard work. Incidentally, I think it's great that a post you did on a blog more than a year ago is still getting traffic and comments. You know you've done something worthwhile when...
[...] Upgraded (finally) to WordPress 2.0.4. And tho it wasn’t critical to do that beforehand, there’s a great WordPress plugin for backing up the database. It comes standard with 2.x, but if you’re still in 1.5.x land, I suggest you get it and use it. (Mommy’s cold, so you better put on a sweater) [...]
its great plugin for wordpress blog, but as is it with the transfer blog entries to new domain name?
Yet another great plugin from Skippy. Worked like a charm the first time. Thanks!
Hi Skippy, (or anyone else who knows) could you please tell us what is the difference between your plugin and the backup plugin that is included with Wordpress 2.0?
thanks!
hello, this plugin works fine if i download it to my computer but the e-mail part does not work. must SMTP be enabled for this to work? coz my host service doesn't allow it. thank you.
[...] WordPress Database Backup Plugin, by Skippy Quick, easy backups of your database [...]
[...] How to move a WordPress Blog By admin 1. Backup the database. Remember all the content of your blog is in a MySQL database, and if you screw up the database you probably lose all the content. Backup the database. I’ll say it again. You don’t know how? First go here, and get this excellent plug-in from Skippy [...]
Hi, I installed role manager - and now my cms is virtually unviewable due to permission problems that I dont know how to rectify. Do you know how to restore a backup, possibly from the filemanager (I searched MySQL but am extremely poor at working with such a complicated database). Okay, any help is sincerely apprecitaed (can only view profile, wont let me post in admin status, and wont let me do anything else, probably not even change themes). thanks, claire
Claire: If you've used WP-DB Backup to perform backups, then you should read Restoring Your Database from Backup on the Codex.
[...] Export your blog data. Essentially, this is the same as making a backup consisting of a humongous SQL file that will both create the tables you need and fill them with data. Use these instructions from the WordPress codex or, even easier, use this backup plugin. [...]
Hi Skippy, great plugin - only one problem when I restore to the database everything works except my post-new page is a bit borked.
WPv2.1 the link, img, etc area is not quite right. I'd appreciate any help - if it turns out to be a more complicated problem perhaps there is a for-a-donation support?
Anil: I'm no longer maintaining the wp-db-backup plugin. Please use the new version of wp-db-backup. If you still have problems, your first line of support is the WordPRess support forum.
[...] Detailed instruction on how backup your database can be found at Wordpress on the cleverly titled Backing Up Your Database page. The easiest way to backup your database is phpMyAdmin if your web host offers it (most do) or if your use a Mac, Cocoa MySQL. If you would like to automate database backups, check out skippy.net’s WordPress Database Backup plugin!. [...]