howto convert my sqlite-DB into a MySQL-DB?

[Harry.Fox]

Hello,

I'm sure there are some threads about this, but I can't find them. So please help me with my problem.

I'm using my TS3-Server together with a sqlite-DB and don't have any chance to make some changes in this DB (e.g. deleting not longer needed users, chance rights if I can't do this via the client).

Now I'm searching for a way to convert the DB into MySQL because I can use phpMyAdmin to do this things afterwords.

[Maxe___]

Hey,
to be able to edit the database it must not be mySQL.

How you can edit your database:
Follow point 2.1 here.

If you want to convert it to mySQL, use the plugin described in the link and hit "Database" and then "Export Database". That will create you a sql file. Simply import this file via phpmyadmin (or other software) to your database-server

[Harry.Fox]

It was a nice tip to modify my sqlitedb directly, but this way is not as comfortable as using phpmyadmin. The database is on my linux-server I rent. It is not at my home and I have no GUI on it. So I can't run Firefox there. I've to transfer the DB to my local PC, modify it and upload it to the server again.

I will try your second idea and import it in a MySQL-DB. I will report here, wether it works or not.

Many thanks so far!

EDIT: It isn't so easy. There are some differences in the syntax between the SQl-File created by SQLITE and MySQL. Therefor I have to find out all of them and edit the File before I will be able to import it in MySQL. Or is there an easier way to do it?

EDIT2: There are not so many differences as i fear. I loaded the file in an editor and use the "replace" function, to do 2 replcements. 1. replace "AUTOINCREMENT" by "AUTO_INCREMENT", 2. replace " by [nothing] (delete all "). Then I was able to import it to a fresh MySQL-Databese. Now I have to found the correct settings to use this Databse instead. But I think, someone here can tell me...

[florian_fr40]

Add INFO : NEVER USE THE FIREFOX SQLITE PLUGGIN TO MANAGE THE TEAMSPEAK DATABASE FILE

We had to help a lot of server owner (and some hoster) to restructure their file. This pluggin can create inconsistencies of syntax.
It's recommended to use a program like SQliteBrowser or SQLite Expert (free soft)

[Harry.Fox]

hm... after I modified the SQL-File the way I discriebed above, I don't have any problems to import it in MySQL and the Database looks fine. Next step is to tell the server that he should use the MySQL-DB (perhaps someone can post me some hints, what to do). I haven't time yet to do so, but when it crashes I know the reason. Thanks!

[florian_fr40]

Next step is to tell the server that he should use the MySQL-DB (perhaps someone can post me some hints, what to do).

For that you have all information in the documentation :
TeamSpeak 3 Server Quick Start.txt

[maplems]

i want to use the mysql server but I don't know how to. Can I use old data from sqlite to mysql?


Please tell me how to do please. Thanks.

This thread was moved