no MySql backup

Discussion in 'ISPConfig 3 Priority Support' started by aldo, Jul 6, 2018.

  1. aldo

    aldo Member HowtoForge Supporter

    I notice now that MySql backups are not present for a web site; only website files backups are available.
    The DB "Site" field is set to the correct website that was renamed weeks ago.
    Have I a chance to recover yesterday DB?
    How can I enable DB backup for this website?
    Thanks.
     
    Last edited: Jul 6, 2018
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    You did not write what operating system you are using, so I do not know if this is available for you. I use automysqlbackup, it makes daily, weekly and monthly backup for your MySQL database and also MariaDB.
    If you do not already have a backup for yesterdays database, then you can not create it now, and can not recover the database as it was yesterday.
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    Is this a single or multiserver system?

    You can check if there is a DB backup in /var/backup for that site. If not, then there is no yesterdays backup.

    In regard to the problem that no backups are created: Check if the zip command is installed on your server and that the MySQL root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf is correct.
     
  4. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    If this is a single-server: you may find the backups in /var/backup/web0
    If this is a multiserver: check the ispconfig-database on the server that shall the backups and make sure, that the backups are enabled for the database on this server.
     
  5. aldo

    aldo Member HowtoForge Supporter

    Thank you all and sorry for my late.
    Server is standalone Debian 7.
    In /var/backup/web[x] there are DB backups for all other sites except this one.
    Since the other sites on this server have their own DB backup I think that zip command is installed; MySQL root password is correct.
    What else can I do to understand the problem or start the backup?
     
  6. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    aldo likes this.
  7. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    Did you check /var/backup/web0 for the missing dump? You can open the dbispconfig witj phpmyadmin and make sure, that the "missing" database is assigned to an exitsing website (id), and has backups enabled
     
  8. aldo

    aldo Member HowtoForge Supporter

    /var/backup/web0 doesn't exist.
    In the ispconfig DB the missing DB is assigned to an existing site and the backup is enabled.
     
  9. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    @florian030 adviced to check directly in the dbispconfig database if that database that does not have backups is set up properly. Use for example PHPMyAdmin to look inside that dbispconfig database.
     
  10. aldo

    aldo Member HowtoForge Supporter

    Already checked also ispconfig db.

    in web_database:
    backup_interval = daily
    backup_copies = 10
    active = y

    The only differences with working sites I noticed is the database_quota that was 0 instead of NULL as present in other DBs, yesterday I changed it in 1000MB but today still no backup for this site.
    in web_domain table:
    backup_excludes is not null, but it should affect website files which backup works.

    /usr/local/ispconfig/server/server.sh show:
    08.07.2018-12:51 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
    08.07.2018-12:51 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    finished.


    In /var/log/ispconfig/cron.log I see:

    Sun Jul 8 12:55:01 CEST 2018 c1_site1 does not exceed quota qize: 0 > 10829824
    Sun Jul 8 12:55:01 CEST 2018 c1_site2 does not exceed quota qize: 0 > 1949696
    Sun Jul 8 12:55:01 CEST 2018 c1_site3 does not exceed quota qize: 0 > 11424799
    Sun Jul 8 12:55:02 CEST 2018 c1_site4 does not exceed quota qize: 0 > 17970645
    Sun Jul 8 12:55:02 CEST 2018 c1_site5 does not exceed quota qize: 0 > 104938862
    Sun Jul 8 12:55:02 CEST 2018 c1_site6 does not exceed quota qize: 0 > 41203346
    Sun Jul 8 12:55:02 CEST 2018 c1_site7_the_one_that_do_not_backup_DB does not exceed quota qize: 1048576000 > 825860112
    Sun Jul 8 12:55:03 CEST 2018 c1_site8 does not exceed quota qize: 0 > 10753638400
    Sun Jul 8 12:55:03 CEST 2018 c1_site9 does not exceed quota qize: 0 > 343501025
    Sun Jul 8 12:55:04 CEST 2018 c1_site10 does not exceed quota qize: 0 > 26247168
    Sun Jul 8 12:55:04 CEST 2018 c1_site11 does not exceed quota qize: 0 > 1377923
    Sun Jul 8 12:55:04 CEST 2018 c1_site12 does not exceed quota qize: 0 > 9420800
    Sun Jul 8 12:55:04 CEST 2018 c1_site13 does not exceed quota qize: 0 > 30036696
    Sun Jul 8 12:55:04 CEST 2018 c1_site14 does not exceed quota qize: 0 > 6258688
    Sun Jul 8 12:55:04 CEST 2018 c1_site15 does not exceed quota qize: 524288000 > 999424
    Sun Jul 8 12:55:04 CEST 2018 c1_site16 does not exceed quota qize: 0 > 4336852
    Sun Jul 8 12:55:04 CEST 2018 c1_site17 does not exceed quota qize: 0 > 7847936
    Sun Jul 8 12:55:04 CEST 2018 /usr/bin/fail2ban-client
    Sun Jul 8 12:55:04 CEST 2018 /sbin/iptables
    Sun Jul 8 12:55:04 CEST 2018 /sbin/ip6tables
    Sun Jul 8 12:55:04 CEST 2018 /sbin/mpt-status
    Sun Jul 8 12:55:04 CEST 2018 libkmod: ERROR ../libkmod/libkmod.c:554 kmod_search_moddep: could not open moddep file '/lib/modules/3.8.13-xxxx-grs-ipv6-64-vps/modules.dep.bin'
    Sun Jul 8 12:55:04 CEST 2018 Failed to load mptctl
    Sun Jul 8 12:55:04 CEST 2018 /sbin/tw_cli
    Sun Jul 8 12:57:01 CEST 2018
    Sun Jul 8 12:57:01 CEST 2018
    Sun Jul 8 12:57:01 CEST 2018 finished.
    Sun Jul 8 12:58:01 CEST 2018
    Sun Jul 8 12:58:01 CEST 2018
    Sun Jul 8 12:58:01 CEST 2018 finished.
     
  11. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Have you checked that site 7 database does belong to an existing website? Compare the ID's to make sure.
     
  12. aldo

    aldo Member HowtoForge Supporter

    Yes,
    web_database.parent_domain_id = web_domain.domain_id
     
  13. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    you can try
    php cron_debug.php --cronjob=500-backup.inc.php
    in /usr/local/ispconfig/server
     
    aldo likes this.
  14. aldo

    aldo Member HowtoForge Supporter

    Tnx!!!

    Code:
    tar: ./dev/log: socket ignored
    tar: ./dev/log: socket ignored
    mysqldump: Couldn't execute 'show create table `v_tg_check`': View 'c1_not_backed_up_db.v_tg_check' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
    finished.
     
    till likes this.
  15. aldo

    aldo Member HowtoForge Supporter

    I confirm that after removing bad view DB backup is created.
    Thanks all for your help.
    Code:
    tar: ./dev/log: socket ignored
    tar: ./dev/log: socket ignored
    finished.
     

Share This Page