Mysql to sqlite

[demonserv]

Question in English:
Hello, Currently i manage my teamspeak servers via mysql, now i like recovrer my database from mysql to sqlite, because my mysql server have a very high average with teamspeak.

I seek a informations for my database migration

Afflicted if I do not speak quite English but my language is French.

---------------------------------------------

Question en Français:
Bonjour,
Je gère actuellement mes serveurs teamspeak grâce mysql mais j’aurai aimé savoir comment peut-on reconvertir sa base mysql en sqlite ? Car j’ai des surcharges mysql à cause de teamspeak.

[hudri]

There is a phpMyAdmin-like tool at http://www.phpro.org/sqlite/

I couldn't test it since my server still runs with PHP4 and it seems to require PHP5. If someone has a server with PHP5 running and could test PHP SQLite Admin with TS2 I'd appreciate any feedback postet here.

[hudri]

Found a better solution at
http://www.sqlite.org/download.html
(use the v2.8er branch!)
This command line tools allow to perform SQL-Queries in your server.dbs. You can import sql dumps by entering
.read name_of_sql_dump.sql

PS: Remove the ` which phpMyAdmin uses by default to surround field names in it's SQL dumps.