How can I move a MySQL database to another drive? I'm using MySQL 5.5 on a local machine to analyze a large amount of government data. I've created a local database that resides on my default drive (Win7 C: drive). I'd like to store the data on my E: drive, a large eSATA external drive. 

What steps should I take?
Shutdown mysql. 
Move all the files in your current data directory to the new location (check out the location in step 3 - datadir parameter).
Locate my.ini file (it is in the mysql installation directory). Change datadir parameter value to point to the new location.
Start mysql.