Database Backup Tool

[RoarinRow]

Very cool I just tested it out.  Is there a way to have the backup save to a directory on a server instead of my PC?   

[viulian]

Yep, it works, even if I didn't test it before with this scenario

You should go to Forums -> Settings... and in the "Backup Directory" text box type something like:

\\192.168.2.103\Share\BKForums

Of course you need to have write access, otherwise you'll end up with a FileNotFoundException/IOException or something Java would throw.

[Nokonium]

@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.

I've sorted it now, they called a truce at setting cmod to 755.

For my purposes 1.21b6 did all I wanted (without the above problem), 1.23 has greater support for character sets but that isn't an advantage to me. Being able to schedule downloads for set time would be, if I could set a regular backup via a cron job, but my server doesn't have that.

[Ken.]

I saw something about a 'fake cron' somewhere in my travels, can't remember where just now but I'll try to find it... it might do what you need.

@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.

I've sorted it now, they called a truce at setting cmod to 755.

For my purposes 1.21b6 did all I wanted (without the above problem), 1.23 has greater support for character sets but that isn't an advantage to me. Being able to schedule downloads for set time would be, if I could set a regular backup via a cron job, but my server doesn't have that.

EDIT: that was easy!... just a Google away. 
http://www.quirm.net/page.php?id=28

[Nokonium]

Got that, thanks Ken  :up:

[Lesmond]

viulian, Welcome to TP, and thanks for dropping by hope to see you often

[viulian]

Thank you for the welcome

I just finished posting a long post on SMF http://www.simplemachines.org/community/index.php?topic=115957.msg1097861#msg1097861

Shortly put:

I'll extend the application so it will be a wrapper over phpmyadmin. That way anyone can backup/restore their databases (no matter what forum it uses, what photo gallery it uses) etc. No need for additional scripts/FTP/chmod/chown, php errors, cront/fake cron, setups etc.

It will take me probably around a month to create this..

Will this solve all the issues ?

[Lesmond]

sounds real cool, cant wait

[Nokonium]

I'll extend the application so it will be a wrapper over phpmyadmin. That way anyone can backup/restore their databases (no matter what forum it uses, what photo gallery it uses) etc.

Would that be able to handle large files? phpmyadmin had, last time I used it, a maximum restore file size of 8mb. I have backup files with 'Complete Inserts' and a the file is over 250 mb.

[viulian]

Oh, right I forgot. I think it's a PHP limitation probably, how much you can upload (how big a file can be), and as far as I know that file is by default 2Mb.

Yah, then there is no alternative than using scripts.. Probably I'll create some that the application will deploy on the FTP server, then call it via web to create a dump file on the directory, then download that file via FTP back to the computer..

The same with restoring the database..

Is this a better solution ?