backup proxysql

 1) cp /var/lib/proxysql/proxysql.db

2) sqlite3 /var/lib/proxysql/proxysql.db .dump > /var/lib/proxysql/proxysql-dump.sql

3) sqlite3 /var/lib/proxysql/proxysql.db ".backup 'proxysql-backup.sq3'"

4) mysqldump -u admin -padmin -h 127.0.0.1 -P6032 --no-tablespaces --skip-triggers -t main mysql_servers --skip-column-statistics > /tmp/dump_servers.sql

5) select config into outfile ...

links

https://proxysql.com/documentation/admin-backups/

https://sakthismysqlblog.wordpress.com/2020/02/18/proxysql-config-file-creation-backup-solution/