TS3 BDD move Windows to Linux - Linux to Windows

[SoFvip]

Hi,
is there any way to move all configuration of TS3 on windows server to linux server ??
I found in faq that i can export user to other pc but what with all other configs like for example channel list ??
In other words i wanna export all configs.

PS. Sorry for my english.

[Screech]

NOTE: Moving a database from one OS to another should no longer require the following process: See here


Not exactly just coping the database. You would want the files folder also for the avatars and any files uploaded to channels.

You also need to fix the pathing in the db from using windows standard of "\" to the Linux standard of "/". I used the follow script for moving from windows to Linux when I just tested when my database. Other things to check before starting the server is the file permissions, may need to run chmod.

For Windows to Linux

update channel_properties set value = REPLACE(value, "\", "/") where ident = "channel_filepath";
update server_properties set value = REPLACE(value, "\", "/") where ident = "virtualserver_filebase";

For Linux to Windows

update channel_properties set value = REPLACE(value, "/", "\") where ident = "channel_filepath";
update server_properties set value = REPLACE(value, "/", "\") where ident = "virtualserver_filebase";

Please note :
When logged in to SSH needed "\\" in place of "\" makes since when it is processing \ as some break or command character. I was running the commands in a SQLite database browser program in windows and my commands work fine then.


This would be easy to make part of the teamspeak server if the devs wanted to. The database would just need to check/update the platform the server is running on to a record in the instance_properties table, if current platform does not match the last one stored run a few sql commands like above to address the pathing as needed.

[Trouco]

Not exactly just coping the database. You would want the files folder also for the avatars and any files uploaded to channels.

You also need to fix the pathing in the db from using windows standard of "\" to the Linux standard of "/". I used the follow script for moving from windows to Linux when I just tested when my database. Other things to check before starting the server is the file permissions, may need to run chmod.

update channel_properties set value = REPLACE(value, "\", "/") where ident = "channel_filepath";
update server_properties set value = REPLACE(value, "\", "/") where ident = "virtualserver_filebase";

This would be easy to make part of the teamspeak server if the devs wanted to. The database would just need to check/update the platform the server is running on to a record in the instance_properties table, if current platform does not match the last one stored run a few sql commands like above to address the pathing as needed.

Thank you!
This has fixed my problem

[GoldenNeo]

I want to put Ts3 Windows Server in Linux too, can any one show who it's done pls...

[Screech]

The way I run the command is in a database browser that supports running SQL commands.

I updated the database on the windows machine before uploading to the Linux box so I used SQLite Database Browser.

My steps were:

1. Download SQLite Database Browser
2. Stop my server
3. make a backup of the server
4. open the database with SQLite Database Browser
5. run the SQL commands
6. save the changes to the database
7. close SQLite Database Browser
8. upload the server files to the linux box
9. download and install the latest Linux build
10. start the server on linux.

[GoldenNeo]

Thanks it works..

[Blackice504]

hi i think it may have been answered before but i have had a look did not find
i have a current ts3 server for windows i would like to put that on my linux server but keep my database so how would i copy my virtual server and place on the linux server i do have the linux server and windows server running the linux server has only been installed and not touched.

the files that i think the database or vitual server is kept looks different to the linux ones and it does make some sence but to me i should be able to just import them with no problems.

Anythoughts?
Thanks in advanced.

[Blackice504]

thank you so much for your reply. this helps alot.

[Genrabbit]

update channel_properties set value = REPLACE(value, "\", "/") where ident = "channel_filepath";
update server_properties set value = REPLACE(value, "\", "/") where ident = "virtualserver_filebase";

I'm trying to send these from mysql server logged in with ssh, but never seems to work. Its like mysql expert something more.
When I type these lines I get these Picture here(70K png file] and the only way to get out is ctrl+c.

Any idea what I do wrong?
I have mysql 5.5.014 / Centos 5.6x64

[Genrabbit]

Tried this aswell.

update channel_properties set value = REPLACE(value, "\", "/") where ident = "channel_filepath";

Same result.

[Genrabbit]

Got it working... Had to fix it like this;

update channel_properties set value = REPLACE(value, '\\', '/') where ident = "channel_filepath";
update server_properties set value = REPLACE(value, '\\', '/') where ident = "virtualserver_filebase";

value, '\' had to be value, '\\'

[Screech]

When logged in to SSH needed "\\" in place of "\" makes since when it is processing \ as some break or command character. I was running the commands in a SQLite database browser program in windows and my commands work fine then.

[Genrabbit]

Oki, It was something like that a buddy said too. I never heard that SSH was different from normal shell..

I do all my stuff on the Linux box thru SSH. Since its sitting without any keyboard, monitor or mouse.

[Deor]

Ive been running my TS3 server on a windows box for ages but im looking to shift it onto linux now. Ive had no problems setting up and getting everything set up and working with a blank setup, but i want to transfer my database over.

It seems to work ok untill i try and use the file browser, which just gives 'file not found' on every channel. Works fine on my blank setup, can upload/download files no problem. Newly created channels also have this problem.

Any ideas?

Edit by mod
Thread merged, next time use the search function

[Frizianz]

2011-10-01 19:33:47.925737|ERROR   |ServerParser  |   | unable to remove virtualserver filebase, path: files\virtualserver_44

Got this error when deleting the server via TCADMIN on our server after we just moved our ts3 server over to linux from windows.

Any ideas on how to correct this so it deletes and does not error?