SQL copy data from one table to another:
INSERT INTO table1 (column1, column2 ) SELECT collumnn1, collumn2 FROM table2 WHERE collumnn1 > 0 ;
CentOS - Update server and fix problem with apache not starting because of port conflict:
[root@domain ~]# yum -y update //updates packages. -y responds with yes to all
[root@domain ~]# reboot //restart server
[root@domain ~]# lsof -i :80 //httpd not working so checking for services on 80
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
httpd 2907 root 4u IPv6 9367 TCP *:http (LISTEN)
[root@domain ~]# kill 2907 //kill the process
[root@domain ~]# lsof -i :80 //check for additional processes on 80
[root@domain ~]# apachectl -k start //now apache can load on 80
Apache/2.2.x mod_ssl/2.2.x (Pass Phrase Dialog)
Some of your private key files are encrypted for security reasons.
In order to read them you have to provide the pass phrases.
  Emails header show localhost.localdomain [127.0.0.1] and sender as apache@localhost when sending mail through postfix using php mail() function. So how do you remove localhost from the header?:
Fix is to change the directive in the php.ini file from:
sendmail_path = /usr/sbin/sendmail -t -i
to:
sendmail_path = /usr/sbin/sendmail.postfix -t -i