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 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/[EMAIL PROTECTED]