Quick and easy code to convert the character set of a MySQL table to UTF-8. Of course this works for all character sets not just UTF
ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
I recently rebuilt the Cornwall24 website in the hope that upgrading from a 3 year old verwion of PostNuke to a new version of Wordpress might stop the site taking down the server by overloading MySQL at least once a week.
Unfortunately it actually made things worse!
So I decided to take the bull by the horns [...]
The problem:
What I wanted to do here was find a way of speeding up a query that was run on MySQL database on a different server. Also I’m a big fan of caching generally, especially when the data is only updated once or twice a day.
When I was running the queries directly off the remote [...]
Continue reading about Caching remote MySQL queries with PHP