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 [...]
Posted on July 5th, 2011 by admin
Filed under: Development, Software, Tips | Comments Off
For change hostname to ‘howtobsd.com’ you should edit /etc/rc.conf: hostname=”howtobsd.com” You also can change hostname without reboot by command: #hostname howtobsd.com but after reboot i will return on value in rc.conf check current hostname: hostname
Posted on March 26th, 2011 by admin
Filed under: Tips | Comments Off
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 [...]
Posted on March 10th, 2011 by admin
Filed under: Tips | Comments Off
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
Posted on March 4th, 2011 by admin
Filed under: Tips | 2 Comments »
One command synchronize system time on FreeBSD #ntpdate europe.pool.ntp.org
Posted on September 14th, 2010 by admin
Filed under: Tips | Comments Off
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
Posted on September 12th, 2010 by admin
Filed under: Tips | Comments Off
You can use :g/^\s*$/d in the vim redactor for cleaning file from blank lines
Posted on June 7th, 2010 by admin
Filed under: Tips | 1 Comment »
restart apache: apachectl restart restart without aborting open connections: apachectl graceful
Posted on February 21st, 2010 by admin
Filed under: Tips | Comments Off
