tags:

views:

236

answers:

0
+2  Q: 

mysqldump skipping some tables while taking a dump

I'm trying to take a full dump of my database. But while taking a dump, mysqldump skips a few tables. Especially those with foreign keys. But its not that every table with foreign keys is skipped. Some specific tables only! I tried the -f switch. It forced it to include a few tables but still two tables are being skipped. Is this normal? I mean, does this happen? Or my schema has some problems?

related questions

mysql dump tables only
Edit very large sql dump/text file (on linux)
How can I access the MySQL command line with XAMPP for Windows?
MySQL Import Database Error because of Extended Inserts
How to create an identical gzip of the same file?
mysql dump outside the command line
Complex Database Backup
What is the best way/tool to synchronize two MySql servers (not in the same cluster).
Dump mysql view as a table with data
How do I suppress the row count for tables added (AUTO_INCREMENT=N) to mysqldump output?
Problem importing mysql procedures generated from mysqldump --routines
Too many open files error on Ubuntu 8.04
script to convert mysql dump sql file into format that can be imported into sqlite3 db
How to get the exact same output from mysqldump as mysqladmin/backup
How to obtain a correct dump using mysqldump and single-transaction when DDL is used at the same time?
Skip certain tables with mysqldump
MYSQL - How would I Export tables specifying only certain fields?
MySQL permissions issue - should be non-issue
How can I use mysqldump to replicate views between accounts?
Does mysqldump --password really do what it says?
Limiting the number of records from mysqldump?
How do I restore a MySQL .dump file?
Run MySQLDump without Locking Tables
Migrating from MySQL to arbitrary standards-compliant SQL2003 server
mysqldump | mysql yields 'too many open files' error. Why?