<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>

CC BY-SA 4.0
2020-01-07T08:53:52.067Z
2020-01-07T08:53:52.067Z
Seb
<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>

CC BY-SA 4.0
2019-12-25T06:15:55.360Z
"triggers errors" - what errors are you getting?
Brad Bell
CC BY-SA 4.0
2019-12-25T10:49:37.893Z
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?
katsele
CC BY-SA 4.0
2019-12-26T09:35:57.447Z
Did you already tried to export the DB using SSH `./craft backup/db` command? Perhaps there's wrong settings used with your manual export.
Romain P.
<craft3><database><back-up>
Craft CMS 3 - Manual database backup
# 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)


---

