How restore ispconfig_db_backup

Discussion in 'Server Operation' started by RedWolf83, Apr 27, 2015.

  1. RedWolf83

    RedWolf83 New Member

    Hello all, I know this is a noob question but, in fact this is my first personal server.:oops:
    I've tried to restore a ispconfig_db_backup using the method https://www.howtoforge.com/faq/6_4_en.html:
    Code:
    mysql -h localhost -u root -p dbispconfig < '/root/ispconfig_db_backup_2015-04-26_20-46.sql'
    But I've returned the error:
    Code:
    ERROR 1062 (23000) at line 51: Duplicate entry '1' for key 'PRIMARY'
    This mean already exist something so it not rewrite on it, right?

    Then i Tried to Drop the "dbispconfig" Database but when I retry with the command, it doesn't found the tables... :mad:

    I've had some problem upgrading from wheezy to jessie Debian, so I reinstall all servers needed, re-following the "Perfect Server Guide" and deleting only the "dbispconfig" database and the /user/local/ispconfig folder. So infos of the websites should be still there. I have made a backup before reinstalling by command "php -q update.php".

    Hope some kind soul can help me!
    Thanks for Your Attention, Have a Nice Day.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Try:

    mysql --force -h localhost -u root -p dbispconfig < '/root/ispconfig_db_backup_2015-04-26_20-46.sql'
     

Share This Page