Database Backup Tool

[Ken.]

In This Thread over on SMF 'viulian' tells us about a backup application that he has written for your SMF database.

If you are like me and are not totally satisfied with the scripts/cronjob solutions that are available then you may find this one interesting. It can do a backup based on your schedule choices and download it to a specified folder on your computer.
I've only used it for a short time now, but it appears to work well... I like it. 

[G6Cad]

Thank you for charing this with us Ken
Seems like avery useful tool  :up:

[Nokonium]

That looks interesting, I've never noticed that before.  :up:

[Shadow]

Good found. This will help tons of people on here or so

[Nokonium]

One that I have found to be good is MySQLDumper I use the 1.21b6 version, I'm yet to try the latest version MySQLDumper 1.23 Pre-release Revision 227.

[Ken.]

One that I have found to be good is MySQLDumper I use the 1.21b6 version, I'm yet to try the latest version MySQLDumper 1.23 Pre-release Revision 227.

And it is a good one!
I'm using it on my cpg db and it works good... just need to find a way for it to download the backup file into a folder on my PC... it will send it to you by email and it also has ftp abilities but I've not had a chance to find out if it will do a download to a folder automatically.

[Nokonium]

If you can set it up to use a cronjob it will run a backup whether you are online or not, in theory you can then set your FTP client to connect as a backup function and download the backup folder.

I've been fiddling with 1.23 and it is fighting with the server security about who has the htaccess rights. 

[Lesmond]

Nice find Ken, I posted over at smf that I had downloaded it thanks to you

[Ken.]

Nice find Ken, I posted over at smf that I had downloaded it thanks to you

Hope it works out OK for you Lesmondâ„¢, it sure looks good so far!

@nokonium... the first time I tried MySQLDumper the security thing got screwed so bad that the whole install had to be deleted and started from scratch! Most of their help forum is in German so it's taking a while to sort through and figure out how to set security correctly, so far now mine is still off.

Also, I've asked viulian (java-smf-backup.php) to consider trying to add the ability for backups on a Coppermine db because lots of SMF users run cpg as well. Thats the only reason that I'm running MySQLDumper, because at this point there is no really good way to backup cpg that I can find.
If viulian is able to add that cpg backup to java-smf-backup.php it sure would make it lots simpler to do these backups by making it so one utility could do them all.

[viulian]

Hi! Just logged in and wanted to say hello to you guys

Let me know if you have issues with the little backup utility.

About the coppermine integration, I just downloaded the 1.4.10 version but I'm skeptic about the success.
If there's no backup utility integrated then the only thing is trying to talk to phpmyadmin directly. It's not difficult, but.. takes time to make it right

I'll see what I can do.