[Steven Zahm]

@ Yanique

Please use a plugin such as Duplicator or the site migration features of BackupBuddy. These plugins will ensure the proper migration of the WordPress database and any custom tables in use by plugins such as Connections. If you are manually moving data, that can cause problems with WordPress such as this.

The other tip I can provide… turn off FULLTEXT query support on the Connections : Settings admin page before migrating the data. If the destination database does not support FULLTEXT then the data will fail to import.

Hope this helps!