CiviCRM Community Forums (archive)

I would suggest you install a fresh copy of CiviCRM in WordPress first.

Now the easiest way is to export data from your Joomla CiviCRM and then import it into the WordPress one, using the regular web interface.

If you have a lot of data, or too many types of data like events and groups and tags etc. to do that, then you could try remove everything from your new WordPress CiviCRM DB (or all CiviCRM tables if it's a shared DB) and then replace that with all the tables from the Joomla CiviCRM (but only the CiviCRM tables of course). Then run

UPDATE `civicrm_domain` SET `config_backend`=NULL ;
in MySQL.

The only issue that may be open is the link between contacts and Joomla users. Since your WordPress user list will not match your Joomla one, this needs to be reset, but you can run the contact-user synch tool in CiviCRM to fix that.

This second idea is experimental, but you're encouraged to give it a try and see what happens.

Choose to disable foreign key checks when you make your dump from the existing DB.

Use phpMyAdmin to export ONE small table with click disable foreign key checks. Then you will see the disable foreign key checks code at the top and bottom of the export. Copy and paste that into the top and bottom of your bigdump dump and see if that works.

Beyond that, if you're spending "several days and numerous attempts" to do something which is a 3 minute job via ssh, I would consider switching hosts to one that can provide better service.

Try http://<your_wordpress_home>/wp-admin/admin.php?page=CiviCRM&q=civicrm/ and then whatever else such as

/admin/setting/updateConfigBackend&reset=1

etc.

Your URL is incorrect. Try

http://<mywebsiteaddress>/wp-admin/admin.php?page=CiviCRM?page=CiviCRM&q=civicrm/admin/setting/updateConfigBackend&reset=1

Stupid question, but of course if you go to http://<mywebsiteaddress>/wp-admin/admin.php in the same browser, you are logged as the WP admin, right?

Sounds like you have a problem with your basic WP install. The URL http://<mywebsiteaddress>/wp-admin/admin.php should work. See http://wordpress.org/support/topic/wordpress-site-working-but-wp-adminadminphp-error A bit old, but this URL should work.