Thread

OK, so ever since I installed 1.6.2 the familiar Utilities>Backup database step is no longer available.
Elsewhere on these forums mysqldumper has been recommended. I downloaded it but got stuck on installation step 3:

- start the script in your browser (http://www.deinedomain.de/mysqldumper/)

That address came back with a 404 error.

So, can anyone tell me the correct address to use to start the script and install mysqldumper? I’ve looked at their forums but most of it’s in German, which I can’t read…

Alternatively, my ftp software is Interarchy 9.0 and I already use it to mirror download whatever is on my host to my local hard drive. “Whatever is on my host” includes 2 backups daily, generated by a cron step on my index page. One backup is entries only and the other is ALL. So maybe I don’t need to mess with mysqldumper?

Advice, please, from somebody more techie than I am, with advance thanks.

Elsewhere on these forums mysqldumper has been recommended.

I second that, great tool.

I downloaded it but got stuck on installation step 3:

- start the script in your browser (http://www.deinedomain.de/mysqldumper/)

That address came back with a 404 error.

You do realize, don’t you, that “deinedomain.de” is a generic name, like yourdomain.com? You need to bring up your local installation.

I’m going to shift over to ‘How to’, since mysqldumper is a non-EE application.  (And I’ve never installed it.)  Sounds like Ingmar’s advice is dead on, though.

As to whether you need it?  Depends a bit on your paranoia level.  I’d probably install it and use it on a regular basis- ‘just in case’.  How often I’d do a db backup would depend on how often and how many changes are made to the db, how confident I am in the ftp backups and how mission critical the data are.

Hadn’t heard of MySQLdumper before, thanks for the link. I usually use phpMyAdmin to do the occasional backup.

Yes, phpMyAdmin has served me well in the past, too, but mysqldumper has a few advantages. It does not time out (ever, I think—I’ve done some fairly large backups with it), it automatically handles multiple versions if you let it, it is fast, it can automatically FTP or email the files somewhere, and also works beautifully with Cron, allowing for a fully automatic backup solution.

Now you guys have me wanting to give it a try!  May have to go poke it a bit- particularly for my non-EH hosted sites.

Yes, phpMyAdmin has served me well in the past, too, but mysqldumper has a few advantages. It does not time out (ever, I think—I’ve done some fairly large backups with it), it automatically handles multiple versions if you let it, it is fast, it can automatically FTP or email the files somewhere, and also works beautifully with Cron, allowing for a fully automatic backup solution.

Hey, I need something like that! 😊

Thanks Ingmar, I was just going to do some sql cron-script dump-to-file.

Thanks Ingmar, I was just going to do some sql cron-script dump-to-file.

That’s the hackish solution, and I suppose there’s a place for that, too, but do givemysqldumper a try first 😊 Also, yell if there’s some more weird German-only documentation—I don’t remember—and I should be able to help.