1

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! :)

  • "triggers errors" - what errors are you getting? – Brad Bell Dec 25 '19 at 6:15
  • 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 Dec 25 '19 at 10:49
  • 1
    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 Poirier Dec 26 '19 at 9:35
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

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.