MySQL command question.

[Phoenix_79]

I can't seem to find what I need to input into the command window to point to the file location of a different database.

I have mySQL installed at E:\mySQL

I have the database files for eq installed at C:\EQServer\database

What do I put into the console window to have mySQL open the database there instead of the default location in the E:\mySQL\data ?

Thanks in advance for any help

[joligario]

There should be a my.ini file in your /bin folder that has your directory listings.

EDIT: Sorry, that may be specific to my installation. I guess I should ask what you used to install mysql (machine, etc.)

[Phoenix_79]

I downloaded the windows installer from the mysql site and put installed it to:
E:\mySql.

I downloaded a package that is supposed to make setting up a server easier and I put it in C:\EQEmulator\.

The C:\EQEmulator folder contains a couple folders...one is a database folder with two .SQL files and a backup.

Also inside of the folder located at C:\EQEmulator\system\mysql folder with the goodies \backup, \bin, \data, \share, \tmp.

What I want to do is run the MySQL Command Line Client which is part of the install in the E:\ drive and connect to the information in the C:\ drive.

I'm completely new to this type of thing with mySQL so I'm having a few issue lol. I have browsed through, added and edited things but never had to point to something else someone created.

[joligario]

So you just want to be able to run the mysql cmd to execute those 2 SQL files? Or you want to move where your data files are located? You can do the former without having to do the latter.

[Phoenix_79]

I just want to be able to work on the data in those two files.