The SOURCE command will allow you to execute files in batch mode: Mysql> SOURCE table_name.sql;
Check http://www.mysql.com/doc/en/Batch_mode.html For more info. Regards, Mike Hillyer www.vbmysql.com -----Original Message----- From: Mike Blezien [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 7:46 AM To: MySQL List Subject: Correct commandl line hello all, sorry for the newbe question, but want is the correct command line sytax to restore table data from a file, table_name.sql each of our .sql files contains all the table structure and insert data and we need to restore a whole bunch of tables and data. TIA -- Mike<mickalo>Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Web Hosting http://www.justlightening.net Tel: 1(985)902-8484 MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- 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]