The following questions are the main issues I'm facing as I am to move WP blogs to a new host.
1) After uploading a 'backup.sql' file of the original database to the new server, I usually see in the old posts (on new server) weird characters usually replacing accented letters. I read some threads on this mysql problem/bug. Can anybody suggest me the better way (or the thread suggesting it), if it exist, to avoid that it happens?
2)After the move to new server, I would like to change the WP password (to log into Dashbord). Is there a way to do that without doing a fresh installation?
3)As I'd like testing this new server before changing domain DNS, what should I replace (and where), when the test will be completed, to point the Blog Url to the real Blog Domain?