Community Forums Today's Posts     Member List     Archive    
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Location
    Texas
    Posts
    10

    SQLite To MySQL Migration Issue

    I have successfully imported our SQLite DB into MySQL. The server starts properly, but none of the virtual servers start..

    Code:
    2012-02-12 17:59:03.065000|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.1 (2011-11-17 07:34:30)
    2012-02-12 17:59:03.065000|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
    2012-02-12 17:59:03.065000|INFO    |DatabaseQuery |   | dbPlugin version: 1
    2012-02-12 17:59:03.236875|INFO    |Accounting    |   | Licensing Information
    2012-02-12 17:59:03.236875|INFO    |Accounting    |   | licensed to       : xxxx
    2012-02-12 17:59:03.236875|INFO    |Accounting    |   | type              : xxxx
    2012-02-12 17:59:03.236875|INFO    |Accounting    |   | starting date     : Thu Jan 12 00:00:00 2012
    2012-02-12 17:59:03.236875|INFO    |Accounting    |   | ending date       : Tue Jan 15 00:00:00 2013
    2012-02-12 17:59:03.236875|INFO    |Accounting    |   | max virtualservers: 2500
    2012-02-12 17:59:03.236875|INFO    |Accounting    |   | max slots         : 25000
    2012-02-12 17:59:03.299375|INFO    |FileManager   |   | listening on x.x.x.x:30033
    2012-02-12 17:59:03.315000|INFO    |Query         |   | listening on x.x.x.x:10011
    There are 8 virtual servers on this (they show in the servers table), but they are not starting. When I connect to the server, it lists 0 virtual servers...

    Any ideas?

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

    Do you check the server and server_properties tables in your database ?
    Do you check if there is no inconsistencies after the transfer ?

  3. #3
    Join Date
    Oct 2010
    Location
    Texas
    Posts
    10
    Yes. I finally got it to start, then it deleted nearly every channel for every server. Stating that channels were "invalid". All the queries executed without issues, no query was returned as an error in PHPmyAdmin, not sure what is up...

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 08-09-2011, 13:36
  2. Migration SQLite -> MySQL5
    By theWeird in forum [TeamSpeak 2] Server Support
    Replies: 2
    Last Post: 29-12-2008, 17:47
  3. 0x0005 : Operation not permitted | After MySQL migration
    By mitoskalandiel in forum [TeamSpeak 2] Server Support
    Replies: 3
    Last Post: 27-01-2007, 20:49
  4. Migration auf eine MySQL-Datenbank
    By cfreak200 in forum [TeamSpeak 2] Server Support
    Replies: 2
    Last Post: 03-04-2006, 19:47
  5. MySQL -> SQLite
    By Weble in forum [TeamSpeak 2] Server Support
    Replies: 2
    Last Post: 17-01-2006, 13:31

Posting Permissions

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