How to Insert Data Using Select Query in SQL Server 2005
This guide can be used to insert data into database using select query. Using above syntax, all data in second_table will be copied into first_table. You can also add where keyword.
Read More
Setup Squid MRTG on Ubuntu 10.10
Update Feb 23: to install only MRTG and SNMP please read this article. Install MRTG, Apache2, Squid and SNMP $ sudo apt-get install apache2 snmpd mrtg snmp-mibs-downloader squid Configure SNMP Backup /etc/snmp/snmpd.conf $ sudo mv /etc/snmp/snmpd.conf /etc/snmp/snmpd.conf.bak Create new /etc/snmp/snmpd.conf $ sudo nano /etc/snmp/snmpd.conf and key in these lines: rocommunity public syslocation “Bukit Batok”…
PHP Tutorial: How to Check Date is Today Date
Use the following code to check a date whether it is today date.
How to Disable SSH Root Login in Linux
It is important to disable root login in your SSH service. To do this, edit /etc/ssh/sshd_config: # pico /etc/ssh/sshd_config And add in the following line: PermitRootLogin no Restart SSH service: # /etc/init.d/sshd restart
Recover Ubuntu Boot after Installing Windows
This tutorial applies for Grub version 1. Using Ubuntu Live CD, here are the steps: 1. Open terminal, run grub $ sudo grub 2. On grub command prompt, find boot record grub> find /boot/grub/stage1 or, if result an error, change to: grub> find /grub/stage1 3. Make root. Change X,Y with the number of partition from…
How to Change Postfix SMTP Port on Ubuntu
Nowadays some Internet Service Provider block port 25 which is used by SMTP. We can change this in Postfix to point to another port, for example port 587. Edit /etc/postfix/master.cf $ sudo nano /etc/postfix/master.cf Add # in front of this line: smtp inet n – – – – smtpd and add new line: 587 inet…
Activate Virtualbox USB Thumbdrive on Ubuntu 8.10
1. Search for virtualbox group id, make sure you already put your username under vboxusers group: $ cat /etc/group .. vboxusers:x:122:kumkum .. 2. Add this line to /etc/fstab: none /proc/bus/usb usbfs devgid=122,devmode=664 0 0 3. Reboot system. Finish. Try plug your usb device to VirtualBox. Note: – devgid=122 is vboxusers group id which is taken…
Build FreeBSD Kernel
Make sure kernel source is installed. If it is not installed, use ‘sysinstall’ command. Copy kernel GENERIC configuration: # cd /usr/src/sys/i386/conf/ # cp GENERIC KERNELNEW Edit KERNELNEW configuration as your needed: # ee KERNELNEW And then, build the kernel: # cd /usr/src # make buildkernel KERNCONF=KERNELNEW # make installkernel KERNCONF=KERNELNEW Finish. Reboot PC. To build…
How to Migrate EHCP Server
EHCP is free, open source, and awesome hosting control panel. This guide will show you how to migrate EHCP system version 0.30.4 from Kimcil server to Maho server manually. A. Do Backup on Kimcil Server Backup vhosts files Backup Courier mail files Backup MySQL databases Transfer those 3 files to Maho server in /root folder via…
How to Replace Old Domain URL in wp_posts Table
I migrated my WordPress website to new domain, so I need to update all image URLs in wp_posts, wp_postmeta, and wp_options table which are still pointing to old domain. These are the SQL syntaxs to update the tables: