How to restore dbispconfig database droped by error whith backup ?

Discussion in 'General' started by nif, Aug 3, 2019.

  1. nif

    nif New Member

    Hello,
    I droped my ISPconfig dbispconfig db by error.... But I have dbispconfig save from 2018-02 inside /var/backup update folder :
    /var/backup/ispconfig_xxxxxxxxxxx_2018-02-17_11-21/ispconfig_db_backup.sql

    How to restore it ? because this backup dont have create TABLE. So when I run the script it crach at first "LOCK TABLES `aps_instances` WRITE; insert..."

    Thanks for help
    ISPconfig 3.1
     
    Last edited: Aug 4, 2019
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Import install/sql/ispconfig3.sql file from ispconfig tar.gz, use the same version that your server had installed. Then empty all tables but keep the structure and then import the backup.
     
  3. nif

    nif New Member

    Thanks you thats work great ! :)
     

Share This Page