Hello, I'm trying to setup a second server next to my existing one on Debian 6 with ISPConfig 3. When configurating the second server with ISPConfig, I constantly get the error: 'ERROR: Unable to load SQL-Dump into database table.' This occurs when I enter my master server information: Code: Shall this server join an existing ISPConfig multiserver setup (y,n) [n]: y MySQL master server hostname []: <hostname> MySQL master server port []: 3306 MySQL master server root username [root]: MySQL master server root password []: <password> MySQL master server database name [dbispconfig]: ERROR: Unable to load SQL-Dump into database table. I tried it several times and tried removing the database + user from the server, but I keep getting the same error. What might be the solution? Kind regards
Is there a way I can check that? I'm running ISPConfig 3.0.5.4p5 on my other server. I want to get the cluster working before update the OS and ISPConfig. When I look at the logs, i see this: Code: [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 254: WARNING: could not read in ispconfig3.sql But when I log into ISPConfig on my master server, I can see my slave server already there! Does this mean that it worked..?
Create an empty database on your server e.g. with phpmyadmin and then try to import the install/sql/ispconfig3.sql file from the ispconfig tar.gz into this empty database.
No, what you see there is another part of the install which worked, but the main database install on the new system failed. you will have to remove this record in the dbispconfig db, table "server" with phpmyadmin to clean it up.
When I do so, I get the following error: Code: ERROR: Stopped: Database already contains some tables.
Create a new empty database on the server where you want to install ispconfig and then try to load the ispconfig3.sql file into that table to find out why it fails. I'm not talking about running the install script again, please just do what I suggested to get the error message. The error you posted in #7 means that you tried to load the sql dump into a database that contains tables already and not a empty new database like I suggested.