I hope the transition was seamless. I hope you noticed nothing. Yes i just finished transferring this wordpress blog from one server to another. But it was painful!
What was painful?
- difference in mysql server versions
- character encoding
What to do with downgrading in MySQL?
I had to down grade from MySQL 4.1.21 to 3.23.49. First I just did a simple SQL export and tried to import the data into 3.23.49. BUT there are a lot of ‘stuff’ that 3.23.49 did not accept (newer features in newer versions) causing some errors.
So after some head banging, I found this button in phpmyadmin – SQL export compatibility:
now tables structures and data transferred just fine. Giddy UP!
What to do with character encoding incompatibility.
The solution I came up with it was this.
1. Install a WordPress plugin called WordPress Export – Plugin URI: http://blog.usf.edu
2. Export the data.
3. Save the gz file and uncompress it. You will get a .sql file.
4. Open the SQL file in a browser (I used FireFox) and copy the “insert into” command.
5. Paste the command into the target servers phpmysql.
Now I have it running.
