ISPConfig 3 - manual DB backup

Discussion in 'General' started by IFM, Mar 21, 2023.

  1. IFM

    IFM New Member

    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):
    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
    mysqldump: ambiguous option '--all' (all-databases, allow-keywords)
    What should the correct syntax look like?
  2. nhybgtvfr

    nhybgtvfr Well-Known Member HowtoForge Supporter

    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;
    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
  3. IFM

    IFM New Member

    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.
  4. pyte

    pyte Active Member HowtoForge Supporter

    It is not needed.

Share This Page