Hey guys, This morning my customer was doing some stuff on his dolibarr dashboard and suddenly, the database completely disappeared ... The phpmyadmin is empty. I checked the mysql logs and nothing appear there. This database is completely remove from earth in a second without any information ... Do you have any ideas about where I should look to find what happened ? thank you a lot
Is the database still listed in ISPConfig in the database list? Did you check the datalog viewer in ISPConfig in the monitor module if any actions for this database are logged there?
Yes I see the database, it's une the phpmyadmin where the database disappear ... Yes I looked but nothing strange !
In this case, the database must have been lost to an error in MySQL/MariaDB or has been accidentally deleted outside of ISPConfig.
ok so I've been in SSH in /var/lib/mysql I have 2 on my 3 databases ... The empty one on phpmyadmin is not in the file system but appears in the ISPCONFIG dashboard what the hell happened here!
I mentioned it above already, if the database is still in ISPConfig and you don't have a delete action in ISPConfig datalog for this database, then the database must have been removed outside of ispconfig. This can be inside phpmyadmin or trough the mysql command line or something similar.
Yeah, I saw your message, I looked inside MySQL and didn't found anything ... Today another database disappeared, I'm doing a restore backup. But they are two totally distinct databases that's strange. I will take a look at PHPMyAdmin to see if I see something but I don't really know what to look for ...
You should also consider changing MySQL root password. When you change it, set the new password also in /usr/local/ispconfig/server/lib/mysql_clientdb.conf, otherwise iSPConfig won't be able to add new databases anymore.
From within ISPConfig? I think there is no way to see that at the moment, you might be able to see it on the shell with top or ps as the mysql dump is loaded back into mysql using mysql command, so when that process is not visible anymore, then it's finished.
The backups are in /var/backup folder, you should find the mysql dump there, import it manually by using mysql command or phpmyadmin.
Yeah I downloaded the backup file (web1_2020-03-02_00-06.tar.gz) but I don't have any sql file inside !
Ok so I have a problem with database backups, I really hope I didn't lost everything ... I followed the tutorial on the this website I don't understand why something's wring
Is the mysql root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf correct? Don't you run full server backups regularly beside the ispconfig web backups?