Not sure if this well help, but SQLYog (the best mysql GUI EVER) has an option that will take two databases and create a schema difference (ALTER statements, etc.) as well as I think data maybe?
> -----Original Message----- > From: Ananda Kumar [mailto:anan...@gmail.com] > Sent: Wednesday, March 10, 2010 10:43 PM > To: Don Read > Cc: John Oliver; mysql@lists.mysql.com > Subject: Re: Merging deltas from one table to another? > > I think mysqldump does not provide this option. > You can extract the data into a file and use "load data > infile 'file_name > replace into table_name" > or > replace into table_name select * from old_table_name; > For the above to work, there need to be primary key or unique > index. If > primary key or unique index is not present, it would just > insert the data. > > Extrating data into a file will take lot of time if the data > set is too > huge. > > regards > anandkl > > > > On Thu, Mar 11, 2010 at 3:32 AM, Don Read <don_r...@att.net> wrote: > > > On Mon, 8 Mar 2010 14:14:09 -0800 John Oliver said: > > > > > OK, a Drupal site I deal with has two copies... a > production site and a > > > test site. After new changes are developed, they're put > on the test > > > site. Once the test site is deemed to be OK, that entire site and > > > database will be copied over to the production site. > > > > > > The issue is, while that work is taking place, changes are still > > > happening on the production site, like new user > registrations and some > > > form input. What I'm thinking is, we can dump the > affected tables and > > > then import them into the test site, which started life > as a mirror copy > > > of the production site. If I were to: > > > > > > mysqldump -h db_server -h user -pPASSWORD database > table_1 table_2 > > > > /tmp/db.sql > > > > Get the table layout on the production box: > > mysqldump --add-drop-table ... > > > > > > On the production side, and then: > > > > > > mysql -h test_db_server -h user -pPASSWORD database < /tmp/db.sql > > ... > > > > -- > > Don Read don_r...@att.net > > It's always darkest before the dawn. So if you are going to > > steal the neighbor's newspaper, that's the time to do it. > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/mysql?unsub=anan...@gmail.com > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
