Hello.
>is it possible to mysqldump specific tables from multiple databases in >a single run? No. > database. I can not (even off hours) lock the entire database (main > one) long enough to do a full dump with locks so I see my options as: You may write your own sql file in which you're locking the tables which you need, selecting the data into outfiles and then unlocking the tables. Sid Lane <[EMAIL PROTECTED]> wrote: > all, > > is it possible to mysqldump specific tables from multiple databases in > a single run? > > what I am trying to do is get replication slaves to a starting point > but am somewhat challenged by the nature of our architecture. > specifically, we have a large number of relatively-static (updated > only a few times/yr w/plenty of advance notice) tables which are > relatively big (~50GB among them) and a small number of tables that > are relatively small (~1GB among them) but are updated continuously > (several million DMLs/day). what I had done w/a single DB was > dump/load the static tables to a new slave then dump/load the dynamic > ones w/a --master-data which took ~1 min (acceptable off hours). that > got me to a point I could do a change master... then slave start and > be in business. I am now trying to merge in a small, secondary > application (only ~50K DMLs/day) which is currently in a separate > database. I can not (even off hours) lock the entire database (main > one) long enough to do a full dump with locks so I see my options as: > > 1. hope someone here knows how to do my original question > 2. get architecture to sign off on consolidating tables into a single > database (in progress). > 3. hope someone here know an approach I hadn't even thought of > (paradigm shifting w/o a clutch). > > thoughts? > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
