Transfer Default MySQL Database Directory From /var To /usr

Default partition size for /var normally not enough to store databases, so we need to store it somewhere bigger (/usr). The steps will show how to transfer database from /var/db/mysql (default path installation for MySQL in FreeBSD) to /usr/local/mysql/data (suggested path). Steps as follows :-

[root@dev /var/db/mysql]# /usr/local/etc/rc.d/mysql-server stop
Stopping mysql.
Waiting for PIDS: 993.
[root@dev /var/db/mysql]# mkdir -p /usr/local/mysql/data
[root@dev /var/db/mysql]# mv * /usr/local/mysql/data/.
[root@dev /var/db/mysql]# cd ../
[root@dev /var/db]# rm -rf mysql
[root@dev /var/db]# ln -s /usr/local/mysql/data mysql
[root@dev /var/db]# chown -R mysql mysql
[root@dev /var/db]# chgrp -R mysql mysql
[root@dev /var/db]# cd /usr/local/
[root@dev /usr/local]# chown -R mysql mysql
[root@dev /usr/local]# chgrp -R mysql mysql
[root@dev /usr/local]# /usr/local/etc/rc.d/mysql-server start
Starting mysql.
[root@dev /usr/local]# ps aux | grep mysql
mysql    46491  0.1  1.1 208112 44860  ??  S     6:15AM   0:00.09 [mysqld]
mysql    46411  0.0  0.0  8264  1920  ??  Ss    6:15AM   0:00.01 /bin/sh /usr/local/bin/mysqld_safe –defaults-extra-file=/var/db/mysql/my.cnf –user=mysql –datadir=/var/db/mysql –pid-file=/var/db/my
root     46494  0.0  0.0  9092  1432   0  S+    6:15AM   0:00.00 grep mysql
[root@dev /usr/local]#

DONE!

HOWTO Delete Old Directory in UNIX

There are 2 ways u can do this. For example if u want to delete directory older than 7 days :

First method :
[text]
find /path/dir -type d -mtime +7 -exec rm -rf {} ;
[/text]

Second method :
[text]
find /path/dir -type d -mtime +7 | xargs rm -rf {} ;
[/text]

You can always change the +7 value to any number of days preferred.
FYI, this command is only for directory deletion, if u want to delete files, u can change the “-type d” (d means directory) to “-type f” (f means files).

Example :
[text]
find /path/dir/unl.txt -type f -mtime +7 | xargs rm -f {} ;
[/text]

P/S : There’s an alternative command which we can use, tmpwatch (more info : http://linux.about.com/library/cmd/blcmdl8_tmpwatch.htm)

Speed Up Connection to ProFTPD server

Open the config file (/usr/local/etc/proftpd.conf)

add these lines into the config
[plain]
IdentLookups                    off

UseReverseDNS off[/plain]

and restart your proFTPd services. Tadaa~!

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