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 »
  • Using Import (Moderator: Yashodha Chaku) »
  • Import succeeds... but no data!
Pages: [1]

Author Topic: Import succeeds... but no data!  (Read 1180 times)

sypl

  • I post occasionally
  • **
  • Posts: 37
  • Karma: 1
Import succeeds... but no data!
January 24, 2010, 09:48:25 am
I recently had to move CiviCRM from one server to another (which is an incredibly convoluted process what with the table dependencies - is there any hope that this will become easier in the future?) and did an import for some new contacts our organisation picked up this month.

The steps all went smoothly and I got the successful import message at the end of the process. But then when I went to search up the contacts none of them were in there! Do you have any idea what could have gone wrong? I can't give you any error message because there was none!

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: Import succeeds... but no data!
January 24, 2010, 09:59:52 am

can u elaborate on what was "incredibly convoluted" about the process?

the steps typically are:

1. use mysqldump to move the db to a new server

2. use: http://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location to fix the settings file

yes step 2, can and should be made easier. Would be great if you can step up and contribute code that simplifies and makes the process easier

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

sypl

  • I post occasionally
  • **
  • Posts: 37
  • Karma: 1
Re: Import succeeds... but no data!
January 24, 2010, 10:30:04 am
I didn't actually rebuild the database - the host admin did. He said the dependencies mean the tables in the database have to be recreated in a specific order, which can't be done with phpmyadmin. Is he wrong there?

The import problem appears to be fixed. I think it was a database permissions thing. I don't have the CREATE TEMPORARY TABLES privilege on by default at my host, but once I changed that it solved a lot of problems.

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: Import succeeds... but no data!
January 24, 2010, 12:57:29 pm

there are multiple ways of transferring db's. you and your host admin might want to check on the web for how to do so. You can turn off constraint checking in mysql temporily by using:

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

(most versions of mysqldump generate that statement automatically)

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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Import succeeds... but no data!

This forum was archived on 2017-11-26.