How to restore webiste databases in ISPConfig 2?

Discussion in 'Installation/Configuration' started by onastvar, Oct 27, 2009.

  1. onastvar

    onastvar Member

    I had databases for some of my web sites (joomla, wordpress, etc) under Options tab for each web site (web3db1, web4db1 web5db1, etc).

    I rebuilt server (CentOS 5.4 w/ ISPConfig 2 using Perfect Setup instructions) I have copy of entire hard disk from old server.

    I copied all the databases from my hard drive to newly built server in same location /var/lib/mysql/

    I don't see those DBs in ISPConfig 2 under my web sites.

    I didn't create sql dumps of my MySQL databases (with phpMyAdmin or on the command line)

    I would appreciate any suggestions on restoring web site databases so I can see them in ISPConfig? What should I check? Is this even possible if I don't have sql dumps but I have copy of entire hard drive?
  2. falko

    falko Super Moderator ISPConfig Developer

    Does your ISPConfig installation use the old ISPConfig database, or did you create a new ISPConfig database?
  3. onastvar

    onastvar Member

    My ISPConfig installation uses the old ISPConfig database.

    After I setup new ISPConfig, I renamed /var/lib/mysql/ispconfigdb/ to /var/lib/mysql/ispconfigdb2/ then I copied DB from old server /var/lib/mysql/ispconfigdb/ and ISPConfig is using that one.

    Also, If I create a new database I'm getting error (Error establishing a database connection) when installing Wordpress, Joomla etc.
    Last edited: Oct 28, 2009
  4. falko

    falko Super Moderator ISPConfig Developer

    Please check if the MySQL details in /home/admispconfig/ispconfig/lib/ are correct.
  5. onastvar

    onastvar Member


    here are my MySQL details from

    my db password has 4 letters 4 number exclamation mark
    (i.e. abcd1234!)

    FYI > I created new db in one of my web sites and it's showing in ISPConfig

    Database Name: web5db5
    Database User: web5u5

    Other databases for this web site (web5db1, web5db2, web5db3 & web5db4) exist but not showing in ISPConfig under options tab. Anything else I should double check.

      $go_info["server"]["server_url"] = 'http://'.$_SERVER['HTTP_HOST'];
    } else {
      $go_info["server"]["server_url"] = "";
    $go_info["server"]["include_root"] = $go_info["server"]["server_root"] . $go_info["server"]["dir_trenner"] ."lib";
    $go_info["server"]["classes_root"] = $go_info["server"]["include_root"] . $go_info["server"]["dir_trenner"] ."classes";
    $go_info["server"]["temp_dir"] = $go_info["server"]["server_root"] . $go_info["server"]["dir_trenner"] ."temp";
    $go_info["server"]["files_dir"] = $go_info["server"]["server_root"] . $go_info["server"]["dir_trenner"] ."files";
    $go_info["server"]["backup_dir"] = $go_info["server"]["server_root"] . $go_info["server"]["dir_trenner"] ."backup";
    $go_info["server"]["version"] = "2.2.33";
    $go_info["server"]["os"] = "linux";
    $go_info["server"]["ort"] = "local";
    $go_info["server"]["banner"] = "0";
    $go_info["server"]["db_host"] = "localhost";
    $go_info["server"]["db_name"] = "ispconfigdb";
    $go_info["server"]["db_user"] = "root";
    $go_info["server"]["db_password"] = "[B]mydbpassword[/B]";
    $go_info["server"]["db_type"] = "mysql";
    $go_info["server"]["mail_server"] = "";
    $go_info["server"]["mail_user"] = "";
    $go_info["server"]["mail_password"] = "";
    $go_info["server"]["smtp_server"] = "localhost";
    $go_info["server"]["mode"] = "";
    $go_info["server"]["lang"] = "en";
  6. falko

    falko Super Moderator ISPConfig Developer

    That's strange. Have you tried to repair the ISPConfig database (e.g. from within phpMyAdmin)?
  7. onastvar

    onastvar Member

    repairing ispconfigdb via phpmyadmin didn't help

    however, when i am in phpmyadmin home page i have message on the bottom

    "The additional features for working with linked tables have been deactivated. To find out why click here."

    I wonder if message above has to do with my issue with db not being displayed in ISPConfig.

    When I click on link (click here) I see this.

      Server: localhost
    $cfg['Servers'][$i]['pmadb'] ... 	not OK [ Documentation ]
    $cfg['Servers'][$i]['relation'] ... 	not OK [ Documentation ]
    General relation features: Disabled
    $cfg['Servers'][$i]['table_info'] ... 	not OK [ Documentation ]
    Display Features: Disabled
    $cfg['Servers'][$i]['table_coords'] ... 	not OK [ Documentation ]
    $cfg['Servers'][$i]['pdf_pages'] ... 	not OK [ Documentation ]
    Creation of PDFs: Disabled
    $cfg['Servers'][$i]['column_info'] ... 	not OK [ Documentation ]
    Displaying Column Comments: Disabled
    Bookmarked SQL query: Disabled
    Browser transformation: Disabled
    $cfg['Servers'][$i]['history'] ... 	not OK [ Documentation ]
    SQL history: Disabled
    $cfg['Servers'][$i]['designer_coords'] ... 	not OK [ Documentation ]
    Designer: Disabled
    Any ideas?

    Thanks much!

Share This Page