Need to move all MySQL software and data files from C: to D:

[DeepDiverMom]

Can you please advise me how to move everything MySQL from C: to D:? I'll need help with commands to move the software and the data files.

I appreciate any help you can give me.

Becca

 

[Bastien]

to move the data files, providing you are using the myisam tables, you can just copy the data folder over to the new location.

Then in the my.ini/my.cnf file, or thru the mysqlwinadmin tool, change the datadir to point to the new location. To move the application engine itself, i would install into the new directory

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[DeepDiverMom]

Bastien,

Thanks so much for responding.

How do things change if we're using "innodb"? My specific data-related parameters from my.cnf are:

datadir=/var/lib/mysql
innodb_data_file_path = ibdata1:7482M;ibdata2:10M:autoextend

Becca

 

[Bastien]

for innodb you need to stop the server first to ensure that no transactions are occurring. but the basic process is the same.

http://dev.mysql.com/doc/mysql/en/adding-and-removing.html

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...