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-10-20 13:28] becki [MySql Commands] |
becki:linux:mysql_commands [2017-10-04 12:37] (aktuell) becki |
||
---|---|---|---|
Zeile 66: | Zeile 66: | ||
===== MySql Commands == | ===== MySql Commands == | ||
- | FIXME In order to get UTF-8 content, you must log in etc with ''----default-character-set=latin1''. Dont know why!! | + | <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 173: | 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> | ||