Disk full, how to move mysql database files?
- by kopeklan
my database files located in /var/lib/mysql which located in partition /dev/sda5
this partition is full (refer here for details)
so I'm going to move the location of database files from /var/lib/mysql to /home/lib/mysql
What is the right way to move this database files?
Im going to do this steps:
Stop http server and PHP
Change datadir=/var/lib/mysql to
become datadir=/home/lib/mysql in
/etc/my.cnf
move all database files to the new
location
run killall -9 mysql, then
/etc/init.d/mysqld start
Start http server and PHP
Is this right? Correct me if I'm wrong
added:
currently, mysql won't stop. refer here: mysql wont stop, mysqld_safe appeared in top
