You need to be Payday Loans UK Why would you

mysqldump on FreeBSD

Just a few notes about mysqldump. Create dump of mysql base: # mysqldump -uDBUSER -pPASSWORD DBNAME > filename.sql or # mysqldump –user=username –password=password DBNAME > filename.sql if you need to make dump of a few databases you can use parametr -B (or –databases): mysqldump -uDBUSER -pPASSWORD -B DBNAME1 DBNAME2 > filename.sql Make dump of the [...]

How to change hostname on FreeBSD

For change hostname to ‘’ you should edit /etc/rc.conf: hostname=”” You also can change hostname without reboot by command: #hostname but after reboot i will return on value in rc.conf check current hostname: hostname

Mysql log queries FreeBSD

If you want to activate logging of mysql queries, add in your my.cnf (by default it is /var/db/mysql/my.cnf) in [mysqld] section: log=/var/log/mysql.log create log file: #touch /var/log/mysql.log #chmod 666 /var/log/mysql.log and restart mysql-server: #/usr/local/etc/rc.d/mysql-server restart (it can be different on you server) That is all. PS: I don’t recommend you use it on hight loaded [...]

How to set timezone FreeBSD

Change timezone in FreeBSD to GTM -0500: #cp /usr/share/zoneinfo/America/New_York /etc/localtime Check current GMT zone in FreeBSD you can by command: #date +%z

How to update time on FreeBSD (synchronize)

One command synchronize system time on FreeBSD #ntpdate

How to change FreeBSD root password

Change root password: – Boot system in single user mod (key “4″) – Remount / root in rw mode: #mount -u / #mount -a – Đ¡hange the password: #passwd – Insert new root password – Reboot

vim – howto delete blank lines

You can use :g/^\s*$/d in the vim redactor for cleaning file from blank lines

How to restart apache

restart apache: apachectl restart restart without aborting open connections: apachectl graceful