From: Sam Duncan <sduncan@...>
Date: 2013-06-26T08:50:12+09:00
Subject: Re: exec iterate through array

On 26/06/13 11:46, Matthew Kerwin wrote:
> Silly question, but does the user 'root'@'localhost' have LOCK TABLES
> in their granted permissions?
>
> On 26 June 2013 08:14, Micah Seattle <lists@ruby-forum.com> wrote:
>> Hello all, I am looking for a little insight on how to by pass this
>> error when running my sctipt... any help is greatly appreciated.
>>
>> mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to
>> database 'information_schema' when using LOCK TABLES
>>
>>
>> tempDir = "/mnt/dumpspace"
>> dumpUser = ""
>> dumpUserPass = ""
>>
>> if Dir["#{tempDir}/*"] != nil
>>    puts "exits"
>>    FileUtils.rm_rf(Dir.glob("/mnt/dumpspace/*"))
>> else
>>    puts "doesn't exist, this should never be true!"
>> end
>>
>> date = Time.now.strftime("%m%e%g")
>> puts date
>> db = Mysql.real_connect('localhost',dumpUser,dumpUserPass)
>> puts "Server version: " + db.get_server_info
>> db.query('show databases').each do |db|
>>    puts " Dumping - " + db[0] + "\n"
>>    Dir.mkdir("#{tempDir}/#{db[0]}")
>>    dump = "mysqldump -u #{dumpUser} -p#{dumpUserPass} #{db[0]} >
>> #{tempDir}/#{db[0]}_#{date}.sql"
>>    exec dump
>> end
>> db.close
>>
>> --
>> Posted via http://www.ruby-forum.com/.
>>
>
>

Aside from the sql permissions, I'm not sure you'll have much luck 
exec'ing in a loop =]

Sam