Thanks for the response, David. How about if I want to import all the
entries from one specific TABLE within that sql file into a table with
identical columns on my MySQL server? Is there a way?
Thanks,
John
On Dec 11, 2005, at 5:29 PM, Logan, David (SST - Adelaide) wrote:
Hi John,
If it is a ".sql" file, with all appropriate SQL statements already in
place then you only have to do the following
$ mysql -u xxxx -p databasename <.sql file
This will process all appropriate statements in the file.
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-----Original Message-----
From: John Mistler [mailto:[EMAIL PROTECTED]
Sent: Monday, 12 December 2005 11:55 AM
To: mysql@lists.mysql.com
Subject: Import Table?
Is there a command that will load in all of the data from a table
within a database ".sql" file on disk? The only import option I am
seeing is "LOAD DATA INFILE" which requires a text file already
exported to disk. How about a way to load in the table data directly
from the database file?
Thanks,
John
--
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]