понедельник, 11 мая 2015 г.

Изменение директории Mysql в Ubuntu

First stop MySQL so nothing weird happens while you're fiddling:
$ sudo stop mysql
Then move all the database directories to their new home:
$ sudo rsync -av /var/lib/mysql /var/newMysql
 

Don't move the files, they will be generated by mysql, just move the folders (which are the databases).
Then politely ask AppArmor to allow mysql to use the new folder:
$ sudo vim /etc/apparmor.d/usr.sbin.mysqld
  >> add lines
     /new-mysql-dir/ r,
     /new-mysql-dir/** rwk,
Then tell mysql that the datadir has moved:
$ sudo vim /etc/mysql/my.cnf 
  >> change the line
     datadir=/var/lib/mysql
  >> to
     datadir=/my-new-db-dir/
NOTE: Depending on your database setup you might need to change innodb-data-home-dir etc. as well.
Then restart AppArmor to read the new settings:
$ sudo /etc/init.d/apparmor restart
And start up MySQL again using the new datadir:
$ sudo start mysql

Отблагодарить можно через форму справа "Donate" ... )

To reward you via the form on the right "Donate" ... )

:)

Комментариев нет :

Отправить комментарий

друзья )

cridex cms новости со всего мира
парсинг центр