How To Move database to ssd

monovm

• October 19, 2016 01:01

in one of our servers we need to move database from sata hdd to ssd hard drive. database size is 6 gb how we can do this very secure. Regards

• 

  SysSachin

  • October 19, 2016 10:41

  Hello, Use the below steps to change MySQL directory. Before doing anything you can take database backup. 1) Mount your ssd disk on new mount point /mysql 2) stop cpanel Apache and mysql service 3) Move your mysql directory from /var/lib/mysql to /mysql/mysql 4) Create symlink of mysql directory from /var/lib/mysql to /mysql/mysql 5) Start the mysql apache and cpanel services.

  0
• 

  monovm

  • October 20, 2016 06:32

  thanks SysSachin have nice day

  0
• 

  SysSachin

  • October 20, 2016 10:22

  Hello Monovm, You are welcome. Please update here if you are getting any issue with this process.

  0
• 

  cPLevey

  • October 20, 2016 13:09

  Hey @monovm, I'm glad @SysSachin was able to help you out with this!

  0

Please sign in to leave a comment.