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) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Problems moving to production server
Pages: [1]

Author Topic: Problems moving to production server  (Read 754 times)

lukenn

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 3.4.5
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.42
  • PHP version: 5.
Problems moving to production server
August 16, 2011, 10:35:19 am
Hi there,

I'm trying to move my Drupal v.6.22 site to our production server, except I'm having some trouble following the instructions.

I wasn't in charge of setting up the local test site, so don't actually have access to it, instead I have just been sent the databases and htdocs folder. The problem I run into is that the test site has phpMyAdmin installed, which is what the guy used to export the databases, and the production server does not have phpMyAdmin, I am using Sequel Pro to manage the databases.

When following the instructions I referred to the documentation for specifically using phpMyAdmin to transfer the databases (sorry, not allowed to post a link), but the steps that involve deleting the constraint information from a dump of the new install I can't follow, since the database dump I get is from Sequel Pro so doesn't contain the constraint information phpMyAdmin dumps do.

The guy managing the test server can only use PMA to get the dumps.

In case you hadn't guessed I'm pretty new to all this! What would be the best way to 'mix' the two sets of instructions, since I can't follow steps 5+ on the PMA instruction page. Hopefully I've explained this fully!

Many thanks!

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Problems moving to production server
August 16, 2011, 10:41:30 am
Migrating a site does not require adjusting any MySQL constraints. Try it without that, and if you have problems, post the link not as a URL such as site dot com slash somepage.htm. Then we can manually browse to it. :)
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.

lukenn

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 3.4.5
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.42
  • PHP version: 5.
Re: Problems moving to production server
August 16, 2011, 10:51:30 am
Thanks for replying. These are the instructions I told him to follow using PMA:
wiki dor civicrm dot org slash confluence/display/CRMDOC40/Moving+the+database+using+phpMyAdmin

The instructions I am following are:
wiki dor civicrm dot org slash confluence/display/CRMDOC40/Moving+an+Existing+Installation+to+a+New+Server+or+Location

So he has sent me the files from steps 1&2. Are you saying I should just be able to inport the database from step 2 (database minus the troublesome 5 tables) without any problems? I'll give it a try and get back to you.

Cheers

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Problems moving to production server
August 16, 2011, 11:45:38 am
Yes. I don't know what that first page is. I use the basic method of

http://wiki.civicrm.org/confluence/display/CRMDOC40/Moving+an+Existing+Installation+to+a+New+Server+or+Location

but the truth is those 5 tables can ALSO be transferred--I have always transferred all tables and never had a problem. I just run this of course:

Code: [Select]
UPDATE civicrm_domain SET config_backend = null;
after the transfer and that's about it for DB stuff.
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.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Problems moving to production server

This forum was archived on 2017-11-26.