Can not upload ispconfig database

Discussion in 'Installation/Configuration' started by pecka33, Sep 24, 2023.

  1. pecka33

    pecka33 Member


    i need to restory my dbispconfig database from backup. I remove completely this db via command - i can not get to phpmyadmin. After that i tried to upload my dbispconfig sql file. When i use command i get ERROR 1050 (42S01) at line 60: Table '`dbispconfig`.`aps_instances`' already exists
    So I think that i need to have tables of ispconfig in this databse.
    So i download ispconfig latest version and try to import sql file from /install directory to this new database with name dbispconfig. When i run import command i get

    ERROR 1050 (42S01) at line 60: Table '`dbispconfig`.`aps_instances`' already exists
    but this is not possible, i completely remove database and tried to upload this sql file. Any idea please?
  2. pecka33

    pecka33 Member

    So i take latest sql backup of ispconfig panel from var/backups, create new database dbispconfig, use command to import this sql file to new, clera database with name dbispconfig and get error
    ERROR 1146 (42S02) at line 21: Table 'dbispconfig.aps_instances' doesn't exist

    Because this i think that table must be exist, so i download install package of ispconfig panel, take sql file from install folder and tried to import to this new cleare database. I take this sql file and use command to upload. I get error

    ERROR 1050 (42S01) at line 60: Table '`dbispconfig`.`aps_instances`' already exists
    But this is not possible, because in database are not tables, is new created db.
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    This table does not exist anymore in current ISPConfig versions, it has been removed quite some time ago.

    The error you made is that you try to import an old SQL dump into a newer ISPConfig version that uses a newer database structure. You must use the ispconfig3.sql file from the same ispconfig version that the backup was made from, import that file into the database, then empty (truncate) but not delete all tables and finally import the backup file with the data. if you don't know how to do that you might want to contact business support and ask them for a quote to do that for you:

Share This Page