Forum

Results 1 to 3 of 3
  1. #1
    Join Date
    March 2017
    Posts
    1

    TeamSpeak≥ Server MariaDB

    Hey guys,
    wanted to config my teamspeak server with mariadb instead of the local sqlite. I dumped the sqlite database and imported it in my mariadb server. Then I created the ts3server.ini and ts3db_mariadb.ini files. If i try to execute the server now, I'll get a clean one instead of my originial server.
    Any ideas how to fix this?

    ts3server.ini

    machine_id=1
    default_voice_port=9987
    voice_ip=0.0.0.0
    licensepath=
    filetransfer_port=30033
    filetransfer_ip=0.0.0.0
    query_port=10011
    query_ip=0.0.0.0
    query_ip_whitelist=query_ip_whitelist.txt
    query_ip_blacklist=query_ip_blacklist.txt
    dbplugin=ts3db_mariadb
    dbpluginparameter=ts3db_mariadb.ini
    dbsqlpath=sql/
    dbsqlcreatepath=create_mariadb/
    dblogkeepdays=90
    logpath=logs
    logquerycommands=0
    dbclientkeepdays=30

    ts3db_mariadb.ini

    [config]
    host=127.0.0.1
    port=3306
    username=teamspeak
    password=*********
    database=teamspeak

  2. #2
    Join Date
    February 2012
    Location
    Germany
    Posts
    571
    It's not trivial to migrate the database. It's also not supported by Teamspeak staff in any way. If you have trouble with a migrated database, you don't get any support. You will most probably run into problems later, if you do it. There are several details which may invalidate any imported database, for example the character set. If you have names with non-ASCII characters in your database, problems may arise.

    I was able to successfully migrate a small test server, because I was curious, but I would not operate such a server.
    I did this:
    - let the Teamspeak Server create an empty database on the Mysql/Mariadb server. This is to have the mysql-specific database definitions (CREATE TABLE, CREATE INDEX).
    - delete the created default server instance that was created and empty all database tables. Keep the tables themselves.
    - produce a sqlite database dump and remove any data definition statements (CREATE TABLE, CREATE INDEX). Leave only INSERT INTO statements.
    - change the syntax of the dump to be mariadb-compliant
    - import the dump on the mariadb server

    And the server starts and you find all stuff (channels, permissions) from the sqlite database. If it operates well, I cannot say.

    As far as I know the only supported way to migrate a server from one database type to the other is with creating a snapshot on the old server and import it on the new server. YaTQA may help tremendously, because it can export/import channel (sub)trees.

    But usually you don't want to use a mariadb database. This is only useful for huge ATHP hosters. It enables them to move servers between machines freely and to perform centralized backups. For everyone else, it is just overhead and you create a second point of failure.
    Last edited by Schlumpi; March 21st, 2017 at 03:35 PM.

  3. #3
    Join Date
    June 2011
    Location
    Germany
    Posts
    4,335
    Why do you want to waste performance by migrating from SQLite to MariaDB?

    I was once contacted by someone who in hiw mail told me how great MariaDB was, but he couldn't use the client database in YaTQA. Turned out his MariaDB took many seconds for just the first 500 clients. Even my super slow and super small vServer could do that in far below 1 second. Of course, MariaDB can work. But as Schlumpi said, it's a new point of failure.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Start server error using MariaDB
    By alienienigenagamer in forum Server Support
    Replies: 3
    Last Post: November 4th, 2017, 12:36 AM
  2. MariaDB + teamspeak3 server
    By xxxedevtsrt in forum Server Support
    Replies: 5
    Last Post: July 12th, 2016, 07:33 PM
  3. TeamSpeak 3 with MariaDB on CentOS 7
    By LukMa in forum Linux / FreeBSD
    Replies: 1
    Last Post: April 7th, 2016, 08:32 AM
  4. How to Convert Teamspeak from SQLite to MariaDB
    By dannymichel in forum Server Support
    Replies: 2
    Last Post: January 12th, 2016, 04:45 PM
  5. Teamspeak server shutdown randomly (3.0.11.1 MariaDB)
    By xxFankxx in forum Server Support
    Replies: 4
    Last Post: December 12th, 2014, 01:00 AM

Tags for this Thread

Posting Permissions

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