CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • Local installation export to web server without modifying existing database
Pages: [1]

Author Topic: Local installation export to web server without modifying existing database  (Read 836 times)

thomvlau

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4
  • CMS version: Joomla
  • MySQL version: Latest
  • PHP version: 4
Local installation export to web server without modifying existing database
April 09, 2013, 11:04:01 am
I have a local Joomla site running. This was build on a website running on the web. Now i have installed civicrm on the local site. I need to transfer the civicrm to the online website without overwriting the database because there have been made modifications that may not be deleted on the online website. What is the best way to do this? Thanks in advance

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Local installation export to web server without modifying existing database
April 09, 2013, 01:01:39 pm

Most likely you will need to write a custom script to do the below.

If you want to xfer the civi database as is, but not modify the joomla DB, its a lot simpler and you can use mysqldump with some options to do that. If you want to merge databases, its a lot more complicated

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Local installation export to web server without modifying existing database
April 11, 2013, 11:49:45 am
   thomvlau, do you want to copy only your CiviCRM from the local site to the online site without changing anything else on the online site? If so, I would do this:

1. Install the same version of CiviCRM on the online site
2. Dump all tables starting with civicrm_ from your local site (using mysqldump or phpMyAdmin)
3. Drop all tables starting with civicrm_ from online local site
4. Import the dump from step 2 into your online site
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

thomvlau

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4
  • CMS version: Joomla
  • MySQL version: Latest
  • PHP version: 4
Re: Local installation export to web server without modifying existing database
April 18, 2013, 10:54:05 am
Thanks for answering, i'm trying to install civicrm on my online database. But it keeps getting stuck... I have contact my host and asked to change my max_execution_time... At this moment it is unlimited, so i have no clue what is going wrong with the installation... Any ideas? I have searched and read about the installation for some hours but haven't been able to solve it. Thanks in advance!

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Local installation export to web server without modifying existing database
April 18, 2013, 11:42:14 am
Quote from: thomvlau on April 18, 2013, 10:54:05 am
But it keeps getting stuck...

Could be a memory issue, could be file permissions. We would need more details to know.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Local installation export to web server without modifying existing database
April 18, 2013, 12:32:13 pm

might save you a fair bit of hours and energy if you switch to a better hosting provider?

like civihosting :)

lobo

disclaimer: i'm not connected or have any business interests in civihosting
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • Local installation export to web server without modifying existing database

This forum was archived on 2017-11-26.