Answers.Body: <p>Best thing to do is to do a complete dump of your old database and import it into a fresh database on your new server. Then use that for your new Civi install. Importing piece by piece creates problems because there is too much data that is reliant on other tables.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-04T17:27:39.163Z
Answers.Text: Yeah, I tried that but had problems.  I guess I'll just reconstruct the membership page in the new environment.
Answers.UserDisplayName: user1147171
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-04T17:54:24.133Z
Answers.Text: Actually, I just heard from civihosting, and they are going to try to fix the errors and do the import for me.  By the way, thank you for waving me off a path that would have led to trouble.
Answers.UserDisplayName: user1147171
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-04T09:11:37.187Z
Answers.LastActivityDate: 2018-01-04T09:11:37.187Z
Answers.UserDisplayName: Jenni Simonis
Answers.Body: <p>Agree with Jenni, trying to do this table for table makes it extremely complicated and probably undoable. So I would do a <code>mysqldump</code> to dump the source database and restore it on the new site.</p>
  
  <p>There are some guidelines here: <a href="https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/" rel="nofollow noreferrer">https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-04T09:37:42.407Z
Answers.LastActivityDate: 2018-01-04T09:37:42.407Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>We are moving to a new site, and when I tried to import our entire current Civi MySQL database to the new site, I had problems.</p>
  
  <p>So I have created a fresh database on the new site and want to try importing things bit-by-bit, starting with memberships.  We have a membership signup page as well as info about past signups. </p>
  
  <p>Can anyone tell me which tables from the current database I need to import to the new site? Any other advice/warnings would be welcome, too! </p>
  
  <p>I am not able to get into the Civi interface (e.g. contributions, events, administer) on the current site, but can access the Civi database. So I want to do this just by exporting and importing from/to the databases.</p>
  
  <p>(I can access Civi and WordPress files on both sites via FTP if that's helpful.)</p>
  
  <p>Both sites are WordPress 4.9.1 and Civi 4.7.29.</p>
  
  <p>Old site is at 1and1, new site at civihosting.</p>
  
Tags: <civimember><import><export>
Title: Where does Civi store membership and membership signup info?
ThreadText: # Where does Civi store membership and membership signup info?
  
  (Asked by: username_0 on 2018-01-04)
  
  We are moving to a new site, and when I tried to import our entire current Civi MySQL database to the new site, I had problems.
  
  So I have created a fresh database on the new site and want to try importing things bit-by-bit, starting with memberships. We have a membership signup page as well as info about past signups.
  
  Can anyone tell me which tables from the current database I need to import to the new site? Any other advice/warnings would be welcome, too!
  
  I am not able to get into the Civi interface (e.g. contributions, events, administer) on the current site, but can access the Civi database. So I want to do this just by exporting and importing from/to the databases.
  
  (I can access Civi and WordPress files on both sites via FTP if that's helpful.)
  
  Both sites are WordPress 4.9.1 and Civi 4.7.29.
  
  Old site is at 1and1, new site at civihosting.
  
  **Tags:** civimember, import, export
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2018-01-04. Score: 2 | Accepted answer
  
  Best thing to do is to do a complete dump of your old database and import it into a fresh database on your new server. Then use that for your new Civi install. Importing piece by piece creates problems because there is too much data that is reliant on other tables.
  
  > **Comments:**
  > **username_0**: Yeah, I tried that but had problems.  I guess I'll just reconstruct the membership page in the new environment.  
  > **username_0**: Actually, I just heard from civihosting, and they are going to try to fix the errors and do the import for me.  By the way, thank you for waving me off a path that would have led to trouble.  
  
  ---
  
  ### Answer by username_2 on 2018-01-04. Score: 0
  
  Agree with username_1, trying to do this table for table makes it extremely complicated and probably undoable. So I would do a `mysqldump` to dump the source database and restore it on the new site.
  
  There are some guidelines here: <https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/>
  
  
  ---
  
  