… CHARACTER SET utf8; Does nothing except changes table/column encodings, but no actual content changes. So.. After this mysql thinks my table is utf8… SET column=CONVERT(CONVERT(column USING binary) USING utf8) WHERE id=123; And it.. Does nothing. £ sign stays the same, nothing changes. Server…
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
… you could screw your data, for example by specifying utf8 as default character set together not to mention infamous timestamp format change which… about the problems Upgrade Script fails to shut down MySQL Server. Obviously nothing can work without this one. Upgrade Script Removes…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…fifo. Every million lines, the script prints an EOF character to the fifo, closes it and removes it, …utf8 Here’s the result of loading the entire 4GB file in one chunk: time mysql -e “set foreign_key_checks=0; set… to try this on an I/O-bound server and see what the performance impact is, especially …
