Re: select records to send to another table in another database

["Christoph Boget" <christoph.boget@xxxxxxxxx>]

> I have a slew of records that went to the wrong database.  The tables
>  have the same names and now I want to copy those records over to the
>  correct database.  Is there such a mechanism using the cli mysql
>  application in Linux?

If the tables have the same schema, you should be able to just do a
mysql dump and pipe that back into itself.  Something along the lines
of:

mysqldump <old_table> | mysql <new_table>

But that will only work if the tables have the same structure.  If
they don't, you can work with variations of the above.

thnx,
Chris

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx