Reply To: How to migrate categories and listings to a new site

12/10/2015 at 4:34 pm #357603
Steven Zahm
Keymaster

re: Thomas

If you are migrating an entire site, I recommend BackupBuddy. Similar plugin should work just fine.

If you want to migrate just the Connections stuff, that is a bit more difficult but not that difficult… here’s how:

First, copy the ../wp-content/uploads/connections-images/ folder and its contents from the source site to the destination site.

Login into the phpMyAdmin for the source site and do a SQL export of all the {prefix}_connections tables. There’s roughly a dozen of them. When doing the export, just choose the quick export option (or whatever it is called). No need to change any of the default setting when doing the SQL export.

Login to the phpMyAdmin for the destination site.

First, since you already have Connections installed on the destination site, drop (delete) all of the {prefix}_connections tables.

Now do a SQL import. When doing the SQL import, select the file you previously exported. Again, just leave the default options.

After the import completes, you’ll have to change the table {prefix} to match the table prefix being used in the destination site.

Sounds like a lot but depending on the size of you directory, it only takes 10–20 minutes.

Hope that helps!