mysql export – import
A backup is a backup IF and ONLY IF the restore works.
1) I export from the wordpress/mysql as xml or sql dump via phpMyAdmin. I get either an xml or SQL text file.
2) I import in my local system
All tables, all data is there except that “Ã…Ã„Ã–Ã¥Ã¤Ã¶” and various chars >127 are wrong. Consequently all swedish text is garbled. The restore fails.
It seems that the extended chars are UTF-8 in the file, but the exported file is not a vaild UTF-8 text file. At least that’s what BBEdit/Textwrangler claims when it opens the file. The three last letters in the alphabet ( Ã¥Ã¤Ã¶ ) are there, but so are various &#nnn chars that shouldn’t be. When I later lok at the resutl through the local WordPress also the Ã¥Ã¤Ã¶ are gone.
How do I solve this problem?
- The topic ‘mysql export – import’ is closed to new replies.