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) »
  • [SOLVED] Cannot import CiviCRM database into new installation
Pages: [1]

Author Topic: [SOLVED] Cannot import CiviCRM database into new installation  (Read 1320 times)

leupi

  • I post frequently
  • ***
  • Posts: 192
  • Karma: 2
[SOLVED] Cannot import CiviCRM database into new installation
February 14, 2012, 10:47:43 am
I copied my production Drupal/CiviCRM environment to a test server and imported the Drupal database via phpmyadmin and that seemed to work fine. I am now trying to import the CiviCRM database but am not having any luck.

The database is about 190MB. I changed the max uploadable filesize in my php.ini to 250MB and changed the php timeout to 360 sec. Before making these changes the import would timeout with only about 14 tables being imported. It said that I could resume the import but I never got more than 14 tables. After changing the php timeout to 360 I no longer get a timeout but after the import I have an empty database, no tables at all.

I tried uploading the file as a tar.gz but got an error every time. I then tried to upload as a zip but ended up with an empty database.

Any thoughts as to what I can do with this?
« Last Edit: February 14, 2012, 11:42:12 am by leupi »

leupi

  • I post frequently
  • ***
  • Posts: 192
  • Karma: 2
Re: Cannot import CiviCRM database into new installation
February 14, 2012, 11:27:34 am
Now I am exporting the civicrm.sql file from the prod server as civicrm.sql.gz and importing it to the test server and it is no longer giving me an error. It seems to upload within a few minutes (it at least says 100%), but then is sits there for a while saying that it is still uploading. After a while I again get the message:
Code: [Select]
Script timeout passed, if you want to finish import, please resubmit same file and import will resume.I restart the import but never gets above 14 tables in the database. On prod that same database has 188 tables. The gzipped file is only about 18MB vs the 190MB of the original, un-gzipped file.

leupi

  • I post frequently
  • ***
  • Posts: 192
  • Karma: 2
Re: Cannot import CiviCRM database into new installation
February 14, 2012, 11:41:27 am
OK, finally got it. I went to prod and truncated all of the cache tables, made the exported file orders of magnitude smaller. Imported fine this time.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: [SOLVED] Cannot import CiviCRM database into new installation
February 15, 2012, 04:44:32 am
Glad you solved it, but please note that this is not a CiviCRM issue, this is a phpMyAdmin or MySQL problem. For large imports, the command line is generally preferable.
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) »
  • [SOLVED] Cannot import CiviCRM database into new installation

This forum was archived on 2017-11-26.