I am using:
MYSQL VERSION 5.0.18-nt
Windows Server 2003
I have moved the Mysql data folder from the C drive to the D drive as I need more space for it.
I changed data directory in my.ini file
this works fine, I can access the data with selects etc, I can create new tables, but when I do this:
create table newtable AS select * from oldtable;
I get this error:
ERROR 2013 (HY000): Lost connection to MySQL server during query
and sometimes it does this:
mysql service terminated unexpectedly
And the server shuts down.
The newtable does actually get created, but no data is entered into the new table. This all worked fine before I moved the data file to the D drive. Can it be to do with permissions? Or is there somewhere that it is looking in the wrong location for the data? (I would hope it always looks in the my.ini file)
thanks for any help with this!