»PhpBB mod (freeware): Backup database and files«

I have programmed a bunch of .php scripts (altogether called "phpBB backup suite") which will help you to create backups fast and easy.

This backup suite is part of my security tips at IMO → How to protect your phpBB forum against hackers

Every webmaster who runs phpbb should use my program to create backups.

What does my php program do?

•	You can backup (and zip) your MySQL database

•	You can backup (and zip) all files and folders (you can customize what files/folders to include/exclude)

•	You can backup (and zip) MySQL binlogs

•	You can list all existing backups, so you can download them easily

•	You can password protect the folder, where your backups will be located

More features:

•	Each zip file gets a unique name (which includes the database name and the date and time) so that you can easily manage your backups.

•	The zip files are usually zipped as .tgz (= double zipped file, so to speak) thus smaller than usual .zip files.

•	You can enable "Quiet mode" (= without any output), which is perfect for cron jobs (= automatic backups).

And did I mention that it's free?

Download it from

1-4a.com

[CLICK HERE TO VIEW THIS PICTURE]

posted by knn

ebooks-download.com

in-my-opinion.org -> Technology, Computers, Science, Internet -> Software by the admin -> phpBB mod (freeware): Backup database and files

Information if you want to run CRON jobs

To run cron jobs (= automatic backups) you should call the scripts like this:
To make a MySQL backup:

wget -q –delete-after http://YourUsername:YourPassword@www.YourDomain.com/backup/busql.php > /dev/null

To make a file and folder backup

wget -q –delete-after http://YourUsername:YourPassword@www.YourDomain.com/backup/bufiles.php > /dev/null

To make a binlog backup

wget -q –delete-after http://YourUsername:YourPassword@www.YourDomain.com/backup/bumysqlbinlog.php > /dev/null

You will also have to set the frequency (= how often you want a backup to run). Check your cron manual how to do it.

posted by knn

password generator not working

well i was gona sign up on your site, but it seems your register system is faulty seeing as it wont let me sign up.
---------------
i downloaded the Back Up Suite and was on the htaccess-protectthisfolder.php page.

I type in a desired user name and password, hit submit, it just refreshes it self.

All directory's and files in backup are 777.

Thanks,
kyle

posted by kjcdude

kjcdude:

well i was gona sign up on your site, but it seems your register system is faulty seeing as it wont let me sign up.

Why not? What does it say?

kjcdude:

i downloaded the Back Up Suite and was on the htaccess-protectthisfolder.php page.

I type in a desired user name and password, hit submit, it just refreshes it self.

All directory's and files in backup are 777.

So everything works?

posted by knn

Nice, some of the hosting providers are cutting wget access though so this wouldn't work. Here's a link to some stuff I put together:

digitalhijinx.com…

Basic unix scripts that can be cron'd. King for a day

posted by retorq

Re: phpBB mod (freeware): Backup database and files

Feature Request: Is there a simple way to add on to the busql.php file to have the php mail function automatically send the dump file to a specified email account? For example, my 80M database exports and compresses to about 7M, seeing as gmail is so generous with disk space they would make for a good 'off-site' backup location for such critical files, heck even complete file backups would be doable for smaller sites.

I've been looking at the function but don't quite follow the method to set an attachment to the email to send.

Thoughts? Bad idea maybe? I'm full of what I think would be useful ideas but not experienced enough to actually implement them myself...yet! But with yours and many others help I'm getting a better understanding.

posted by dakar

The following post has been deemed OFFTOPIC. Do not answer it and do not quote from it or from parts of it. The reporter (knn) said: "Offtopic"

How about importing the database ...

My database backup is over 118 meg, is there a better way to import than thru myphpadmin or the phpbb restore? That 51meg limit is killing me!

Thanks,

Mike Sullivan

posted by KoolBear

KoolBear:

That 51meg limit is killing me!

Please start a new topic!

posted by knn

I'm having trouble with this. I can backup my files without any sort of problems. The problem I'm having is when I try to backup my db. everything seems to complete ok, but the zip file is never created and uploaded.

posted by learyfan

I seem to be having the same problem as "LearyFan." I am running version 1.3.2 and I have my folders set to 777. The MySQL file is not in the backup folder and can not be downloaded like all_files and avatar files.

Joe

posted by josephezell