HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=25)
-   -   Move man... (http://www.howtoforge.com/forums/showthread.php?t=61852)

SamTzu 15th May 2013 18:10

Move man...
 
What is the easiest way to "move" a website/db between 2 ISPconfig3 servers?

rodti 15th May 2013 19:23

I wish I'd known how to do that a week ago...

todx 15th May 2013 20:29

Not sure if this works but here it goes:

http://www.eurosistems.ro/back-res

till 16th May 2013 11:23

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.

beyerservice 16th May 2013 11:57

Till, the only problem still left (see my other posts) is, that this did not copy db users and passwords.

till 16th May 2013 12:14

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.

beyerservice 16th May 2013 12:36

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)

till 16th May 2013 12:50

Quote:

yes it is simple, but my question was different. can you please check my post?
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.

Quote:

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)
He knows that password as it is saved in the config file of the script that is instaled in that website.

beyerservice 16th May 2013 13:07

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..

till 16th May 2013 13:21

Quote:

if i imported db-users in mysql, they didnt get access for their database.
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.

Quote:

By the way: in german translation of tools --> resync there is "Resync ausgewählte Dienste auf entfernten Server." in english its only Resync..
Thanks for the info. I will forward thai to the maintainer of the german translation.


All times are GMT +2. The time now is 01:54.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.