MySQL notes

Version 1 by Stephane Carrez

Mysqldump and UTF-8 Problem

Solution:

mysqldump -u username -p --default-character-set=latin1 -N database > backup.sql

then restore with:

mysql -u username -p database < backup.sql