List:General Discussion« Previous MessageNext Message »
From:Nitin Mehta Date:February 12 2004 5:30am
Subject:Re: How do I import a SQL file with over 3000 lines in it ?
View as plain text  
you can use very well documented SQL command
Load data infile.........

Hope that helps

----- Original Message ----- 
From: "Adam Staunton" <adamst@stripped>
To: <mysql@stripped>
Sent: Thursday, February 12, 2004 9:42 AM
Subject: How do I import a SQL file with over 3000 lines in it ?


> Hi all,
>
> I have an sql file that I exported from a database of mine that has over
3000 lines (records) in it. How do I go about importing that information
into the database ?
>
> Previously I was using the same sql to test it, but it was only a few
hundred lines or so and I simply cut-and-pasted the sql into the "Run SQL
query/queries on database ..." text box and hit "Go". It created the tables
and inserted the data.
>
> Any help would be greatly appreciated.
>
> cheers,
>
> Adam
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>


Thread
How do I import a SQL file with over 3000 lines in it ?Adam Staunton12 Feb
  • Re: How do I import a SQL file with over 3000 lines in it ?Nitin Mehta12 Feb
  • Re: How do I import a SQL file with over 3000 lines in it ?Thomas Spahni12 Feb