Use MySQL ON DUPLICATE KEY UPDATE to update data in insert SQL statement
If you get a SQL dump of a database table and want to update part of the data into existing table, you can use the following SQL statement to achieve…
If you get a SQL dump of a database table and want to update part of the data into existing table, you can use the following SQL statement to achieve…
If you want to test a e-mail or test whether the spamassassin rule is working or not, you can use the following command spamassassin -t /the_message.txt Then you will get…
1. check the exim mail query by specific the sender or recipient Sender: exiqgrep -f sender@domain.com Recipient: exiqgrep -r recipient@domain.com 2. Get the message_id from above and add…
1. Umount the filesystem and check it with e2fsck umount /var/lib/vz e2fsck -f /dev/mapper/pve-data 2. Re-size the file system of /dev/mapper/pve-data (Let said to 500GB) resize2fs /dev/mapper/pve-data 500G 3. Resize the Logical Volume of…
Assume you have deleted the harddisk image file of a running KVM guest with id 501. You can restore the deleted image by following step. 1. Check where is the…
做「通渠佬」,畢竟比「IT 人」好,通渠通常很暢快,雖然臭一點,但最起碼立竿見影,通就通,唔通就唔通,一兩個鐘就可以走人;另一方面,朋友們總不好意思叫你免費通渠,也不會在通渠失敗之時,叫你拆了馬桶回家再慢慢通--眼不見為乾淨,你在家修理三十個鐘,對方隨時連一句有誠意的「多謝哂」都沒有,反過來再遇到問題,立即又詛咒你:「乜果個大學讀電腦的友仔咁渣o架,呢頭修理完果頭又壞!」即使通渠不久後又爆屎渠,大家都會怪罪於亂拋垃圾的人,至多都是怪罪於馬桶,而不會怪罪於那個不幸的通渠佬。 轉自:
Since to the patch of php bug #43227 There is no more effect on .htaccess 'php_value mbstring.func_overload' setting. The work-around is to set func_overload into Apache virtualhost config file. php_admin_value…
When you got "23: Out of resources when opening file" or "1016: Can't open file" from Directadmin backup output or mysqldump output, it is all about open-file-limit what you need…
Sometime, you have to Ctrl-C the running yum update. However, it will make the yum or some software brake the dependency and make problem. You may use yum-complete-transaction to resume…
delete rhgb and quiet from /etc/grub.conf