Trying to re-create dbispconfig database

Discussion in 'Installation/Configuration' started by Jern, Mar 19, 2019.

Tags:
  1. Jern

    Jern New Member

    Hi, following a hack in which all our databases were deleted, we have been able to restore all the client site databases from fresh backups, but I haven't been able to restore the dbispconfig database. I have a backup of dbispconfig, but it only contains data - no structure information. The update.php can't run because there's no dbispconfig, and install.php won't run because it thinks there's already an installation. I think if I could somehow recreate a virgin dbispconfig database, I could then import the content into it. Any suggestions for what to do? Thanks.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    import the install/sql/ispconfig3.sql file from ispconfig tar.gz, then delete all data but not the structure with phpmyadmin (truncate) and then import the actual data from your backup.
     
  3. Jern

    Jern New Member

    That's done it. A couple of failed attempts, then I realised I that foreign key checks needed to be enabled. Thank you!
     

Share This Page