All posts in MySQL

Move data mysql mariadb sang thư mục khác

service mariadb stop rsync -av /var/lib/mysql /home/innocom mv /var/lib/mysql /var/lib/mysql.bak vi /etc/my.cnf [mysqld] . . . datadir=/home/innocom/mysql socket=/home/innocom/mysql/mysql.sock . . . After updating the existing lines, we’ll need to add configuration for the mysql client. Insert the following settings at the bottom of the file so won’t split up directives in the [mysqld] block . . . Read more