Answers.Body: <p>I have used "big dump"to move big databases ozerov.de/bigdump/ with good success</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-08-09T12:00:32.043Z
Answers.Text: The topic here is not to move the database directly to a different location. To retrieve the information I requested in the database.
Answers.UserDisplayName: Fatih ATEŞ
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-08-08T21:25:37.687Z
Answers.LastActivityDate: 2019-08-08T21:25:37.687Z
Answers.UserDisplayName: Mary N
Body: <p>I received a SQL error while updating CiviCRM. He asked me to restore the old database, but I didn't have a backup at the time. Therefore I could not make a healthy update. Then I applied all the updates, but I still get "Database Partially Upgraded - Database check failed" warning for the database. </p>
  
  <p>I have very serious data. I don't want anything to happen to this data.</p>
  
  <p>So I thought of something like this. I'm going to build a new Joomla - CiviCRM. In my setup, I will rebuild all the fields as in the old site. Then I will import the data from the old domain.</p>
  
  <p>But here's the thing. There are more than 130000 activities. It is not possible to transfer such data in bulk. It is not even possible to get 100 pieces because it gives a constant error.</p>
  
  <p>Here are the data I'm trying to get.</p>
  
  <p>Contact ID, Contact Type, Sort Name, Display Name, Contact Source, Contact Hash, First Name, Last Name, Email Greeting ID, Postal Greeting ID, Addressee ID, Created Date, Modified Date, Addressee, Phone, Phone Type, Activity ID , Activity Type, Activity Type ID, Subject, Activity Date, Duration, Details, Activity Status, Activity Priority, Source Contact, Source Contact ID.
  I also have custom fields that I have created for Activity Types.</p>
  
  <p>How can I transfer all this without problems.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-08-08T14:49:06.043Z
Comments.Text: Does the old site run at all? Could you do something like write a script to use the api to transfer all the contacts over and then the activities?
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-08-09T03:09:12.373Z
Comments.Text: It sounds like if you could explain the problems you are hitting with the upgrade eg on https://chat.civicrm.org/civicrm/ then someone could help you get out of the problem without rebuilding, or data transfers.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-08-09T11:47:02.083Z
Comments.Text: Hi  Demerit; Old ste is working. I'm processing but I don't know how to create an API.
Comments.UserDisplayName: Fatih ATEŞ
Tags: <joomla><import><export><backups>
Title: How to Transfer Big Data to a Different Domain
ThreadText: # How to Transfer Big Data to a Different Domain
  
  (Asked by: username_0 on 2019-08-07)
  
  I received a SQL error while updating CiviCRM. He asked me to restore the old database, but I didn't have a backup at the time. Therefore I could not make a healthy update. Then I applied all the updates, but I still get "Database Partially Upgraded - Database check failed" warning for the database.
  
  I have very serious data. I don't want anything to happen to this data.
  
  So I thought of something like this. I'm going to build a new Joomla - CiviCRM. In my setup, I will rebuild all the fields as in the old site. Then I will import the data from the old domain.
  
  But here's the thing. There are more than 130000 activities. It is not possible to transfer such data in bulk. It is not even possible to get 100 pieces because it gives a constant error.
  
  Here are the data I'm trying to get.
  
  Contact ID, Contact Type, Sort Name, Display Name, Contact Source, Contact Hash, First Name, Last Name, Email Greeting ID, Postal Greeting ID, Addressee ID, Created Date, Modified Date, Addressee, Phone, Phone Type, Activity ID , Activity Type, Activity Type ID, Subject, Activity Date, Duration, Details, Activity Status, Activity Priority, Source Contact, Source Contact ID.
  I also have custom fields that I have created for Activity Types.
  
  How can I transfer all this without problems.
  
  **Tags:** joomla, import, export, backups
  
  > **Comments:**
  > **username_1**: Does the old site run at all? Could you do something like write a script to use the api to transfer all the contacts over and then the activities?  
  > **username_2**: It sounds like if you could explain the problems you are hitting with the upgrade eg on https://chat.civicrm.org/civicrm/ then someone could help you get out of the problem without rebuilding, or data transfers.  
  > **username_0**: Hi  username_1; Old ste is working. I'm processing but I don't know how to create an API.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2019-08-08. Score: 0
  
  I have used "big dump"to move big databases ozerov.de/bigdump/ with good success
  
  > **Comments:**
  > **username_0**: The topic here is not to move the database directly to a different location. To retrieve the information I requested in the database.  
  
  ---
  
  