Move man...

Discussion in 'General' started by SamTzu, May 15, 2013.

  1. SamTzu

    SamTzu Member HowtoForge Supporter

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

    rodti New Member HowtoForge Supporter

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

    todx New Member

  4. till

    till Super Moderator Staff Member ISPConfig Developer

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

    beyerservice Member HowtoForge Supporter

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

    till Super Moderator Staff Member ISPConfig Developer

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

    beyerservice Member HowtoForge Supporter

    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)
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

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

    beyerservice Member HowtoForge Supporter

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

    till Super Moderator Staff Member ISPConfig Developer

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

    beyerservice Member HowtoForge Supporter

    yes. sorry. i only export/import mysql-users. so their db access setting where not imported.
    Thank you again!
     
  12. SamTzu

    SamTzu Member HowtoForge Supporter

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

    SamTzu Member HowtoForge Supporter

    My "yearly" bump. Any news?
     

Share This Page