So something changed and now I need to do something different, but mysqldump -all-databases -no-tablespaces -single-transaction -quick -lock-tables=false > ~/backups/full-backup-$(date +%F).sql -u zabbix -pEnter cat *.sql- MySQL dump 10.13 Distrib 8.0.27, for Linux (x86_64)- Host: localhost Database:- Server version 8.0.27-0ubuntu0.20.04.1 DB is 36GB on disk and previous dumps were in the 750MB file size range. Now the command completes successfully but it doesn't dump any data. Today that results in a process privilege error, so a workaround is the no tablesspace option. Mysqldump -all-databases -single-transaction -quick -lock-tables=false > ~/backups/full-backup-$(date +%F).sql -u zabbix -p For a long time I have been using this command to back up a database
0 Comments
Leave a Reply. |