[Sherry]

What does it take to migrate an existing directory to another website?  Is that possible?

If so would it be better to move the directory before upgrading to a purchased template?

Thanks!

[Steven Zahm]

@ Sherry

The only way to migrate entries are to export the Connections tables from phpMyAdmin or similar tool as a SQL file and then import the exported SQL into your new site using phpMyAdmin or similar tool. I’ve done it plenty of times, only takes a few minutes.

Oh, one last thing, if you’ve uploaded any images, you have to copy them via FTP and load them up on the new site via FTP in this folder:
../wp-content/connection_images/

Just install the plugins any add-ons and templates as you normally world.

NOTE: Make sure you do the SQL import before activating Connections for the first time. If you’ve already activated Connections, you have to drop the Connections tables before you do the import.

Hope that helps.

[Sherry]

Ok..  I was working at getting the migration ready.

I have the database downloaded from the one site: xxxxxx_wrdp1.sql

I’m going to load it to golocaltacoma.com, that had connections installed on it and I deleted the install several months ago.  However, when I looked at the database I saw that the database for connections was still on it.  xxxxxxx__wrdp2.sql.

Should I rename the downloaded database to replace the database already on the site?  upload the connection_images file and then add the plug in?

[Steven Zahm]

@ Sherry

Just delete the existing tables on the destination database, then import … or if you want to keep them around, go ahead and change their names.

[Sherry]

Thank you! So I have it all transferred to the new site.. and all is well except for one field (dates)  that is new in the new installation and was not in the tables that I downloaded on the original site and causing a problem.  I am trying to have to avoid having to recreate almost 400 entries.   In doing a quick test in adding an entry and also updating an entry I received this error:

WordPress database error: [Unknown column ‘dates’ in ‘field list’]
UPDATE wp_connections SET ts = '2013-03-10 15:33:58', entry_type = 'organization', visibility = 'public', slug = 'daily-solutions', honorific_prefix = '', first_name = '', middle_name = '', last_name = '', honorific_suffix = '', title = '', organization = 'daily-Solutions', department = '', contact_first_name = '', contact_last_name = '', family_name = '', birthday = '', anniversary = '', addresses = '', phone_numbers = 'a:1:{s:32:\"3a708adba610ee88deafc76b4fe6db94\";a:6:{s:4:\"type\";s:9:\"homephone\";s:10:\"visibility\";s:6:\"public\";s:6:\"number\";s:14:\"(253) 267-8227\";s:2:\"id\";s:2:\"13\";s:5:\"order\";i:0;s:9:\"preferred\";b:0;}}', email = 'a:1:{s:32:\"bb39e94ef6dc438c749c1042d4eaa3a3\";a:6:{s:4:\"type\";s:8:\"personal\";s:10:\"visibility\";s:6:\"public\";s:7:\"address\";s:24:\"info@daily-Solutions.com\";s:2:\"id\";s:2:\"13\";s:5:\"order\";i:0;s:9:\"preferred\";b:0;}}', im = '', social = '', links = 'a:1:{s:32:\"2eb45c915a5759514d53186a50f7b157\";a:11:{s:4:\"type\";s:7:\"website\";s:10:\"visibility\";s:6:\"public\";s:5:\"title\";s:23:\"www.daily-Solutions.com\";s:3:\"url\";s:26:\"http://daily-solutions.com\";s:6:\"target\";s:6:\"_blank\";s:6:\"follow\";i:1;s:2:\"id\";s:2:\"19\";s:5:\"order\";i:0;s:9:\"preferred\";b:0;s:5:\"image\";b:0;s:4:\"logo\";b:0;}}', dates = '', options = 'a:4:{s:5:\"entry\";a:1:{s:4:\"type\";s:12:\"organization\";}s:5:\"group\";a:1:{s:6:\"family\";a:0:{}}s:5:\"image\";a:3:{s:6:\"linked\";b:1;s:7:\"display\";b:1;s:4:\"name\";a:4:{s:9:\"thumbnail\";s:16:\"ds_thumbnail.jpg\";s:5:\"entry\";s:12:\"ds_entry.jpg\";s:7:\"profile\";s:14:\"ds_profile.jpg\";s:8:\"original\";s:15:\"ds_original.jpg\";}}s:4:\"logo\";a:3:{s:6:\"linked\";b:1;s:7:\"display\";b:1;s:4:\"name\";s:19:\"ds01foto_logo_1.jpg\";}}', bio = 'gdrraoitng [oerut', notes = '', edited_by = 1, user = 0, status = 'approved' WHERE id = 13

Warning: Cannot modify header information – headers already sent by (output started at /home/goloca/public_html/wp-includes/wp-db.php:1056) in /home/goloca/public_html/wp-includes/pluggable.php on line 876

[Steven Zahm]

@ Sherry

Well, this does complicate things little. What you’ll have to do is delete the current version of Connections you have installed and install the exact same version you were running on the original server and then upgrade to the latest version. That’s the only way to get things in sync.

[Sherry]

Thanks…

I will go do that – makes sense!

[Sherry]

I loaded the older version (Version 0.7.2.6) of connections and all was well and could add and do updates.  So I went ahead and updated to the latest version and had the same problem with the date field as I reported above. So I deleted and have the older version again.  What am I missing for the upgrade.  I am trying to get it stable for adding the market template.

Thank you for your help!

 

[Steven Zahm]

@ Sherry

Put the older version back on … something I didn’t think of because I never ran across this before, sorry. The upgrade won’t trigger because the “version” option was set from the newer version, so the upgrade is not going to trigger, because the newver version number was already set in that option …  you’ll have to remove the “connections_options” option_name from the wp_options table using phpMyAdmin.

[Sherry]

So if I remove this table then I should be able to update to the newest Connections version without a problem?

Thanks!

[Author]

Posts