CiviCRM Community Forums (archive)

Greetings, I'm rying for the first time to use Akeeba to move/copy a Joomla site with a configured CiviCRM, using http://wiki.civicrm.org/confluence/display/CRMDOC40/Moving+an+Existing+Installation+to+a+New+Server+or+Location as my guide.  When I get to Step 6 of that document (access URL http://<joomla_site>/administrator/index2.php?option=com_civicrm&task=civicrm/admin/setting/updateConfigBackend&reset=1) I get database errors.  I think my trouble might be in the Akeeba backup settings, can someone review the below procedure and see if I'm missing something?

My setup:
Joomla: 1.5.23
CiviCRM: 3.0.0 (YES, I realize this is an old version. Ironically, I'm trying to create a test environment where I can test the 3.4 upgrade before doing it on the live site!)
Akeeba: 3.3.a3

1. Run an Akeeba backup with settings to exclude the data from the database tables listed in the Confluence document(civicrm_domain, civicrm_acl_cache, civicrm_acl_contact_cache, civicrm_cache, civicrm_group_contact_cache), as well as the files/folders in the /media/template_c directory. (I've tried backups with settings for both "ignoring" the db tables completely, and simply "excluding" the data. See errors below.)

2. Used Akeeba Kickstart and Installer to unpack and set up the site on the test server.

3. Updated the following files with the correct database and file paths for the test server:
/administrator/components/com_civicrm/civicrm.settings.php
/administrator/components/com_civicrm/civicrm/civicrm.config.php
/components/com_civicrm/civicrm.settings.php

4. run this against the database (from lobo's post http://forum.civicrm.org/index.php/topic,6076.msg26765.html#msg26765)
update civicrm_domain set config_backend = null;
truncate civicrm_menu;

5. Try to access http://<joomla_site>/administrator/index2.php?option=com_civicrm&task=civicrm/admin/setting/updateConfigBackend&reset=1

Resulting errors from this step:
-- if I use an Akeeba backup set up to completely ignore the tables described in the "Moving+an+Existing+Installation..." document, I get "TABLE DOES NOT EXIST" errors (of course).
-- if I use an Akeeba backup set up to include the table structures, but ignore the data, I get "DB Error: constraint violation..." on a statement "INSERT INTO civicrm_menu"

Thoughts?  Can Akeeba still be used to move CiviCRM, or do I need to do something like this: http://wiki.civicrm.org/confluence/display/CRMDOC40/Moving+the+database+using+phpMyAdmin

Thanks!

Hi Dave, thanks for the reply.  I'll try reverting to Akeeba 3.2.7 -- I didn't even notice 3.3 wasn't stable yet! -- try again, and let you know how it goes. 

Thanks for the info nikosdion! Sorry for the delay in my response...real life put some other professional priorities ahead of this problem.  I'm going to try this now and will post the results.

Hi Again,

Maybe my setup is different to yours but I moved a website to create a dev version in a subdirectory only the other day with akeeba and it worked fine, I just restored a full backup then changed the config files and did the stuff in the admin section and it worked.

Confused as to why mine is ok when yours is throwing errors, I have only got custom data created directly in civi so I'm presuming all the FK constraints are only normal ones.

humm

Dave

Sorry to hear about the continued issues!

I recently setup XAMPP on a windows laptop and used akeeba to move my site, all went ok (apart from a few settings that were quirky in windows - see other posts - lol)

There were no database issues at all in terms of the move.

What hosting are you using for your live site?

Hope you have more success soon.

Cheers,

Dave