- August, 2005
-
Moving the MySQL's datadir directory.
By default, MySQL's
datadir
is placed in the/var/lib/mysql
directory. However, if you are planning on using MySQL tables to store a lot of data and your/var
partition is small, it might cause you problem at a later stage. In such a scenario, it is better to move the MySQL'sdatadir
to another partition (like/home
.The steps are
- Stop your mysql server before starting this operation
- Create the directories that will be new
datadir
chown
the directory to themysql:mysql
user- copy the files from the old
datadir
to the new location. However, make sure that the files namedib_arch_log_0000000000, ib_logfile0
etc. are not copied to the newer location. - Make sure that the files and directories are owned by
mysql
user - Make changes in the my.cnf to point the new
datadir
. - Restart the MySQL database
- You might need to do varying degree of troubleshooting to get the server working if there is some problem
- Create a new database and verify that the files for this database
are getting created in the new
datadir
- After the server is running for a few days properly, get rid of the old data.
- Sleep
Defined tags for this entry: geek stuff
Page 1 of 1, totaling 1 entries