How do I handle foreign key constraints when backing up mysqldump?

  mysql, question

For example, one table stores the id of another table, or it has its own reference. If it is not processed during backup, an error will occur when the exported file is restored. I use phpmyadmin to back it up now. He can handle it, but I want the program to back it up automatically.

Recommend a Backup ToolXtrabackupSupports hot backup and incremental backup. It is also a physical backup. mysql data files are backed up instead of logical backups. The speed and efficiency will be much faster.

Download address …