Re: How do I import a SQL file with over 3000 lines in it ?

2004-02-12 Thread Thomas Spahni
Adam, use the mysql client tool. yourbox> mysql -h host -u user -pPasswd yourdatabase < sqlfile.sql Cheers, Thomas Spahni On Thu, 12 Feb 2004, Adam Staunton wrote: > 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 a

How do I import a SQL file with over 3000 lines in it ?

2004-02-11 Thread Adam Staunton
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