Hello,

I have MySql installed on my C:, Is it possible to have the data on some other drive?

Urgent Help Required.

I was advised to do the following
Assuming this is a windows install:
1- Stop the mysql server
2- Edit my.ini in your windows directory (or winnt or wherever)
3- Change the data directory line

datadir=X:/folder/path

4- Copy everything in your existing data directory over
5- Restart the mysql service.

i made the following changes:
I changed my datadir using winmysqladmin.exe to some folder on d: Then i renamed the data folder to data_old and copied the contents of this folder to the new location. After doing all this i restarted the mysql service and got the following error.

Could not start the mysql sevice on Local Computer
Error 1067: The process terminated unexpectedly

Could someone please tell me where am i going wrong?

Please HELP ME!!!!

Try to see if there are anything wrong in your my.ini
fix it and restart MySqld