AbleDesign

Chan · Guest

In your screenshots I've noticed you can select from a number of databases to backup. I thought this allows access to multiple mySQL servers.

I have 5 different mySQL servers - all with different usernames and passwords. At the moment I could only access one at any one time by editing dbConnect.inc. Can you easily add a feature that lets me access all five of my SQL servers? Maybe include an array of hosts where I could select which server to backup from the browser.

Many Thanks, please send me a quick reply.

Chan

Dan · Admin / Developer Joined: 19 Feb 2001 Posts: 2057

Hi,

If you look through the feature list on the program page, it talks about multiple databases but nowhere multiple servers. Is this for a hosting application? I hadn't even considered the need for acessing multiple servers.

It shouldn't be too tough to add an input form for selecting host, username, and password; even easier if the same username and password are used for each server. In the simple case, all you'd need is a host select form (like for the databases), with the selection passed through the db/table forms as a hidden variable.

Cheers,
Dan

Chan · Guest

Dan · Admin / Developer Joined: 19 Feb 2001 Posts: 2057

Chan · Guest

Our host gives us a limit of 5 databases to setup. Each database is setup on completely seperate servers (db1.host.com db2.host.com etc.) and we have been recommened to use up all 5 databases, so if one of the database servers goes down the other ones may still be up. At the moment, we use db1 for forum, db2 for our portal system etc.

I believe another reason why our host has set this up is to allow us to resell parts of our host space, but we're not doing that, we're just using it all 5 of our databases for our own benefit.

We would like to backup all 5 quickly and easily without having to edit configuration files every time just to gain access to each database. Our host is one of the largest in Europe (1&1 Internet Ltd) and if they setup their hosting program like this, I'm pretty sure alot of other people are looking for a script very similar for their own use. I'm just saying this could be useful.

Could you implement this feature to the current version? You could clearly state that this optional. Or perhaps you could just help me add this feature?

Regards,
Chan

Dan · Admin / Developer Joined: 19 Feb 2001 Posts: 2057

That strikes me as an extremely odd approach toward data redundancy. I'd have to hear from a lot more people with similar setups and explanations for how it's advantageous before I'd be anywhere near convinced... I'm never in favor of complicating the simple to account for unnecessary peculiarities.

My suggestion at present would be to do separate installs of Backup DB for each server you wish to access. Just bookmark them in your browser and it'll be about the same as having one installation control them all.

Cheers,
Dan