phpBB auto backup?

Here non-phpBB topics can be discussed.
Post Reply
ShadowmanUK
Member
Member
Posts: 164
Joined: 07 Jul 2009, 20:13
Location: Leeds, England

phpBB auto backup?

Post by ShadowmanUK »

It seems strange that there's no option to schedule backup's in phpBB so they occur every x days at a certain time. Does anyone know of any mods to do this that are secure and work on the latest version of phpBB?
User avatar
RMcGirr83
Supporter
Supporter
Posts: 6242
Joined: 30 Nov 2006, 14:23
Real name: Rich McGirr

Re: phpBB auto backup?

Post by RMcGirr83 »

phpBB's backup relies on not timing out. If you have a large database, the script will probably time out (as set on the server).

There are several backup scripts out there that get around this. One of those being [url=http://www.mysqldumper.net/]MySQLDumper[/url] will allow you to set a cron job on your server to run at certain times of the day to automatically backup your database.

I happen to have two custom scripts. One of which will backup your database and the other which will backup your web site files.
ShadowmanUK
Member
Member
Posts: 164
Joined: 07 Jul 2009, 20:13
Location: Leeds, England

Re: phpBB auto backup?

Post by ShadowmanUK »

Thanks, I need to look more into the features of MySQLDumper, what concerned me when I tried it was once you'd entered your db username/password it was in there all the time and I guess anyone could browse to the index.php and backup/restore. But I probably didn't spend enough time looking at it, it can't be that in-secure surely. I'll have a play around
User avatar
RMcGirr83
Supporter
Supporter
Posts: 6242
Joined: 30 Nov 2006, 14:23
Real name: Rich McGirr

Re: phpBB auto backup?

Post by RMcGirr83 »

It asks you to secure the directory (uses htaccess on it).
ShadowmanUK
Member
Member
Posts: 164
Joined: 07 Jul 2009, 20:13
Location: Leeds, England

Re: phpBB auto backup?

Post by ShadowmanUK »

I'm used to .htaccess as I've used some of its functions before but its not working out for me on this, must be something to do with the setup of the new server, no problem though as I can password protect directories which gives the same sort of protection and seems to work fine.
ShadowmanUK
Member
Member
Posts: 164
Joined: 07 Jul 2009, 20:13
Location: Leeds, England

Re: phpBB auto backup?

Post by ShadowmanUK »

RMcGirr83 » 04/11/10 20:12:06 wrote:I happen to have two custom scripts. One of which will backup your database and the other which will backup your web site files.


I'm tinkering further and I think I can setup a cron job via my control panel to backup the database via Mysqldumper. Could I be cheeky and ask the command line you use to backup your database using Mysqldumper. I've had a look on forum.mysqldumper.de but can't find much, not in english anyway! :)

All I need to know is what you need to execute, its a control panel so I don't need the full crontab line just the bit I need to execute.

Thanks
Post Reply