mysql database path

[blossam]

hi friends
i have install mysql in c drive
i want to keep database in e:\ drive instad of "C:\Program Files\MySQL\MyS QL Server 4.1\data" path
is it possible? how?

[mwasif]

Change the value of datadir in my.ini under C:\Program Files\MySQL\MyS QL Server 4. And copy the data folder to your required destination. Before making this change, shutdown mysql.

[blossam]

Change the value of datadir in my.ini under C:\Program Files\MySQL\MyS QL Server 4. And copy the data folder to your required destination. Before making this change, shutdown mysql.

i have already done this
but when i do this change then i cant run mysql

[blossam]

i have already done this
but when i do this change then i cant run mysql

ok i have done it
but it can be possible with command prompt??????

[mwasif]

but it can be possible with command prompt??????

I don't think so. Don't forget to change the location for InnoDB tables.