Craft CMS 3 - Manual database backup 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! :)
When you do your export in phpmyadmin, make sure you check the 'disable foreign key checks' box in the custom options: