Re: How do I mysqldump different database tables to the same .sql file?

2013-11-22 Thread Johan De Meersman
--databases, methinks. - Original Message - > From: "Daevid Vincent" > To: mysql@lists.mysql.com > Sent: Thursday, 21 November, 2013 10:44:39 PM > Subject: How do I mysqldump different database tables to the same .sql file? > > I'm working on some co

RE: How do I mysqldump different database tables to the same .sql file?

2013-11-21 Thread Daevid Vincent
21, 2013 1:59 PM > To: MySql > Subject: Re: How do I mysqldump different database tables to the same .sql > file? > > There is a good reason that the USE database is not output in those dumps.. > it would make the tool very difficult to use for moving data around. > > If I

Re: How do I mysqldump different database tables to the same .sql file?

2013-11-21 Thread Michael Dykman
There is a good reason that the USE database is not output in those dumps.. it would make the tool very difficult to use for moving data around. If I might suggest, a simple workaround is to create a shell script along these lines.. you might to do something a little more sophisticated. ###

How do I mysqldump different database tables to the same .sql file?

2013-11-21 Thread Daevid Vincent
I'm working on some code where I am trying to merge two customer accounts (we get people signing up under different usernames, emails, or just create a new account sometimes). I want to test it, and so I need a way to restore the data in the particular tables. Taking a dump of all the DBs and table