So your Rails application with a MySQL database was humming along and all of a sudden it hit this error: Mysql2::Error: Incorrect string value: '\xC5\x99\xC3\xA1k What does that mean? Upon inspection you realize that someone has typed into your website the all-too-favorite Millenial communication tool: the emoji....
Read MoreMay
Make a quick dump of a mysql database: mysql_dump db_name > backup-file.sql You can then read that dump file back into the server like this mysql db_name < backup-file.sql or like this: mysql -e "source /path/to/backup/backup-file.sql" db_name ...
Read MoreFirst, isntall MySQL package installer from http://dev.mysql.com/downloads/mysql/5.1.html#downloads DON'T DOWNLOAD THE 64-BIT VERSION!!! You must download the 32-bit version even if you have a 64-bit machine. Then I was able to run this. Note: it is important to give the gem installer the -with-mysql-config flag, and point it to the...
Read More