Ubuntu – Backup Amazon EC2 to S3 (Pre-requisites)

Pre-requisites on the server are Amazon S3 tools, and zip sudo apt-get install s3cmd sudo apt-get install zip unzip You then need to configure the s3cmd to use the Access Code and Secret Key from the IAM within your AWS console. Its recommended that you set up a new user with programmatic access only for …
Continue reading Ubuntu – Backup Amazon EC2 to S3 (Pre-requisites)

MySQL Collation Error

Occasionally I come across databases written by other developers who have a complete mix of character sets, and where the database character set does not match the character set of fields within a table. This causes all sorts of nasty errors when trying to use CONCAT or CONCAT_WS. Errors like: Illegal mix of collations for …
Continue reading MySQL Collation Error