mysql -i  < filename.sql

matt ryan wrote:

Lopez David E-r9374c wrote:

Since you have a temp table created (no keys I assume), use the command

 mysqldump -v -e -n -t dbname tablename > filename.sql




This creates a file that inserts the records back into the same table

it also does not do an insert ignore

I need the records to go into the historical table, with an insert ignore




-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to