Done: how to rebuilt dbispconfig (very painfully)

Discussion in 'Installation/Configuration' started by korbynn, Jan 18, 2017.

  1. korbynn

    korbynn Member

    CentOS 7 running the last version of ispconfig.
    Server went down.
    Server is up now.
    dbispconfig database is missing.
    I have updated ispconfig on a regular basis.
    Where are the backups saved to restore a version of the dbispconfig data?
    httpd is serving with mariadb.
    Cannot access the email or any file transfer.
    I can get into ssh.
    Any suggesstions please!
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    /var/backup/
     
  3. korbynn

    korbynn Member

    what is the structure of dbispconfig database.
    It appears the backup did not save the db structure.
    I cannot seem to find the ispconfig db version. All that I have found is 3.0.5.4p9.

    I am going try this.
    Downloaded the version for 3.0.5.4p9.
    Found the database sql file.
    I will use this file to setup the database.
    I will then grab the backup sql file and insert the data as is.
    I am hoping that the data will map properly.
     
    Last edited: Jan 19, 2017
  4. korbynn

    korbynn Member

    Completed transfer of data from an older version to 3.0.5.4p9.
    The backup file could not be used directly. Too many errors occurred so just inserted each table individually.
    Started the control panel. Seemed to work.
    All of the email, file transfer, lists are now working.
    Updated to the latest version of ISPConfig. Used the defaults, The normal update service error messages and issues.
    It appears to work now.
     
  5. korbynn

    korbynn Member

    Now I have the amavisd and spam-assassin issue.
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

Share This Page