I use CiviCRM 4.5.8 with WordPress. I'd kinda like to try a newer version, but I don't want to mess up the production website. I used the WP plugin Duplicator to create a test site. I changed the civicrm.settings.php file and now I can maintain the CiviCRM database from either website. Then I tried to use phpMyAdmin to export the civicrm database with a new name. Then I used the DreamHost panel to create a database with that name. The phpMyAdmin import failed with a foreign key check error, so I turned that check off and started over with a new database name. I did the export, create database and import and now I get error "#1050 table civicrm_acl already exists". It's a fresh database, so that doesn't make sense. The database is 44M, so I suspect I'm having some sort of timeout/retry problem? I found Moving an Existing Installation to a New Server or Location, but the copying database part of it confuses me. 7.b. Substitute mysql_username, cms_db_name and dump_file_name_of_your_choice with appropriate values. My SQL experience was last century!
Another strategy, would be a fresh install of a newer version (what recent version would you recommend?). Then I'd have to export the data from 4.5.8 and import it into the new database. We just use the contact database and CiviMail. But wouldn't I lose all the groups, tags, notes, relationships, etc?
The third strategy would be to upgrade the test site and if it works well, I could use either use Duplicator to copy the test site to the production site or upgrade the production to the new version of CiviCRM. So many choices and none of them easy. Maybe I should just stick with good 'ol 4.5.8?? Thanks for any advice!!