Thread

We’re in the process of moving our site to a new server, and having some issues moving the db. After exporting the SQL dump via phpMyAdmin, we are unable to completely import to the new server. I’ve isolated the issue to the last insert statement of the versioning table, as well as a separate issue in the weblog_data table. All other tables insert fine when importing one at a time.

A copy of the database can be found at: [mod edited out link for security] - Any help as to what specific data could be causing this error would be greatly appreciated!

greetings!

I edited out the link to your database dump for your sites security.  Depending on the size of your database, you are probably going to need to import it via the command line, or ask your host to do so for you.  I assume it is either one of two things going on,  a.)  db file is too big to import through phpmyadmin, or b.)  the initial dump was not good, and that is while it is failing.

Try to export a new copy of the db and give that a shot, if it fails, speak to your host about loading the db from the file for you.

-greg