mysqldump

This is due to a new flag that is enabled by default in mysqldump 8. You can disable it by adding –column-statistics=0. The command will be something like: mysqldump –column-statistics=0 –host=<server> –user=<user> –password=<password> Check this link for more information. To disable column statistics by default, you can add [mysqldump] column-statistics=0 to a MySQL config file, … Read more

Also you may use: –skip-triggers: if you are using triggers –no-create-db: if you are using –databases … option –compact: if you want to get rid of extra comments