Hi,
Thanks for the help. I tried this:
C:\temp>mysql < cms.sql
and I get an error saying:
'mysql' is not recognised as an internal or external command, operable
program or batch file.
Any ideas what I have done wrong? The .sql file is located in the C:\temp
dir and was created using Access Dump.
MySQL is located in the default location: c:\mysql\
Thanks
Dave
At 07:48 8/13/2002 -0400, you wrote:
>At 11:47 AM 8/13/2002 +0100, you wrote:
> >seem to like it when I put this in: C:\Inetpub\wwwroot\file.sql
>
>As a general rule, don't put anything in Inetpub\wwwroot that is not a Web
>page... especially not your database file. That is accessible from the
>network.
>
> >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?
>
>mysql is the name of command-line client program to access the MySQL
>database. You'll need to get used to using a command line interface ("DOS
>box") to use it.
>
>Put your .sql file in C:\temp. Open an MS-DOS Command Prompt (found under
>Accessories under slightly different names on different versions of
>Windows). Change to the C: drive if necessary by typing 'C:'. Type 'cd
>\temp' to change to the temp directory. Assuming you have installed and
>configured MySQL correctly (and have the name of the folder containing the
>mysql client programs in your PATH environment variable), you can then type:
>
> mysql < myfile.sql
>
> >If my .sql file is locate in the My Documents folder how would MySql know
> >where to look?
>
>It sounds like you might need a GUI to interface with MySQL until you get
>used to it's intricacies. I suggest you download the MySQL Windows client
>from mysql.com. You can just copy and paste the contents of your script
>file in the window and click execute. It's ugly and quite primative
>compared to the PostgreSQL GUI, but it works.
>
>Brian
>
>
>_____
>Brian Panulla [EMAIL PROTECTED]
>Chief Information Officer 814.238.6680
>Elmwood Media Group www.elmwoodmedia.com
>
>
______________________________________________________________________
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.
