mysql export – import
-
Hello
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.
What’s wrong?
How do I solve this problem?sincerely
Lars
- The topic ‘mysql export – import’ is closed to new replies.