notoriouspyro / sqlite-to-mariadb-mysql-perl-script Goto Github PK

root@ubuntu:/home/ts3/teamspeak3-server_linux_amd64# ./sqlite-to-mariadb.pl export.sqlite > export.mariadb
./sqlite-to-mariadb.pl: line 7: syntax error near unexpected token newline' ./sqlite-to-mariadb.pl: line 7: '

The blog that you link to in the read is no longer functioning. I get a HTTP 522 from Cloudflare

Hello, Dear Creator!

Here is ATHP Company we would like thank you for that script, but you need update the script due some records in structures needs to be changed because of errors in later, when instance is active and crash in some cases.

First description of channels have to be changed from value ( varchar ) of 255 to 8192
corrections:
CREATE TABLE channel_properties ( server_id integer unsigned, id integer unsigned, ident varchar(100) NOT NULL, value varchar(8192));

The Table " client " need changes in structure:
client_month_upload BIGINT = 20
client_month_download BIGINT = 20
client_total_upload BIGINT = 20
client_total_download BIGINT = 20

The Table " servers " need changes in structure:
server_month_upload BIGINT = 20
server_month_download BIGINT = 20
server_total_upload BIGINT = 20
server_total_download BIGINT = 20

You can see all structures how it looks like when you start from the scratch MariaDB of Teamspeak 3, thank you.

Best Regards
CEO Mateusz Gladosz
TS3Bahu LTD