 | | | Looking for simple tool to execute sql statements on multiple identical database | Looking for simple tool to execute sql statements on multiple identical database 2007-03-16 - By Blake Girardot
Back
Hi,
I am looking for a very simple way to execute the same sql statements on
multiple MySQL databases with identical schemas. I don't need to access
different mysql servers, just different databases served up by my one
mysql server. I also don't need them to run at the same time, just a
methodical running of each set of sql statements on several different
databases.
I want to select from the list of databases the user who is used to
connect to the mysql server. Check boxes or a multiple select list type
of thing.
And then a large text area where I can paste in 1 or more mysql
statements (selects, updates or inserts) and have those sql statements
sent to each database I checked off in the list. I don't need it to
build the statements for me or anything, I will fine tune them at the
command line and get them ready to be run across all the databases I select.
The results would just be displayed and/or logged for display after they
were executed.
I have looked at a number of GUI tools and none really seemed to fit my
simple requirements or I didn't understand how to make them do that or
something like it.
Any suggestions? It sounds pretty easy to write something like this in
PHP, but I am not a programmer so it is beyond my skills to do that.
Pointers to software you think can do it are great, if I know I can do
it somehow in a package I will work on it until I get it figured out.
I would also be glad to pay someone to write some PHP to do it if there
isn't a reasonable alternative already existing.
Regards,
BG
--
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe: http://lists.mysql.com/gui-tools?unsub=mysql@(protected)
|
|
|