http://bbpress.org/forums/ bbPress Support Forums Topic: Automated Backup Plugin? en Fri, 09 Jan 2009 21:50:34 +0000 http://bbpress.org/forums/topic/automated-backup-plugin#post-17171 Thu, 10 Jul 2008 07:50:42 +0000 chrishajer 17171@http://bbpress.org/forums/ <p>It's great that you have shell access. You can backup all the files with something like rsync, and you can use a shell script to backup the database tables you want. Since there are no wildcards in mysqldump, you will need to explicitly name all the tables in your installation; just separate them with spaces.</p> <p>You can put something like this into a bash script and run it daily (or whenever) from cron:</p> <pre><code>mysqldump --add-drop-table -h host -u user -p password dbname \ ( bb_forums \ bb_meta \ bb_posts \ bb_tagged \ bb_tags \ bb_terms \ bb_term_relationships \ bb_term_taxonomy \ bb_topics \ bb_topicmeta \ bb_users \ bb_usermeta ) | bzip2 -c | bbpress.bak.sql.bz2</code></pre> <p>&nbsp;</p> <p>You would have to consider putting the password into the script and hiding that from prying eyes. Alternatively, you could create a user with limited privileges and no password, and use that in the backup script.</p> <p>You should also verify the table prefix, and that those are all your bbPress tables. I think there are different tables for different bbPress versions.</p> <p>Good luck. </p> http://bbpress.org/forums/topic/automated-backup-plugin#post-17148 Wed, 09 Jul 2008 16:24:13 +0000 ashes999 17148@http://bbpress.org/forums/ <p>Yeah, I have shell access...</p> <p>I had a shell script before to back up my whole schema; but I just want to back up the bbpress schema now, not the wordpress schema. </p> http://bbpress.org/forums/topic/automated-backup-plugin#post-17144 Wed, 09 Jul 2008 14:17:38 +0000 chrishajer 17144@http://bbpress.org/forums/ <p>Do you have access to a shell at your host? If so, you can do it pretty easily. If not, I don't know of an automatic backup plugin for bbPress. </p> http://bbpress.org/forums/topic/automated-backup-plugin#post-17142 Wed, 09 Jul 2008 13:27:51 +0000 ashes999 17142@http://bbpress.org/forums/ <p>Wordpress has a great plugin called wp-backup that allows you to schedule a nightly backup of your database. Is there something similar for bbPress? If not, how should I back up my data regularly? </p>