I have installed Percona mysql in my ubuntu server successfully. I need to move percona data location from /var/lib/mysql to /mysql-data directory.Because /mysql-data directory is encrypted volume.How to move percona data folder into this location
-
New Member- Sep 2012
- 4
-
Contributor
- Jun 2009
- 32
* stop mysql server
* change the /mysql-data directory owner and group to the same as /var/lib/mysql, and to the same chmod
* copy the data files and directories to the new directory (including the /var/lib/mysql/mysql directory)
* make sure the rights on destination directory/files are correct again
* add
datadir = /mysql-data
to your mysql config
* restart the server -
New Member
- Sep 2012
- 4
Comment
Comment