For a single website, I would just create the site and db on the new server and then copy over the db and site data. The back-res script will copy over a whole server, so it will destroy other existing sites if you use that.
Till, the only problem still left (see my other posts) is, that this did not copy db users and passwords.
As far as I understood the first poster, he is moving just one website and db and not a whole server and my suggestion was to recreate the website and db and then move its content. So copying db users and passwords is not nescessary here as we do not move a full server. Btw. Moving db users is quite easy, I simply export them based on the prefix when I move a server with phpmyadmin and import it on the new system, similar to copying the shell users.
yes it is simple, but my question was different. can you please check my post? and if he didnt know that db-users-pass, he had to do it manually as you described (copy mysql-user-db with mysql-user and database-access-settings)
I've read you post and I've posted the answer how to move mysql users when you move a server in #6 of this thread. The resync function is a function to update existing records and configuration files on a server. If the mysql users dont exist because you missed to move them to the new server, they cant be updated. He knows that password as it is saved in the config file of the script that is instaled in that website.
so resync-option (Database [ ]) is for doing what? if i imported db-users in mysql, they didnt get access for their database. I thought resync will do this (setting data-base users to existing(!) database as I can edit in ispconfig web --> databases and database-users. Sorry for that many questions, but i would like do understand how that thing work. i know i can import all mysql-dbs, import master.sql, remove debian-sys-user and change dbispconfig user pass, but i think i can do this quicker my using that resync option. By the way: in german translation of tools --> resync there is "Resync ausgewählte Dienste auf entfernten Server." in english its only Resync..
They do get access to their database when you import them correctly. A mysql user consist of records in several tables. You have to import the records from mysql. User and mysql.Db table. Thanks for the info. I will forward thai to the maintainer of the german translation.
yes. sorry. i only export/import mysql-users. so their db access setting where not imported. Thank you again!
No biting (or gouging of the eyes) please I'm simply wondering how to best implement a live-site/test-site project on ISPconfig3 cluster. And also how to quickly "move" trouble sites to a different node.
