Forum

Results 1 to 8 of 8
  1. #1
    Join Date
    September 2011
    Posts
    4

    Solved Migrating TS3 + MySQL to another Server

    Hi,

    i was migrating my TS3 Server with MySQL to a new one. Everything works fine. I have some custom groups, but not all users are at the new one in specified groups. I have group called TLO at the source there are about 40 users at the new server 7.

    I exported the mysql db on the old machine and imported it at the new one. Some users have the old permissions, but not all.

    Where can i find the table for the Server Group assignement?

  2. #2
    Join Date
    May 2010
    Posts
    6,310
    Hello

    What tool did you used to transfer your MySQL database from the old to the new server ?

  3. #3
    Join Date
    September 2011
    Posts
    4
    Hi,

    phpmyadmin for export and import on both machines.

  4. #4
    Join Date
    May 2010
    Posts
    6,310
    I don't really use this tool (I prefer HeidiSQL) but I remember that phpmyadmin has a request line limit.

    Try to tranfer your database table by table. And for big table, part by part.
    If you can try with HeidiSQL.

  5. #5
    Join Date
    September 2011
    Posts
    4
    I tried Table by Table and Part by Part. No chance...

    What table is for Server Group Assignment?

  6. #6
    Join Date
    May 2010
    Posts
    6,310
    And strangly you get no error or informative message from phpmyadmin ?

    Quote Originally Posted by Ageres
    What table is for Server Group Assignment?
    server_group_to_client

    Before another transfer, make a backup in a sql file and open it to control if there is all lines.

    And again I recommend you to use HeidiSQL.

  7. #7
    Join Date
    September 2011
    Posts
    4
    No. Phpmyadmin shows no error. It says "All done".

    Is it possible that we communicate over Skype?

    HeidiSQL doesn't work for me.

  8. #8
    Join Date
    May 2010
    Posts
    6,310
    I send you a private message.

    Edit
    It was not a transfer problem. The database from the new system has the same info from the old.
    Last edited by florian_fr40; September 9th, 2011 at 09:38 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Migrating default installation to MySQL
    By Grim in forum Windows
    Replies: 2
    Last Post: June 30th, 2012, 05:09 PM
  2. Migrating Virtual Server
    By rindorbrot in forum Server Support
    Replies: 3
    Last Post: December 19th, 2010, 05:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •