Database not migrated after upgrade (2.2.9->2.2.10)

Discussion in 'Installation/Configuration' started by okhayat, Mar 3, 2007.

  1. okhayat

    okhayat New Member

    After successfully upgrading my installation, I couldn't login to my control panel. I check the mysql server and I noticed that the db_ispconfig database is empty.
    When inspecting the logs, I found the following:
    Thu Mar 1 01:04:03 IRST 2007 - [ISPConfig] - /root/install_ispconfig/install.php, Line 795: WARNING: could not read in db_ispconfig.sql
    Thu Mar 1 01:04:04 IRST 2007 - [ISPConfig] - /root/install_ispconfig/install.php, Line 802: imported existing_db.sql
    I tried to restore the database manually from the mysql dump and I got an error:
    cpanel:~/install_ispconfig# mysql -p db_ispconfig < db_ispconfig.sql
    Enter password:
    cpanel:~/install_ispconfig# mysql -p db_ispconfig < /tmp/existing_db_02_27_2007__17_20_04.sql
    Enter password:
    ERROR 1062 at line 164: Duplicate entry '3' for key 1
    Part of the line that has the error is:
    INSERT INTO `doctype` (`doctype_id`, `userid`, `groupid`, `doctype_modul`, `doctype_name`, `doctype_title`, `doctype_def`, `doctype_tree`) VALUES (3,1,1,'sys','news','News','O:3:\"doc\":28:{s:6:\"userid\";s:1:\"1\";s:7:\"groupid\";s:1:\"1\";s:14:\"group_required\";s:1:\"0\";s:5:\"modul\";s:3:\"sys\"
    What's wrong?
  2. till

    till Super Moderator

    If you want to import the database dump, you must empty (but dont delete!) the tables in db_ispconfig before the import.
  3. okhayat

    okhayat New Member

    Is there any way to empty all table at once?

    Also, is this normal? I mean, shouldn't it import the data again once the software is upgraded?

  4. till

    till Super Moderator

    If you have phpmyadmin installed, select all tables and then chose empty.

    That's not normal. I dont know why it has not imported your data. I'am doing ISPConfig installations and updates almost every day but it did not happen to me yet.

Share This Page