It is possible to dump all (or some) of the tables of ProxySQL’s Admin using mysqldump.

Some specific options need to be used with mysqldump , specifically --no-tablespaces , --skip-triggers and --skip-add-locks,.

For example, to dump the mysql_servers table:

mysqldump version 8.0

If mysqldump version 8.0 is used:

  • mysqldump also needs the --skip-column-statistics option
  • it only works from ProxySQL version 2.0.8