Hi, i just upgraded my box from debian 10 to debian 11. the most seems to work as it should, except that it seems that after upgrade it removed mysql ... so now all databases is gone... how do i repair this the easiest way? where do i find the ispconfig password and login to dbi database? i have backups of all databases that i had, and i guess i need to install mariadb instead?
The password is set by the installer. Are you sure mariadb got uninstalled? Did you rerun the installer and reconfigure services after upgrading?
That's unlikely, even if apt would remove MariaDB or MySQL, then the databases won't get purged (unless you explicitly instructed apt with --purge option to do so). Install MariaDB/MySQL (take care to install the right software, same you used before) again with apt if it's missing, the databases should be back and working automatically again then.
i did have mysql installed before i upgraded to debian 11.. and yes it was removed and yes i used purge autoremove so it was there it was removed.
Ok, if you purged your databases and the folder /var/lib/mysql does not exist anymore or is empty, then you lost all databases indeed. You can find the ISPconfig MySQL user details in /usr/local/ispconfig/server/lib/config.inc.php and the original MySQL root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf
hi, nah /var/lib/mysql was still there and i succeded to reinstall mariadb without loose anything... i was looking in wrong place before.. so now is everything working again ..
