Ning Ma blog

my technology tips

December, 2013

dump and import mysql database avoid error codes

Do not do this, since it might screw up encoding:

Better do:

Note that when your MySQL server is not set to UTF-8 you need to do mysqldump –default-character-set=latin (!) to get a correctly encoded dump. If you only want to dump the structure without data, use

Importing a dump safely Do […]