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 »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • MySQL Issue
Pages: [1]

Author Topic: MySQL Issue  (Read 489 times)

hyde0429

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: 3.5.1
  • MySQL version: 5.5.29-0ubuntu0.12.04.1
  • PHP version: 3.4.10.1deb1
MySQL Issue
February 28, 2013, 11:35:46 am
I am trying to import an sql database dump that I have for an existing Drupal-based site that uses CiviCRM.

What I am doing is creating a new db on my Ubuntu 12.04 machine [localhost], and then importing the SQL.

I am getting this error when I do so:

#1054 - Unknown column 'retailba_crmDB.civicrm_domain.id' in 'field list'

It appears that the database is importing otherwise. What I need to know is - will this error affect my migration of the DB from the localhost to a new Wordpress installation?

From what I am reading, I should be able to proceed without this [as the instructions have me dropping tables related to the domain when I migrate]... but I want to be certain.

Can one of you kindly provide me with some assistance? Thanks!
« Last Edit: February 28, 2013, 11:43:37 am by hyde0429 »

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: MySQL Issue
February 28, 2013, 11:56:17 am
Your error indicates that the SQL dump is specifying the name of the DB and it may not match your local DB's name. Anyhow you can not proceed with the civicrm_domain.id column existing and having the proper data--this is a requirement.

Can you try the dump again and avoid using the DB name? I think that may be the issue.
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.

hyde0429

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: 3.5.1
  • MySQL version: 5.5.29-0ubuntu0.12.04.1
  • PHP version: 3.4.10.1deb1
Re: MySQL Issue
February 28, 2013, 12:07:34 pm
Okay, now I feel silly.  :-[

I should have seen that. I simply opened up the monster in a text editor and noted the DB name at the top of the file and imported using that name as the DB name on my localhost. It imported perfectly.

So now on to the next question, and I really appreciate your advice - I'm migrating this thing to a completely fresh Wordpress installation. Is there anything I should know that might help in my migration efforts?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: MySQL Issue
February 28, 2013, 12:31:15 pm
Yes, you should know about this URL:

http://wiki.civicrm.org/confluence/display/CRMDOC41/Moving+an+Existing+CiviCRM+Installation+from+one+Drupal+frontend+to+another

That's 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.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • MySQL Issue

This forum was archived on 2017-11-26.