How Do I Move a Mysql Database to Another Drive in Linux?
Contents Where Are the Mysql Database Files Stored in Linux? Mysql Stores Db Files in /Var/Lib/Mysql by Default, but You Can Override This in the Configuration...
Contents
Where are the MySQL database files stored in Linux?
MySQL stores DB files in /var/lib/mysql by default, but you can override this in the configuration file, typically called /etc/my. cnf , although Debian calls it /etc/mysql/my. cnf .
Must Read
How do I install MySQL on a different directory in Linux?
Changing the default MySQL/MariaDB Data Directory
- Step 1: Identify Current MySQL Data Directory. …
- Step 2: Copy MySQL Data Directory to a New Location. …
- Step 3: Configure a New MySQL Data Directory. …
- Step 4: Set SELinux Security Context to Data Directory. …
- Step 5: Create MySQL Database to Confirm Data Directory.