dbispconfig, roundcube, phpmyadmin, mysql, opendmarc db backup

Discussion in 'Installation/Configuration' started by francoisPE, Mar 31, 2021.

  1. francoisPE

    francoisPE Member HowtoForge Supporter

    Hello,
    When running ispconfig with perfect server set up (ubuntu 20.04 in my case), there are several db in mariaDB, that appears :
    - dbispconfig,
    - roundcube,
    - phpmyadmin,
    - mysql,
    - opendmarc,
    (not sure for performance_schema, information_schema)
    These db are needed in case of server crash to restore the crashed "perfect server".
    I try to find some codes to do that. I found out 2 :
    -> https://www.howtoforge.com/community/threads/tutorial-full-back-up-of-ispconfig3-data-files.73293/ for centos 7 !!
    -> https://www.howtoforge.de/anleitung/backup-des-ispconfig3-mit-mails-datenbanken-und-webinhalt/
    My first question :
    - Are there others covering all databases ?
    - Do you plan to give inside ispconfig that backup capability : I see it very critical item... ?
    Many thanks
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    ISPConfig setups don't use a mysql database named opendmarc.

    Doing a backup of all databases:

    Code:
    mysqldump --defaults-file=/etc/mysql/debian.cnf -cCeQ --hex-blob --quote-names --routines --events --triggers --all-databases -r all_databases.sql
    The file is /etc/mysql/debian.cnf contains the login details like user and password to not having to provide them on the shell.

    You can use any Linux backup software to back up an ISPConfig server (e.g. duplicity or even tar or rsync), there is nothing ISPConfig specific in this task. Nontheless, there is even an ISPConfig specific backup script that you can use:

    https://www.howtoforge.com/community/threads/ispconfig-3-back-res-a-backup-and-restore-script.41609/

    So there is no need to reinvent the wheel by programming another Linux backup software.
     
  3. francoisPE

    francoisPE Member HowtoForge Supporter

    Thanks a lot for your answer. I look at your link : very helpful :)
    Sorry for my english, "critical" was badly chosen. "Major" would be better.
    I do not propose to create something existing. Mariabackup is very good for dumping mariadb providing incremental backup.
    I fell it would make sense to have a web interface management of backup not only website, but, also mails, and, system (dbispconfig) I imagine a tab like for website, in mail and system that offer backup management. That's all.
     
  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  5. nhybgtvfr

    nhybgtvfr Well-Known Member HowtoForge Supporter

    for every system, i backup all of /usr/local, and /etc
    /var/www, and /var/vmail are done separately.
    and like @Taleman i use automysqlbackup, and keep daily backups for the last week, weekly backups for the last month, and monthly backups for the last year.

    mariabackup looks interesting though, hadn't heard of that before, (guess i should pay more attention to the release notes, or check the manuals more often). might have to look at that as an option (which clients can pay more for ;)) to provide hourly incremental backups throughout the day.
     
  6. francoisPE

    francoisPE Member HowtoForge Supporter

    Thanks a lot fr sharing solutions :)
     

Share This Page