Hello, 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?
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.
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: https://www.ispconfig.org/get-support/?type=ispconfig
