View Full Version : Requesting a backup of all your mysql databases
Nicedreams
05-12-2008, 10:40 AM
I asked my host today to get a backup copy of all our mysql databases on our server. I wanted to download it in 1 file and save on my computer.
I got this response: "This is a relatively unusual request -- can I ask why you need to download all of the databases at once?"
Now is it really an unusual request?
Jimmy
abostonboy
05-12-2008, 10:51 AM
Doesn't seem so to me.
gaydemon
05-12-2008, 11:39 AM
No not really, and it shouldnt be that difficult either. You should be able to get a SQL dump without too much hassle.
Nicedreams
05-12-2008, 11:43 AM
No not really, and it shouldnt be that difficult either. You should be able to get a SQL dump without too much hassle.
I didn't think so, especially for a dedicated managed server.
They did it for me anyway.
I know how to do it per domain/user one at a time, but I wanted them all at once.
Jimmy
gaybucks_chip
05-12-2008, 04:04 PM
Jimmy (and anyone who uses MySQL)
I HIGHLY, HIGHLY recommend downloading a copy of Navicat (www.navicat.com). One of our developers suggested it to me and I put it off forever until finally he convinced me to try it... and it's simply amazing. The 30 day trial is free and I think it's a hundred bucks if you decide to license it.
It allows you to do your own backups/restores of MySQL databases, directly manipulate all the records in the database while viewing them in table form, add/delete/modify users, databases, tables, import and export data from MySQL into other formats (excel, Access, etc), You can display data sorted on any field, copy tables and databases, move databases between servers, or between the server and your local machine, and a lot more.
That isn't to say that a host shouldn't be able to do a mysql dump on request, but with Navicat, I can have direct access that is MUCH easier to use than with PHPMyAdmin or command-line MySQL, and my need to ask the host to do anything is all but nonexistent now :)
it is a really common request. What hoster are you using?
Nicedreams
05-14-2008, 07:48 AM
Jimmy (and anyone who uses MySQL)
I HIGHLY, HIGHLY recommend downloading a copy of Navicat (www.navicat.com). One of our developers suggested it to me and I put it off forever until finally he convinced me to try it... and it's simply amazing. The 30 day trial is free and I think it's a hundred bucks if you decide to license it.
That looks interesting.
Jimmy
Nicedreams
05-14-2008, 07:48 AM
it is a really common request. What hoster are you using?
Nat Net.
Jimmy