Thanks, that exactly what I was looking for. been battle all nite with a crashed server and trying to get everything back up... appreciate the help. :)

>> Mike Hillyer wrote:
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]



Reply via email to