Unanswered: Can I have MySQL data on some other drive?
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
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?