Sample Header Ad - 728x90

Moving MySQL databases/folder to another disk

0 votes
1 answer
1846 views
I want to separate MySQL database from the OS (Ubuntu) disk by moving the entire database to an exclusive HDD (M.2), and update the database folder in my.cnf. *My question is:* when the MySQL folder is on a separate disk, can I safely format the OS disk and install a fresh Ubuntu (and MySQL)? Is it OK to install a fresh MySQL and simply point to the existing MySQL folder on a different disk in the my.cnf of freshly installed MySQL? OR the best practice is to restore the databases from a dump after a fresh install, though the database is still available in the machine?
Asked by Googlebot (4551 rep)
Mar 1, 2019, 01:10 PM
Last activity: Mar 3, 2019, 07:34 AM