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.
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.
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.
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.
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?
If ISPConfig fails to do what it is supposed to do, follow the debugging instructions in https://www.howtoforge.com/community/threads/please-read-before-posting.58408/ The last part is about failing to write changes to disk, I think that applies here. Arrange the backup to be tried between commenting out the cron jobs and running manually /usr/local/ispconfig/server/server.sh
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
/var/backup/web0 doesn't exist. In the ispconfig DB the missing DB is assigned to an existing site and the backup is enabled.
@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.
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.
Have you checked that site 7 database does belong to an existing website? Compare the ID's to make sure.
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.
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.