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 Install iStat in FreeBSD for Server Monitoring

iStats for iPhone can be used to remotely monitor your Mac or Mac server. See your iPhone’s stats for battery, memory, disk space, Wi-Fi and Cell IP addresses, uptime & load averages.
No only you can monitor you Mac, but also for other OS (Linux, Solaris & FreeBSD) as well. Assuming you’ve download the iStats app from iTunes App Store, here’s how you can access and monitor your FreeBSD server via these simple steps.
  1. Download the file here (http://github.com/tiwilliam/istatd/downloads)
  2. tar -vxzf istatsd-0.5.7.tar.gz #uncompress the package assuming you’ve downloaded iStats version 0.5.7
  3. cd istatd-0.5.7 #go into the uncompressed directory
  4. ./configure #start compiling
  5. make
  6. make install
  7. mkdir -p /var/{run,cache}/istat
  8. adduser istat #add user istat
  9. chown istat:istat /var/{run,cache}/istat #set permission of user & group for the created folder
  10. vi /etc/istat.conf #remember to change the server code (your password to access iStat)
  11. /usr/local/bin/istatd -d #start the iStat as daemon

P/S : The service is listening on port 5190 so please make sure the firewall allows it.

Official Site : http://bjango.com/apps/istat/
More info : http://www.google.com.my/search?client=safari&rls=en&q=istats+remote+monitoring&ie=UTF-8&oe=UTF-8&redir_esc=&ei=NN37S9ftMI-trAfhz-GuAg

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~!

FreeBSD 7.1-RELEASE Released!

The FreeBSD Release Engineering Team is pleased to announce the availability of FreeBSD 7.1-RELEASE. This is the second release from the 7-STABLE branch which improves on the functionality of FreeBSD 7.0 and introduces some new features. Some of the highlights:

  • The ULE scheduler is now the default in GENERIC kernels for amd64 and i386 architectures. The ULE scheduler significantly improves performance on multicore systems for many workloads.
  • Support for using DTrace inside the kernel has been imported from OpenSolaris. DTrace is a comprehensive dynamic tracing framework.
  • A new and much-improved NFS Lock Manager (NLM) client.
  • Boot loader changes allow, among other things, booting from USB devices and booting from GPT-labeled devices.
  • The cpuset(2) system call and cpuset(1) command have been added, providing an API for thread to CPU binding and CPU resource grouping and assignment.
  • KDE updated to 3.5.10, GNOME updated to 2.22.3.
  • DVD-sized media for the amd64 and i386 architectures

For a complete list of new features and known problems, please see the online release notes and errata list, available at:

For more information about FreeBSD release engineering activities, please see:
http://www.FreeBSD.org/releng/

HOWTO Change Server Date

To check current date
date

Command to change date
date yymmddhhss

Where :
yy : Year in two digit
mm : Month (1-12)
dd : Day (1-31)
hh : Hours (0..23)
ss : Seconds

Example (to set date to 23/12/2008 11:08:00 hrs) :
date 0812231108

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

Up ↑