December, 2013
dump and import mysql database avoid error codes
Do not do this, since it might screw up encoding:
|
1 |
mysqldump -uroot -p database > utf8.dump # this is bad |
Better do:
|
1 |
mysqldump -uroot -p database -r utf8.dump |
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
|
1 |
mysqldump -uroot -p --no-data database -r utf8.dump |
Importing a dump safely Do […]