Problems Moving an ISPConfig installation

Discussion in 'Installation/Configuration' started by tomd, Dec 5, 2006.

  1. tomd

    tomd New Member

    I am trying to move my ISPConfig (2.2.6) installation that is on Ubuntu 6.06 to a Debian 3.1 system. I followed the guide in another forum thread ( ) and it worked pretty well until I came to moving the database.

    Using PHPAdmin I made the SQL file output, but could not get the Debian system to accept the data. I believe the problem was a MySQL 5 (on Ubuntu) versus MySQL 4 (on Debian) problem. I failed with an error pointing to a line of SQL with "collation" in it. I think this is some sort of encoding issue. Once I removed the part of the SQL concerning character encoding the data went into the database fine.

    I thought I was OK until I access the ISPConfig management area. It listed my sites, but when I clicked on one I got a error of "The requested document type does not exist." I found a thread that discussed this problem. ( ) This thread also talked about encoding issues. I could never resolve the problem and my hacking eventually killed the new system. (But I learn)

    My question is this: In setting up the new Debian 3.1 system, should I installed MySQL 5 before installing ISPConfig - or is there other approach I should take?
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes, please setup a mysql5 database on debian from dotdb or backports. The error you get is caused by the diferences in the database dumps between mysql 4 and 5.
  3. lunardi

    lunardi New Member

    Problem to transfer domains/users/database ISPconfig

    Hy Tomd,

    I have same problem !!! Look message to send "support ispconfig":

    My name is Marco.
    I'm brazilian and sorry my BAD english.
    Congratulations for good work of ISPConfig !!!

    I need help for ISPConfig.

    I have:

    (Machine 1) - An machine with Ubuntu 6.06 and ISPConfig 2.2.7 running perfect. Hosting
    10 domains and 500 users mails (including the messages).

    (Machine 2) - New machine with Ubuntu 6.10 and ISPConfig 2.2.8.

    Now, my question:
    What transfer all "domains and mails" from Machine 1 for Machine 2 ?


    you to solve your problem ?

  4. tomd

    tomd New Member

    I had not heard of these, but this is a good source. has clearer instructions than so I will try this.

    To confirm, I add the info to the apt sources.list

    Then make (or modify) the preferences file with:

    Package: mysql-server
    Pin: release a=sarge-backports
    Pin-Priority: 999

    Package: mysql-client
    Pin: release a=sarge-backports
    Pin-Priority: 999

    Package: libmysqlclient12-dev
    Pin: release a=sarge-backports
    Pin-Priority: 999

    Then carry on with the install as instructed in the perfect sarge setup

  5. lunardi

    lunardi New Member

    Hy Tom,

    I have same problem.
    You to solve your problem ? If yes, help me.
  6. tomd

    tomd New Member

Share This Page