Monday 07 Oct 2013

轉換disk to recovery iso

kvm -cdrom clonezilla-live-2.1.2-43-i486.iso -m 1024 -hda /dev/sdc -boot d clone sda to image create recovery iso

How to change Collation to utf8_bin in one go

If you also need to update the existing character encoding (unlikely by the sounds of things), you can use:

ALTER TABLE \<table name> CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;