Warcraft 3 MODs

Home to war3, war3ft, war3x and uwc3
https://www.wc3mods.net/forums/

Converting SQLite to MySQL

https://www.wc3mods.net/forums/viewtopic.php?f=21&t=3165

Page 1 of 1

Converting SQLite to MySQL

Posted: Fri Feb 22, 2008 6:45 pm
by eXist73
I was wondering is there was a way to convert SQLite XP to MySQL.

--- Please enter the following information for support ---
War3ft Version: RC8
Amxmodx Version: 1.8.0
Metamod Version: 1.19
amxx list:

Code: Select all

[  1] Admin Base              1.8.0.3660  AMXX Dev Team     admin.amxx       running  
          [  2] Admin Commands          1.8.0.3660  AMXX Dev Team     admincmd.amxx    running  
          [  3] Admin Help              1.8.0.3660  AMXX Dev Team     adminhelp.amxx   running  
          [  4] Slots Reservation       1.8.0.3660  AMXX Dev Team     adminslots.amxx  running  
          [  5] Multi-Lingual System    1.8.0.3660  AMXX Dev Team     multilingual.am  running  
          [  6] Menus Front-End         1.8.0.3660  AMXX Dev Team     menufront.amxx   running  
          [  7] Commands Menu           1.8.0.3660  AMXX Dev Team     cmdmenu.amxx     running  
          [  8] Players Menu            1.8.0.3660  AMXX Dev Team     plmenu.amxx      running  
          [  9] Teleport Menu           1.8.0.3660  AMXX Dev Team     telemenu.amxx    running  
          [ 10] Maps Menu               1.8.0.3660  AMXX Dev Team     mapsmenu.amxx    running  
          [ 11] Admin Chat              1.8.0.3660  AMXX Dev Team     adminchat.amxx   running  
          [ 12] Anti Flood              1.8.0.3660  AMXX Dev Team     antiflood.amxx   running  
          [ 13] Scrolling Message       1.8.0.3660  AMXX Dev Team     scrollmsg.amxx   running  
          [ 14] Info. Messages          1.8.0.3660  AMXX Dev Team     imessage.amxx    running  
