Steven Zahm@ Sarah
First log into the source site, and navigate to the Connections :: Settings admin page and click the Search tab. Disable the FULLTEXT option.
You would have to log in to the source site’s web host control panel (usually cPanel) and log into the phpMyAdmin tool.
Using phpMyAdmin, you would selected all the Connections related tables from within the WordPress database. They are easy to locate because the all start with {wpdb_prefix}_connections. The {wpdb_prefix} is the WordPress database prefix of the database.
After all are selected, click the Export option. Choose the SQL option with the default settings. Save the SQL on your local desktop.
Now, log into the destination site. Here you can backup all the Connections tables by renaming them or use backup plugin for WordPress to backup the site first. The latter should be preferred. Alternatively, you could simply just delete the existing Connections tables.
After you have backed up or deleted the existing tables on the destination site import the SQL file you exported. When the import is completed, you’ll likely have to rename the tables newly imported tables with the correct database prefix.
Lastly, navigate to the Connections :: Settings admin page and click the Search tab. toggle the FULLTEXT option, disable then enable. Do this so the FULLTEXT search indexes are recreated.
It sounds like a lot but it generally takes about 15 minutes. If you wish, you can supply me with the relevant logins and I can do quickly for you. The details could be posted here as a private reply.