I stepped on a mine in mysqldump (continued) mysqldump
I have never stepped on this mine, but today, Mr. Zhou recorded his record on weibo. it must have been a pain point in the hearts of his elders.
Why? I think this is exactly the same as the record I stepped on last time. What's different is that I am at the database level, while Zhou is at the table level.
If you are interested, consider it as follows: I stepped on a mine in mysqldump.
This default deletion operation is really not worth the candle, ah, ah, can't stand it, the function is also not good, it is completely different from the MySQL style, completely belongs to the PG class.
Next I will reveal the pain points in the old Zhou's mind :-)
1 default backup
[18:22:57-root @ ssdtest :~ ] # Mysqldump-S/data/mysql/test_3312/mysql. sock -- single-transaction -- force test> s1. SQL
2 plus -- skip-add-drop-table
[17:56:18-root @ ssdtest :~ ] # Mysqldump-S/data/mysql/test_3312/mysql. sock -- single-transaction -- skip-add-drop-table -- force test> s2. SQL
I hope you can read these two articles when using mysqldump, so that you do not know
Good Luck!