kopeklan's questions

I'm trying to move the location of database files from /var/lib/mysql to /home/lib/mysql

I only changing database files. Socket is still /var/lib/mysql/mysql.sock (only changing datadir in my.cnf)

Now, all data in /var/lib/mysql has been copied to /home/lib/mysql

MySQL has been started and everything is fine. Now time to cleaning up data in /var/lib/mysql

but I'm not sure what data can and cannot be removed in /var/lib/mysql

this is data (except database name) in /var/lib/mysql:

ibdata1
ib_logfile0
ib_logfile1
mysql

I'm new to rsync.

Lots of people said rsync is excellent in everything

how about copying lots of files in more than 10 GB, lots of directory at once?

Is rsync strong enough for this?

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:

1. Stop http server and PHP
2. Change datadir=/var/lib/mysql to become datadir=/home/lib/mysql in /etc/my.cnf
3. move all database files to the new location
4. run killall -9 mysql, then /etc/init.d/mysqld start
5. 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

mysqld won't start because disk space is full:

101221 14:06:50 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
101221 14:06:50 [ERROR] Can't start server: can't create PID file: No space left on device

running df -h:

Filesystem            Size  Used Avail Use% Mounted on
/dev/sda2              16G  3.2G   12G  23% /
/dev/sda5             4.8G  4.6G     0 100% /var
/dev/sda3             430G  855M  407G   1% /home
/dev/sda1              76M   24M   49M  33% /boot
tmpfs                 956M     0  956M   0% /dev/shm

du -sh * in /var:

12K     account
56M     cache
24K     db
32K     empty
8.0K    games
1.5G    lib
8.0K    local
32K     lock
221M    log
16K     lost+found
0       mail
24K     named
8.0K    nis
8.0K    opt
8.0K    preserve
8.0K    racoon
292K    run
70M     spool
8.0K    tmp
76K     webmin
2.6G    www
20K     yp

in /dev/sda5, there is website files in /var/www.

because this is first time, I have no idea which files to remove other than moving /var/www to other partition

And one more, what is the right way to remove log files, history, etc in /dev/sda5?

when typing pgrep wget, it show process id 10144

but how to know what is the details of this process id