How To Change MySQL Default Data,Binlog,Error Log Directories

change mysql default data,binlog, error log directories

MySQL Change default directories

While reading this heading everybody things like, yeah its pretty old topic, we can get many articles by googling. But you know what sometimes well known things never work for us. This time it happened for me, my bad. I have done this many times. But most of us changed the default Data Directory only. Only a few of us thinking about change MySQL default data,binlog, error log directories.

I can easily change the Data directory, But while enabling binlog, and error log I got an error.

mysqld: File '/mysql/binlog/mysql-bin.index' not found (Errcode: 13)

So this is the reason for wrote this blog.

My Server Setup:

OS: Ubuntu 14.04LTS 64Bit
MySQL: 5.5.58

Destination Directories:

Data: /mysql/data
Binlog: /mysql/data
ErrorLog: /mysql/error
SlowLog: /mysql/sowlog

Create the Directories:

mkdir -p /mysql/data
mkdir -p /mysql/binlog
mkdir -p /mysql/error
mkdir -p /mysql/sowlog

Set permission:

chown -R mysql:mysql /mysql/
chmod -R 600 /mysql

Sync the data from old data directory to the new directory.

service mysql stop
sudo rsync -av /var/lib/mysql/* /mysql/data/

Edit the my.cnf file

datadir = /mysql/data/
log_bin = /mysql/binlog/mysql_bin
log_error = /mysql/error/mysql_error.log 
slow_query_log_file = /mysql/sowlog/mysql_slow.log

port = 3306
socket = /mysql/data/mysql.sock

Now its time to modify the apparmor files.

vi /etc/apparmor.d/usr.sbin.mysqld

#fine the below lines
/var/lib/mysql r,
/var/lib/mysql/** rwk,

#replace with
/mysql r,
/mysql/** rwk,

Thats it, now start mysql.

service mysql start


You may also like this

2 Replies to “How To Change MySQL Default Data,Binlog,Error Log Directories”

  1. Great article. Is it require to check mysql port before restarting the services.


    1. Rosel, Thank You.
      No need for check the ports.


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.