Answers.Body: <p>When you do your export in phpmyadmin, make sure you check the 'disable foreign key checks' box in the custom options:</p>
  
  <p><a href="https://i.sstatic.net/ZXhG9.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/ZXhG9.png" alt="enter image description here"></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-07T08:53:52.067Z
Answers.LastActivityDate: 2020-01-07T08:53:52.067Z
Answers.UserDisplayName: Seb
Body: <p>Since my hosting provider is blocking <code>mysqldump</code> on its server, I'm trying to do a manual backup of my database in order to import the DB into my test environment. </p>
  
  <p>I'm stuck on the elements to ignore since a manual export on PHPMyAdmin (prod env) and then import to PHPMyAdmin (dev env) environment triggers errors. </p>
  
  <p>Do you guys have any experience in manual backups? </p>
  
  <p>Thanks! :) </p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-12-25T06:15:55.360Z
Comments.Text: "triggers errors" - what errors are you getting?
Comments.UserDisplayName: Brad Bell
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-12-25T10:49:37.893Z
Comments.Text: I tried different setups, ignoring the tables but I still get stuck with new elements, for instance: 
  `DROP TABLE IF EXISTS 'crft_categorygroups'
  
  #1217 - Cannot delete or update a parent row: a foreign key constraint fails`
  
  Is there a list of table that  I should ignore?
Comments.UserDisplayName: katsele
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-12-26T09:35:57.447Z
Comments.Text: Did you already tried to export the DB using SSH `./craft backup/db` command? Perhaps there's wrong settings used with your manual export.
Comments.UserDisplayName: Romain P.
Tags: <craft3><database><back-up>
Title: Craft CMS 3 - Manual database backup
ThreadText: # Craft CMS 3 - Manual database backup
  
  (Asked by: username_0 on 2019-12-24)
  
  Since my hosting provider is blocking `mysqldump` on its server, I'm trying to do a manual backup of my database in order to import the DB into my test environment.
  
  I'm stuck on the elements to ignore since a manual export on PHPMyAdmin (prod env) and then import to PHPMyAdmin (dev env) environment triggers errors.
  
  Do you guys have any experience in manual backups?
  
  Thanks! :)
  
  **Tags:** craft3, database, back-up
  
  > **Comments:**
  > **username_1**: "triggers errors" - what errors are you getting?  
  > **username_0**: I tried different setups, ignoring the tables but I still get stuck with new elements, for instance:  `DROP TABLE IF EXISTS 'crft_categorygroups'  #1217 - Cannot delete or update a parent row: a foreign key constraint fails`  Is there a list of table that  I should ignore?  
  > **username_2**: Did you already tried to export the DB using SSH `./craft backup/db` command? Perhaps there's wrong settings used with your manual export.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2020-01-07. Score: 1
  
  When you do your export in phpmyadmin, make sure you check the 'disable foreign key checks' box in the custom options:
  
  [![enter image description here](https://i.sstatic.net/ZXhG9.png)](https://i.sstatic.net/ZXhG9.png)
  
  
  ---
  
  