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 »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • sql dump file won't unzip
Pages: [1]

Author Topic: sql dump file won't unzip  (Read 5003 times)

iana

  • Guest
sql dump file won't unzip
August 01, 2007, 01:12:05 am
I'm running Civicrm 1.7 on joomla 1.0.12 Stable on MacOSX 10.4. When I use Backup Data it downloads a file that will not unzip. I get "gunzip: domainDump.sql.gz: not in gzip format." Any ideas, workarounds?

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: sql dump file won't unzip
August 01, 2007, 01:49:27 am

can u run this command on the downloaded file:

$ file domainDump.sql.gz

and let us know what it  returns. Also can you do a

$ less domainDump.sql.gz

and see if it returns sql statements

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

iana

  • Guest
Re: sql dump file won't unzip
August 02, 2007, 05:41:10 pm
$ file domainDump.sql.gz returns "domainDump.sql.gz: data"

$ less domainDump.sql.gz shows binary


I have tried via command line:

$ mysqldump -u civicrm_db_username -pcivicrm_db_password -c -e -n -t civicrm_db > dumpfile

Seems to work. I get sql statements. Is this equivalent to the backup function?

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: sql dump file won't unzip
August 02, 2007, 05:58:48 pm

Yes, i think the mysqldump command with the options below is a data dump. you might also want to store the structure in the dump file. please refer to the mysql web site and/or the mysqldump man pages for more details

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

iana

  • Guest
Re: sql dump file won't unzip
August 02, 2007, 06:18:55 pm
Thanks lobo,

I'm just in the building stage at the moment (no live site). Running cicvicrm 1.7 on Joomla. I am now wanting to switch to Drupal with civicrm 1.8.  I don't want to have to recreate the custom fields, forms, profiles and events that I've made, if this can be avoided. At the moment I don't care about the records. What is the best way of saving this info and upgrading to 1.8? The civicrm database is the Joomla database, so its all mixed together.

iana

  • Guest
Re: sql dump file won't unzip
August 02, 2007, 06:39:59 pm
Answering my own question. What if I backup (dump structure + data) then drop all tables except civicrm tables and then dump structure + data to a new file? Then load the data into the new database and run the SQL upgrade script?

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: sql dump file won't unzip
August 03, 2007, 02:02:55 am

yes that sounds like a workable solution

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 »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • sql dump file won't unzip

This forum was archived on 2017-11-26.