That is what I would like to do.  I have read the docs about it but the 
part I am struggling with is where to put the .sql file and then how to 
reference it from within the command prompt as the command prompt does not 
seem to like it when I put this in: C:\Inetpub\wwwroot\file.sql

Where do I need to put the .sql file so that I can simply write:

mysql < [filename].sql

where mysql is the name of my db  I presume?


If my .sql file is locate in the My Documents folder how would MySql know 
where to look?

Thanks in advance

Dave


At 09:38 8/13/2002 +0100, you wrote:
>do you mean batch mode as in:
>
>mysql < [filename].sql
>
> >>> Dave Phipps <[EMAIL PROTECTED]> 08/13 9:12 am >>>
>Hi,
>
>I have a .sql file containing my db and I need to get it into a MySQL db
>running on a WinXP box.  I can't remember how to do this.  Can anyone tell 
>me how?
>
>Thanks
>
>Dave
>
>
>============================================
>Phipps CF Development
>Oxford, Oxfordshire.
>Telephone: +44(0)7718 896696
>http://www.phipps-cf.co.uk
>============================================
>
>
>
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to