Making the server switch was an easy task. I uploaded my sql database in it’s new home and checked if things where fine. At first sight, it looked fine, but when I wanted to post something on my blog, I would get the
Duplicate entry ’0′ for key 1 error showing up. Did a little search on the subject to find out that my exported database didn’t contain the auto_increment ability in it… (I’m using wordpress 2.0.1 with phpmyadmin 2.6.2 (if I’m right))
So to make a long story short, here’s how I fixed it:
1. Go into your phpmyadmin panel.
2. For each tables structure, edit the first entry (which should be a primary key such as ID).
3. Delete the 0 in the default value and select “auto_increment” in the drop-down menu next to it (on the right).
4. Save.
5. Go to the next table and do the same.
After doing this, you should not face the problem anymore. Thanks to search engines for the answer