I have many wordpress sites which have been developed for my clients over the past few years. Frequently the clients want to move their sites to a new server and often a new domain.
This should be a very simple process and I have been doing it for many years.
My process is very similar to this: http://codex.wordpress.org/Moving_WordPress
Basically I copy the files across and export the database. When the domain is changing I do a find and replace on the database sql file. Sounds very straight forward.
Many extremely popular plugins lose data when you export the database using phpmyadmin. Two such plugins which I have one of on every single site I ever build are "contact form 7" and "gravity forms".
Both of these lose data during the move.
Many other plugins also lose data but I'm not going to list them here.
I have posted about this before of the respective forums for these plugins and they blame phpmyadmin. Saying it does not export the data "properly". That's all fine and dandy for them to say but how am I supposed to move my sites if not to use phpmyadmin?
Currently I have no choice but to use php my admin and then copy over or rebuild the sections that were damaged. Usually the email details in contact form 7 and the forms in Gravity forms. All forms are actually lost in gravity forms, however their meta data restore tool is able to recover some, but not all. Some must be replaced manually.
This is incredibly time consuming and painful to do every time I move a site.
Can someone tell me exactly how I can either export from phpmyadmin and preserve all of the data (no data loss at all) or alternatively how else can I export then import the whole database and preserve it's integrity and not lose any data.
Why are these plugins written in such a way that they contain data which is lost by phpmyadmin, the most popular database management software in the world?
Any idea would be appreciated.