Retaining user ID when importing

With this plugin you will not be able to keep the user IDs from your previous installation. The user table has an autoincremental on the primary key and we use API functions that do not allow SQL calls to achieve what you are asking.

To achieve this you will have to directly use a SQL dump of the user and usermeta tables. But do it carefully.

Many thanks for your quick response.

I’m quite familiar with SQL and feel quite confident, although it would be helpful if you could give me a push in the right direction? Any documentation or anything you recommend? Don’t worry, I have full backups, I wont blame you if anything goes wrong ??

Thanks.

You should do a dump and then upload it of those two tables users and usermeta.

Thanks. What i’ve done is imported the users table using SQL, which went fine. Then used your plugin to import the meta data. The import processes for a while, and all looks ok, but unfortunately it kicks out this error about 1/3 into the import:

The script tried to modify a property on an incomplete object. Please ensure that the class definition “stdClass” of the object you are trying to operate on was loaded _before_ unserialize() gets called or provide an autoloader to load the class definition in /home/DOMAIN/public_html/sms/wp-includes/formatting.php:5148

Any ideas?

Nevermind, I split the user meta into 4x CSV files instead of one huge one and imported them and it seems to have worked fine ??

Thanks for your help.

Great ??