mysql assign different partition for specific DB I am using mysql version 5.5.54-0ubuntu0.12.04.1 (Ubuntu) with few DB &amp; one of the DB is growing very rapidly and eating up disk space.

I have mounted secondary disk &amp; would like this specific DB only to use this new added disk.

can someone please provide some suggestions how it can be done? can I move single DB to new disk or I have to move all DBs / mysql to new ? how?
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.