how to move/configure Mysql Database to another partition?
As root:
- Cleanly shut down MySQL (myqsladmin shutdown)
- Edit /etc/my.cnf and set the data-dir configuration option to the new location of your MySQL data directory.
- Move your entire data directory to the new location, ie: mv /var/lib/mysql/* /mnt/mysql/
- Ensure permissions are correct, chown -R mysql:mysql /mnt/mysql
- Start MySQL as usual.