Geek Answers Handbook

mysqldump skips some tables when backing up

I am trying to take a complete dump of my database. Accepting a dump, mysqldump skips several tables, especially with foreign keys. This is not that every table with foreign keys is skipped. Just some specific tables!

I tried the -f switch. This made him include several tables, but still two tables were missing.

This is normal? I mean, is this happening? Does my circuit have some problems? How can this be solved?

+5
source share
1 answer

Regarding @Nikhil's comment on McAfee. I came across a situation where McAfee tried to read (and thereby block) temporary files that MySQL creates when queries are moved from memory to temporary. We had to create a specific rule that prevented McAfee from trying to scan a temporary file so that MySQL had no problems. In this situation, I realized that McAfee is doing something similar with the MySQL dump process.

+1
source

More articles:


All Articles