19:44:36  [ 15] Admin Votes             1.8.0.3660  AMXX Dev Team     adminvote.amxx   running  
          [ 16] NextMap                 1.8.0.3660  AMXX Dev Team     nextmap.amxx     running  
          [ 17] TimeLeft                1.8.0.3660  AMXX Dev Team     timeleft.amxx    running  
          [ 18] Pause Plugins           1.8.0.3660  AMXX Dev Team     pausecfg.amxx    running  
          [ 19] Stats Configuration     1.8.0.3660  AMXX Dev Team     statscfg.amxx    running  
          [ 20] Restrict Weapons        1.8.0.3660  AMXX Dev Team     restmenu.amxx    running  
          [ 21] StatsX                  1.8.0.3660  AMXX Dev Team     statsx.amxx      running  
          [ 22] CS Misc. Stats          1.8.0.3660  AMXX Dev Team     miscstats.amxx   running  
          [ 23] CS Stats Logging        1.8.0.3660  AMXX Dev Team     stats_logging.a  running  
          [ 24] Warcraft 3 Frozen Thro  3.0 RC9     Geesu & Avanderi  war3ft.amxx      debug    
          [ 25] VIP and Admin Access    3.0         eXist`            vip.amxx         debug    
          [ 26] Team Balancer           1.8b3       Ptahhotep         ptb.amxx         debug    
          [ 27] DeagsMapManage          2.30b       Deags             deagsmapmanage2  debug    
          [ 28] Admin Spectator ESP     1.3         KoST              admin_spec_esp.  debug    
          [ 29] Admin Gag               1.8.3       EKS               exec_gag.amxx    debug    
19:44:36  [ 30] MAP CVARs               2.1         EJL               map_cvars.amxx   debug    
          [ 31] Autoresponder/Advertis  0.5         MaximusBrood      ad_manager.amxx  debug    
          [ 32] Knife Only on Bridge i  1.0         xx_sirhc_xx       amx_deagle5_kni  debug    
          [ 33] CSNadeDrops             0.14        Avalanche         csnadedrops.amx  debug    
          [ 34] Rules                   1.0         Chad 'eXist' Fis  rules.amxx       debug    
          [ 35] Point System            1.3         Chad 'eXist' Fis  timer.amxx       debug
amxx modules:

Code: Select all

 [ 1] SQLite                  1.8.0.3660  AMX Mod X Dev Team   running    
          [ 2] Fun                     1.8.0.3660  AMX Mod X Dev Team   running    
          [ 3] Engine                  1.8.0.3660  AMX Mod X Dev Team   running    
          [ 4] FakeMeta                1.8.0.3660  AMX Mod X Dev Team   running    
          [ 5] GeoIP                   1.8.0.3660  AMX Mod X Dev Team   running    
          [ 6] CStrike                 1.8.0.3660  AMX Mod X Dev Team   running    
          [ 7] CSX                     1.8.0.3660  AMX Mod X Dev Team   running    
          [ 8] MySQL                   1.8.0.3660  AMX Mod X Dev Team   running

meta list:

Code: Select all

          [ 1] AMX Mod X        RUN   -    amxmodx_mm_i386.  v1.8.0.3  ini  Start ANY  
          [ 2] SQLite           RUN   -    sqlite_amxx_i386  v1.8.0.3  pl1  ANY   ANY  
          [ 3] Fun              RUN   -    fun_amxx_i386.so  v1.8.0.3  pl1  ANY   ANY  
          [ 4] Engine           RUN   -    engine_amxx_i386  v1.8.0.3  pl1  ANY   ANY  
          [ 5] FakeMeta         RUN   -    fakemeta_amxx_i3  v1.8.0.3  pl1  ANY   ANY  
          [ 6] CStrike          RUN   -    cstrike_amxx_i38  v1.8.0.3  pl1  ANY   ANY  
          [ 7] CSX              RUN   -    csx_amxx_i386.so  v1.8.0.3  pl1  ANY   ANY  
          [ 8] MySQL            RUN   -    mysql_amxx_i386.  v1.8.0.3  pl1  ANY   ANY
[/code]

Posted: Fri Feb 22, 2008 7:08 pm
by YamiKaitou
Not by hand. If you give me 2-3 weeks, I might have time to create a plugin that can do it

Posted: Fri Feb 22, 2008 10:53 pm
by eXist73
I guess I'm going to have to get down on my knees and beg you. Cause I think my SQlite file is too large, since the server is have SQlite problems. Its 4,443 KB.

So yeah. Please make it :D.

Posted: Fri Feb 22, 2008 11:15 pm
by YamiKaitou
What SQLite issues is the server having?

Posted: Sat Feb 23, 2008 12:38 pm
by eXist73
Well, here's the full error log:
http://www.cs-imbalanced.com/images/wc3_error.log

All the SQLite trouble happens at the very end.

Posted: Sat Feb 23, 2008 1:25 pm
by YamiKaitou
Upgrade your AMXx to 1.8 and upgrade Wc3ft to RC9. "Database is locked" error has been fixed by the new version of AMXx

EDIT: Ah, I see. Your new error.
database disk image is malformed
I believe your SQLite database file has become corrupt. I would recommend deleting it and restarting the xp from 0 for everyone.

Posted: Sat Feb 23, 2008 7:07 pm
by eXist73
Yawn, thats not really the answer I wanted :(

Posted: Mon Feb 25, 2008 7:12 pm
by kp_downarrow
lmao thats what u get for sql

Posted: Wed Feb 27, 2008 11:21 am
by Geesu
kp_downarrow wrote:lmao thats what u get for sql
enough with ur GD negativity! :P
All times are UTC-06:00
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/