GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Mysql Data store folder change

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysql Data store folder change

    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

  • #2
    * 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

    Comment


    • #3
      Thanks
      Its works

      Comment

      Working...
      X