Thanks for your advice. I found another way of doing it.
from DatabaseB: Select * into outfile 'data.txt' from TableB then on DatabaseA: Load data infile 'data.txt into TableB then on DatabaseA, I can run any validation on TableB before inserting it in TableA. Velen ----- Original Message ----- From: "Daniel Brown" <[EMAIL PROTECTED]> To: "Velen" <[EMAIL PROTECTED]> Cc: <mysql@lists.mysql.com> Sent: Friday, March 21, 2008 6:10 PM Subject: Re: Optimize db update > On Fri, Mar 21, 2008 at 10:04 AM, Velen <[EMAIL PROTECTED]> wrote: > > This one is alright but is there an alternative that can be run with the > > mysql> prompt? > > Not to dump a file, but to import, yes. Check out the LOAD DATA > INFILE command: > http://dev.mysql.com/doc/refman/5.0/en/load-data.html > > -- > </Daniel P. Brown> > Forensic Services, Senior Unix Engineer > 1+ (570-) 362-0283 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]