put mysql (i.e. c:\bin\mysql.exe or wherever you installed to) in your path (so you can run it from anywhere) navigate to C:\Inetpub\wwwroot\ (or My Documents or wherever your .sql file is) Then type mysql < [filename].sql
mysql is not the name of your DB your SQL script should have USE dbname; at the top to remove any ambiguity >>> Dave Phipps <[EMAIL PROTECTED]> 08/13 11:47 am >>> 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 >============================================ > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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.
