Update query acros 50 mysqls?

Hello,

i need to update one field acros 50 mysqls, please can anyone advice me on how to do this?

Is it wise to do all at once? The field content is like one sentence long.

Thank you

 

WTF is "50 mysqls" - databases? Tables?

 

They all are wordpress databases, so have same structure. so data i need to update are same.

 

If the tables in the different databases are the same, why not just create a short php-file which loops through the databases and exchanges the database for each iteration?

 

Are you somewhat familiar with a programming/scripting language? If you can create a Ruby script it would be very simple. Create an array with your database connection strings, loop over it and open new connections, execute the query, close it...repeat.. I just typed it up real quick. Did not test it as I don't have mysql but it should work...

require "rubygems"
require "mysql"


mydbs = Hash.new{|h,k| h[k]=Hash.new(&h.default_proc) }

mydbs[0] = ["hostname_here","username_here","password_here","database_name_here"]
mydbs[1] = ["hostname_here","username_here","password_here","database_name_here"]
mydbs[2] = ["hostname_here","username_here","password_here","database_name_here"]
mydbs[3] = ["hostname_here","username_here","password_here","database_name_here"]
mydbs[4] = ["hostname_here","username_here","password_here","database_name_here"]
# add more with the correct values, all the way to 50...

mydbs.each do |k,v|
@db_host = v[0]
@db_user = v[1]
@db_pass = v[2]
@db_name = v[3]

client = Mysql::Client.newhost => @db_host, :username => @db_user, assword => @db_pass, :database => @db_name)
result = client.query("YOUR UPDATE QUERY HERE")
puts "updated #{@db_name}" # so you can see that its still doing something..
client.close
end

 

oh sorry.. hash of hashes in this case (not array)

 

are these databases all on the same server? if so, you can login once using the "admin" or "root" login to the mysql and make all the changes...

you didn't specify what type of change.. is it adding a new table or field?

 

Yes, these mysqls are in one account and i have total root access (mysql root too) to the physical linux server...