Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
becki:linux:mysql_commands [2016-03-17 11:08] becki |
becki:linux:mysql_commands [2017-10-04 12:37] (aktuell) becki |
||
---|---|---|---|
Zeile 65: | Zeile 65: | ||
===== MySql Commands == | ===== MySql Commands == | ||
+ | |||
+ | <note important>In order to get UTF-8 content, you must log in and mysqldump with ''----default-character-set=latin1''. FIXME Dont know why!!</note> | ||
==== Misc == | ==== Misc == | ||
Zeile 171: | Zeile 173: | ||
* Remove all appearences of ''collate latin1_german2_ci'' | * Remove all appearences of ''collate latin1_german2_ci'' | ||
* ''mysqldump'' inserts funny comments which seem to mess with the character set when imported. => Remove all comments in ''backup-file.sql'' | * ''mysqldump'' inserts funny comments which seem to mess with the character set when imported. => Remove all comments in ''backup-file.sql'' | ||
+ | |||
</note> | </note> | ||