Hi, I have an ISPConfig ver. 3.2.7p1 (Perfect Server on Debian 11). I tried to backup the database before making an update, according to the current manual. After typing the following into the console (with correct password of course): Code: mysqldump -h localhost -u root -p[database password] -c --add-drop-table --add-locks --all --quick --lock-tables dbispconfig > dbispconfig.sql I get the message Code: mysqldump: ambiguous option '--all' (all-databases, allow-keywords) What should the correct syntax look like?
i believe for --all what you actually want there is --all-databases, as it states in it's own response.. you are, however, also specifying the database you want to dump 'dbispconfig > dbispconfig.sql', which conflicts with the --all-databases option i'm not sure exactly what it'll do there, just export dbispconfig, all databases, or complain about the extraneous options. also, if it does dump every database, it'll do so into one single file. if you want to dump all databases, into their own individual files, you'll need to run something like; Code: mysql -u root -p -e 'show databases' | while read dbname; do mysqldump -u root -p "$dbname"> "$(date +%Y%m%d)-$dbname".sql; done adding whatever options you want, -add-drop-table, --add-locks, --quick, --lock-tables etc to the mysqldump command section as needed. and removing the '$(date +%Y%m%d)-' part if you don't want the current date as part of the exported filenames
Thanks for your reply. The command is copied 1:1 from the official ISP Config 3.1 manual (page 87). I want to back up only this one particular database named dbispconfig into one single file, which as you noticed is already included at the end of the command. Therefore, I wonder if this part --all should be there at all.
