WordPress.org

1. clnewbill
   Member
   Posted 2 years ago #

   I am helping someone migrate his site from one webhost to another. The headers on his current WP installation say that it's version 2.0.1.

   In order to not mess with the current installation, I downloaded and installed 2.0.1 in the new web space and then attempted to import the existing database. I intended to then upgrade the WP on the new server to 2.3.1.

   I kept getting SQL errors and find that the table structure of the newly-installed 2.0.1 is not the same as that of the existing version.

   Other than the document headers, is there some definitive way to find out the version of the old installation? Or am I doomed to import this thing one field of one table at a time? (He couldn't pay me enough to make that worthwhile.)

   Oh - I can't export CSV from the old server. SQL only, the whole database, which ends up a bit over 2 MB. There's no way to get a zipped backup. The old server does not use cPanel; it appears to be a proprietary control panel system unique to this hosting firm.

   Import limit on the new server is 51.2 KB.

   Any suggestions?

2. MichaelH
   moderator
   Posted 2 years ago #

   Please review Moving WordPress.

   If you can import the whole SQL backup file to the new host you may have to break in into pieces.

3. moshu
   Member
   Posted 2 years ago #

   1. If you are importing the whole database from the old one - you should drop the tables in the new database... otherwise it will "complain" about already existing table.

   2. For big stuff you may try this:
   http://www.ozerov.de/bigdump.php

4. clnewbill
   Member
   Posted 2 years ago #

   I got it working. The reason the table structure was different was that at some time he had installed a poll plugin that added some tables, which of course weren't in the original 2.0.1.

   Bigdump looks like an excellent program, moshu, thank you. I will use it in future, but it kept choking on the revisions to the old WP in this case.

   I ended up doing a SQL dump of the old database and manually inserting (via SQL query) each table's data individually. It looks okay so far (cross fingers) -- now to tackle the upgrade to 2.3.1.

Topic Closed

This topic has been closed to new replies.