View Full Version : Need .mysql to .dbs
Hi , I was runing on linux with a mysql database for teamspeak and I get back to win2k3 , but the problem is that win2k3 and plesk i have issues with .dll and i can't launch the TS server so I need to convert .mysql to .dbs.
Can someone give me the link of a tool to convert a mysql thing to .dbs ?
Thanks
silly question ...
next time try search FIRST !!
I don't know if something exist already.
NC
hmm so think about it ...
well use mysqldump + parameters
litle know how SQL
create_*.sql from TS server folder sqlite_sql/
and sqlitecc.exe (http://tpc.webyt.net/files/sqlitecc.exe)
also use server.dbs
now cooking :D :
mysqldump --password --user=root put_database_name_here >> TS_sql_backup.sql
// you will be asked for mysql root password or change the user ....
the output will be saved in TS_sql_backup.sql file same folder
use sqlitecc.exe with opened or created(better) server.dbs file
created: copy the queryes from the create_*.sql also exetute them one by one (only once)
reopen it ( sqlitecc.exe )
edit that dump TS_sql_backup.sql
delete all CREATE ... and comments LEAVE only INSERT INTO
I also delete every ` chars (CTRL+H alias replace)
and you should edit every INSERT INTO (what I tryed for you) ...
so use replace again ),( => );INSERT INTO ts2_clients VALUES (
for example.
TS (teamspeak://tpc.webyt.net/)
vBulletin® v3.7.0, Copyright ©2000-2008, Jelsoft Enterprises Ltd.