mysql assign different partition for specific DB
You should try this:
How can I move a MySQL database to another drive?


  
  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.