Hi My mariadb was hacked and dbispconfig has been wiped. Now, there are only two users so: I could recreate - would that just be a reinstall of ispconfig 3 and adding my two users? I could remove Ispconfig altogether as it's more than I need and just revert to using postfix standalone - how do I do that? I upgraded ISPconfig3 on Monday - could I restore from that backup? Does it backup the database? Any help appreciated. Thank you
Yes. If you have chosen to back up the system during update, then the database is included in the backup. You find the backups in /var/backup/ The database backup is a SQL dump. I'm not sure if it contains only the data or also the table definitions. if table definitions are not in the SQL dump, then use the file install/sql/ispconfig3.sql which you find in the ISPConfig tar.gz file to populate the database, then truncate all tables and finally import the SQL dump from the backup.
Yep - followed to the letter - I ran the ispconfig3.sql, truncated all the tables and then ran the backup script. Any table starting cache, doesn't exist - I commented out any reference to them in the backup file and everything else loaded sweetly. A quick look through the tables and it all seems ok. I can login to mail. Postfix however, is logging "Temporary lookup failure" when receiving mail
ISPConfig does not has any table with that name, see ispconfig3.sql file. So you likely created a table with that name manually in the ispconfig database or you used the ispconfig database for other software besides ISPConfig.
Anyway, all seems well, thank you for your help, I'm back up and running - couldn't find any "cache*" tables in the ispconfig3.sql file. Odd that they were in the backup file.
Use automysqlbackup to get backups of all databases daily, and weekly and monthly backups stored for a longer time. It is probably available from you linux distribution repository.
