upgrading to debian 11

Discussion in 'General' started by n30, Sep 10, 2021.

  1. n30

    n30 New Member

    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?
  2. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    The password is set by the installer. Are you sure mariadb got uninstalled? Did you rerun the installer and reconfigure services after upgrading?
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
  4. n30

    n30 New Member

    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.
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    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
  6. n30

    n30 New Member

    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 ..
    ahrasis and till like this.

Share This Page