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.
