MySQL-Front:
http://www.mysqlfront.de/
On Tue, 13 Aug 2002, Brian Panulla 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
>
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
------------------------------------------------------------------------------
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.
