Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is "datadir" still a valid setting in my.ini file?

Status
Not open for further replies.

mysqltalk

Programmer
Feb 23, 2002
1
US
I'm trying to create a database in another drive (say d: drive) other than the default one. I created the my.ini file in c:/windows with the following lines:

[mysqld]
datadir=e:/mydatabase/

while restarting the mysqld with

net start mysql

I got the following message:

A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.

Does anyone know what it means and any suggestions?
Thanks very much in advance
 
If you gonna move, you have to move mysql/data/mysql directory to new directory/mysql. I had problem with that before and I was playing around and found that you have to have that database in the data directory. Hope you have the same problem as I did.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top