moving ispconfig and databases

[aqua]

Hello:

Sorry for double posting but I wasn't getting any answers at the bottom of the original.

So anyway, I am moving my ispconfig installation to a proper host. I got to moving the databases part. I used:

mysqldump -h localhost -u root -psecret -c --add-drop-table --add-locks --all --quick --lock-tables --all-databases > sqldump.sql

and then restored using:

mysql -u root -psecret < backup.sql


Regarding the mysql database: have a look at the users and db table and add the user /db lines that don't exist on the new server but on the old server.

But I am not sure what it means.

So why would I need to add lines to the new server that are in the old server?

So far, I cannot access any of my databases.

Any help is appreciated.

Aqua

[till]

So why would I need to add lines to the new server that are in the old server?

These lines contain the usernames and passwords to access the databases, if you do not copy them to the new server, you will not be able to access the databases.

[aqua]

That makes sense. Which tables is it? I see two tables with users in them, isp_isp_user and sys_user.

[till]

This is not in the ISPConfig database, the data is stored in the database with the name "mysql". The tables are named db and users.