Hello. My server is end. I installed new server, and ISPConfig. I want restore ISPconfig config files, and sql backup. I try restore with phpmyadmin and cli (mysql -p dbispconfig < ispconfig_db_backup.sql), but geterror message: ERROR 1062 (23000) at line 50: Duplicate entry '1' for key 'PRIMARY'. How can restore ispconfig databases?
Drop the dbispconfig database and then import the SQL file to a newly created dbispconfig that's empty. It will almost surely be partly broken though.
Thx, but that is not good, because we also need empty tables, so an empty database is not enough. I just had to use the TRUNCATE command on all the tables and it was ready to be imported.