• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Importing database error

bury

bury

Active Member
Joined
Jul 27, 2008
Messages
421
Solutions
7
Reaction score
25
Hello I have downloaded Real Server 8.6 and when im in phpmyadmin ready to import the Database some errors appears:

Code: 
Hay la posibilidad de que usted haya encontrado un error en el intérprete de SQL. Por favor examine cuidadosamente su consulta, y verifique que las comillas están siendo usadas adecuadamente y hacen juego. Otra posible causa del fallo es que usted este subiendo un archivo con datos binarios por fuera del área de texto delimitado. Intente su consulta en la interfaz de comandos de MySQL. La salida generada por el servidor de MySQL, de existir, aparece abajo, en cuyo caso puede ayudar a diagnosticar el problema. Si aún tiene problemas o el intérprete falla en tanto que en la interfaz de comandos funciona, por favor reduzca la salida de su consulta de SQL a la consulta que genera el problema, y envíe un reporte de error con la cadena de datos en la sección de CORTE indicada abajo:
----INICIO DEL CORTE----
eNrtXQtsHMd5ntn/eMc9E6TeJ0qivYQkUyxfe5QoWxQM60gdKVrHI3kkRdJufV7ercgV725Pt3uU
aLsueJQTt0CLNmjdB1wgCVDDRfow2sQogiJtUbdo3CY14jRx2iR2hbRxnQRNg9Y1Wqfp7Iu8Pd5j
lxYFS5xP4r//vzszOzv//HPznnAsNhbr5waD3GAvFwlH+7lgHxc8zfX1Bfle/+QUeYb8/sFLk/3c
sZFkP6dcTWWFnCLmulPSfHd2Mdu5zPV29/Hdvd1BrpfnT/fwD/YQ/8EH+k8F+/kHuZSYPsOFr2e5
Y/7RlcmJSD/X101cnxK6EnI6nc9I6op/ejLGjU12cqHhcHSqk7sUJm+dkTLcZGgoFBvRPfSdfMA/
PhrqJy87Q8Sgf/zCuOawc2xSCzHYfZqbGYlGp/yRUHS4nxOVrrx6uetBv/5GQiRV5C7LubSgcieR
B2GMznEcQsHzyI7/I3+4SMbIIerIXwvIhHpuwv/Ce/Af8H34LtyEb8Gb8AZ8Gb4Ir8Kfwefhc/Ay
fAZehE/BC/Dr8An4RXgO1uAZWAFV905BcafD889zhLw9S8hblwj59iQh35og5JtRQv4pQsg/PkLI
Ny4Q8uYQIV8nluj5WoiQf3iIkDf6CfnKAySsodOEDJwi5P4F9WyQXB/oJKT3BCHdRwlp57RnQjp7
toUwrYcIufcAIQf3EdLURIifJYT1+gkF+BKCH8Lb5EJBQXGnYjdAG84KinJNziXj6kpWRI0MtGIx
k8itZFVJzqBGTOTkfHxZzClEPmjY/+uI/DTfJBcKCoo7uggoKQGg0VYAMI02+8ea/WP4HCL/KSgo
7gSM1NVhvLoboxkxlZDTIqfKnLoocjFRSHGTYo4YdyeXFJfFlJwVk9z8CndelpJSppsLJURF6edm
p6R5Segmfg37fx+R/xQUFDsEPg8mQHWa/TPwPQT/TQgFBcXdCj9DbN6DUaTt0z/wYc3+tZu6/f8b
gvcIoaCguDvRUKcZv2H9DFuHDfPX2//IQ5OHgmJHVgrInxfXI1yP/xC/y7zMfBf+aiemw+ox7Au0
teGCTxXmU6Kid6LEE3LmsrRgE5jBWDg0FeamQgORMHf/1bysnrU5MG5xJ/yswdnuXgrFBi+EYidO
9rVz0bEpLjodiXDnw0Oh6cgU19bWaXlaFlJ50fQzEp0KD4dj6+6Jo+noyMR0mDux+Q3t/vYzjDcw
2oaRlEmK15WrKUkV40JelXU5botrPGgTYXUQfIGjR3FhtDgV0rKaLGI9lVNAe1z6/VKy8ncYT67J
uVQyXtHdevrw6z5U8bpqup4Kz05VSEp7Klnhd3Ll3krSrc/jDYwcrZFu2heup5om1K0+VmfknHxx
muXEhJxL2gRv5XQzHJSmnO3urUw9KS0qqpDOOs1gxREpn3zW3ZKgtdzodZAbjResp6sh+vSxSdSL
UC/+Cvy9Eytea/H5Au3t+NkSXWTlnKrYpfpq2tBd1MzI47GR0VBsjrsYnvsQ2simhBXyUldeZOW6
K9crrlw/eeuyUhkvRurWtl7LtZBUagbub197st4XaGnBHx/WNS8kEnI+oyrW9Z4y2raeudHzZvPL
CGmxpHDv7Ssq3TcS1hyVc+Y4J6aTworiPFlTgqISH849iGlBSlWLTDl1LIkrpV74cj74DS/zKTmx
JFqfPTA2FgmHotUidk3IZaTMgotvX8jJ+awDCwp2cstSNq5lWk7KqCeC5b6W31T8baiYlGc9rDcw
2FKpPLPyVDxocQ1GD8tfI/gOIRQUFHcgjjANaO9e7PE3aT0nC3KS/EeRxKfaeG3e9CHcgJqawHwa
DKKf/MR4hrDZw/ojBP9DCAUFxV0OH+zVSgimDppwUO9hZRhi/08x1P4pdkJfmpfpQ63aLyFmtDFH
hvwjnC7iBgZ79LkHfn00cgN+PCwnuYtSKiXmkJdJMkw9U4/+/anXUQ7dyOFuNOj7se/HKImfefzp
KZ9nAkcmn7+JEfo5bRwjMvkbjQix0IqYpAYzIgzuQx1mRIyL+TIi+tcjgksjEjLq7tyokBEWSGz0
sZLnyb/zkWgb7gSGhJ1Ezyw+ra+w8OFfJu9//i0tLuuDLQeeQEURMeoA30DwLiEUFBR3B3Z5SDlX
VG4x+z2kvNlUfuijLGgWoVmsFxl4mvld5h34y1sRhV952O8LHD6MPz2t93wZ3YmKefGX6fcyH92m
bi/3HaI1enPW3QmJhKaBrnu8gdDhSh0y5sfGgybTWJho8AU6OvCNueKOwviylE1Jiloi7qncbWg5
KU1G6/F2DHvU6ire1HNVGplOrmxA7cTj0FgsPDIc1bVdwXc7FwsPhWPh6GB4skIfqj0rVQi39O2b
gy3JoiWh+tsf8nsDEx01OuEsDa33xVk39q7ONurDBIUlPQ8spOR5IRVXVDlHzNUu7SuTA+wuSjPA
RhfpLdR88Xhgjc5afvPQ13qUKo59nW3yBsbaKyWo/YPjQbu8n1jhbod5PqVNSq/dTbv+2XJC0Fat
OE+oRVFIqYs138CX+kgL1914Eq9nxZwkZhKiix56WV6al5Mrtd9j83JZFFWXXsgnJV16IVaguPSi
rS6q6eXkaZsfIZmUMy569tPCgqMsU+wjI7jRpObepfI1L0pWzKjOY6XIeRffoMrXMg6M6aMzDJiQ
M0lJM1RLtQORsYHNEU4ILsYJFfG6u9GvlLwgZdx5kdzER1gWtfpWrYGsjdJLWcqnXGhdd66NTbkY
SxUySw4yykJeSiUzUmLJ7XCfmaxy3kVW18bdFXfjd+THRHBVlGpDzpIDO+8L9vIa1j0mpZyYcPKL
0ltUbClK3Hl5X1xQ6F7dFki6J2WJtCcU196IHaqClNmoOjn3Sn7x0658aUPUYsZFHUbOpEjUrIH/
kegc8VO9JM/lpI0KlpNCKyenZXf1haSYElU3o9NJUUnkpGzRW2paE6d9yQrJs2pe0eJ0Isi7HHe2
6m222G5brd3fTmcFU1DsXFD7p6Cg9k9BQUHtn4KCgto/BQUFtX8KCoq72/7rUBdCXfjn8SvMG9BY
xXFhbpcv0NyMn/Ubs2m0wUbFoAfKzZ7Rn9ymxbWOp6nJ1zJirvZIaiIn6hNSkoIq1HJbtBjewYBr
raGfkik75cd+bF+xhXlVHbu9gYebK04D0jUXDxrXQOHQHn3h+5qyofe4lFkmnhSb0FwpF1gOSjOD
g3lutlAcz4crCbiTKxfMNs1aKx9qyas3B2o3l00aO7O32vJ6WyqbirPEQ6vyPn2zh7XjRfrTZhQo
RezhirrTH2/JjGtrzaXxVpsitD3JTitIFBS0gURBQUHtn4KCYudAO9nwCDyusQnbyYbfhK/B6/Aa
vApfgD+BP4Lfgxfhk/Bb8KvwS/AcFOBpWIYsXIGk4ZmCgqIM5m9oy8qEG0DoE2vaGaDxtUcJfXwt
TOjPrPGE/vTaYUIfW6sn9NFCntC5wjyhs4VxQmcK2tmIhLlU6CB0uqAdgjhV0H65J1efIjS2eoXQ
idVZQsdXhwkdW9XOVYyuHiN0dHUPoRFtRf/FFCGPzBAyMkDIBe2oxeED2iYAXvgDLbJX4D/hX+FN
YvZ/atygoKD4iEFiPQxm6q4i9B0iLeoS8xhCnyXSgi7hYYS1Z5d1Cb2P8G8SSTSk30c4TqSkfnLK
o2hW39MD9yDcA2/QxK2JZ1v366NEv9Ci9zYvynlFVAx6pEwfs/HkduwlrI+Z1FxqKbgJ0v0OltpC
O9PXNgxuaetJXSyuk550teZKcrNyL+dq2WxSlnNu1hGKScXN3rUp0c0mo9qIQK11YkOhyGR4Y7Qw
JQo5p15c7lbdcaDaUJ1hPvGgcW2h3RUUFLS7koKCYmfavwefQ/gc87PMZ+FvaYq4Q6E/oE+VuXF2
o/ES17aSUorY+yo1Y4zHpW0Z49F2tGi01znYimlj8zLbKQybqqL2iFY//6P41RVmPDkJrsyEHHuD
0OmRLgerHelSpByzpmwIXGFfsy/Q2mrNbDMeaVP+NjjjFRU1XjQ/8DYovOhtkbHocOnmO+7V+RFQ
3clD3sBwa3XVad9taU7jj9J6DgUFbedQUFBQ+6egoKD2T0FBsTPsH9AHCH3AfAn8O+vb16KH9U3t
PzZT1Gkl5PXdbhW7dKxiv5Xl4vb1XTle6znvrgs0LbmYZyBmkk43Xr4TO9O25xCGs0eqnRlgz09W
L50lH19VWozFw8eLTi2JJ0VBXVRsQlvFE0xMB1taguo41yUFVfwwhxps1wkYtKZDQUFbOhQUFDu0
pYOPI3ycOQU9ND3KotBwr3403pqsVzKX9DP6FPNyokzF0ny0pSqlXht1UKO8LGWEVHxxvXnicC5x
PnMlr6jSZUl0PAm5TMXTHsmK9c6SqvWm2ufq9fv0tuZaR3Ht3Uw9u/RTlevvFVJbu+3k9KPaVfgy
CWALvMz3l8TpNp1ntxrlfIGTJ3FhUE9PMbMs5eRMWsyoViKVudVRJmXLONti8jpYXHDLk5c2aygo
aLOGpgMFBbV/CgoKav8UFBQ7xf4Bn0H4DPMS8z2aHo5RSLX6Aj09+FmffTw9K6v6yb6bbnRWG1e3
HG15Y27FQf+dm/kcWmyqnDdfdBB53s3+EoKq5qT5/MYW5NWXTlXYPlzZ9v7BkMF5A9M9leZbbNJd
PLjpVldhz1FfoKsLr80U5xKtqy8lJ5aUUrmnch5Zd7PlLOJ495KMeC3u2HGV+Ro2/dNJGRQUFLe8
9uKDP0bwX/AuvAVfhS/CF4hIQUHx0QTrq8MEjNePWK/B1hG2zmA9hPUYLBAWDJYhLGOwmLDYYIn1
G/b/Nwjehx/CO/A2vAmvE5GCguIOgr7FJ+P1Gdc6r3H11BlX8BhXBowrZowrwsaxaUGEgljALzAv
Mf9Sq9XedUyfBX+jubg9ps9QUmwCX7klZjjYektd817b2bKQyrvY5tFxO9xZA7s4jtvWyD5zvNpR
WrbUXm9bG2KwwN4vpLNnjTlRozZdqnJOWCiRTlbRpuFiy+pcElfcqLLGwXR8m1MVrb9329Rztq3a
chN78m3ox5BPFQ6eMJSzVKycZSmrbfhjl/oqK8d0sWXlEP8f/rC64kBu61F1thdvrXOklfm1ksYR
vAS/DZ+Aj8PTcBUuw2MwDmHohx44Bs3QCMC8z/yAucl8nfk75i+YV5jPMJ8kQVBQ3KLqf6sHQxOD
fkfhWc5kszx7n8lmePZek53j2RaTneXZIyY7w7OHTfYSzx4y2WmebTbZKZ49aLKTPBsw2RjPHjDZ
CZ7db7LjPLvPZMd4dq/JRnl2j8mO8uxuk43w7C6TvcizTSb7CM82muwIz/pN9gLPNpjsMM/eY7JD
Gw7CPMua7HmerTfZQZ71mewAz3pNNsSzdSZ7jmc9Jvswz4LJaqcu8CxjSg/xLLYepMgDoxR4BcF7
8H24SRpIX4ZX4fPwMrwIL5By4Dl4BlS4Ak/AJYjAADwI3aQkOAS7wMt8wPyIeYf5NvNV5jXmz0kQ
FBS3q5ggWRhrpUSrxWU5i8vcZ3Fz91rcbIvFzRyxuEuHLW76kMVNNVvc5EGLiwUsbuKAxY3vt7ix
fRYX3Wtxo3ssLrLb4i7usrhHmixupNHiLvgtbrjB4obusbjw+tPzrMUN1lvcgM/iQl6LO1dncQ97
LE4rB8ASHmLWb5NSANOBEgqKnQtq/xQUO9v+Peg1hF7DPibKrNy5X3L2/wE43Od5
----FIN DEL CORTE----
----INICIO DEL VOLCADO----
ERROR: C1 C2 LEN: 15 16 55102
STR: 

CVS: $Id: sqlparser.lib.php,v 2.50.2.1 2006/08/16 17:41:08 lem9 Exp $
MySQL: 5.0.24a-community
USR OS, AGENT, VER: Win SAFARI 5.0.537
PMA: 2.9.0.1
PHP VER,OS: 5.1.6 WINNT
LANG: es-utf-8
SQL: SQLite format 3@  1D�o��������������������������~yto�Y�X�V�S�Q�N�L�J�H�F�D�A�=�:�7F6B4>17,2(.#) &!
		
����'password_type!encryption!db_version
����'password_type!encryption!db_version
��I�Welcome to the Real Server, developed by Doidin. Acess: XTibia.com
��
���
L'��
���L'��	

������$''�tableserver_configserver_configCREATE TABLE "server_config" (
	"config" VARCHAR(35) NOT NULL DEFAULT '',
	"value" INTEGER NOT NULL,
	UNIQUE ("config")
)9M'indexsqlite_autoindex_server_config_1server_config�C##�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
	"id" INTEGER NOT NULL,
	"world_id" INTEGER NOT NULL DEFAULT 0,
	"text" TEXT NOT NULL DEFAULT '',
	UNIQUE ("id", "world_id")
)5I#indexsqlite_autoindex_server_motd_1server_motd�[''�utableserver_recordserver_recordCREATE TABLE "server_record" (
	"record" INTEGER NOT NULL,
	"world_id" INTEGER NOT NULL DEFAULT 0,
	"timestamp" INTEGER NOT NULL,
	UNIQUE ("record", "world_id", "timestamp")
)9M'indexsqlite_autoindex_server_record_1server_record
22���))�utableserver_reportsserver_reportsCREATE TABLE "server_reports" (
	"id" INTEGER PRIMARY KEY,
	"world_id" INTEGER NOT NULL DEFAULT 0,
	"player_id" INTEGER NOT NULL DEFAULT 0,
	"posx" INTEGER NOT NULL DEFAULT 0,
	"posy" INTEGER NOT NULL DEFAULT 0,
	"posz" INTEGER NOT NULL DEFAULT 0,
	"timestamp" INTEGER NOT NULL DEFAULT 0,
	"report" TEXT NOT NULL DEFAULT '',
	"reads" INTEGER NOT NULL DEFAULT 0
)�z�GtableaccountsaccountsCREATE TABLE "accounts" (
	"id" INTEGER PRIMARY KEY NOT NULL,
	"name" VARCHAR(255) NOT NULL,
	"password" VARCHAR(255) NOT NULL,
	"premdays" INTEGER NOT NULL DEFAULT 0,
	"lastday" INTEGER NOT NULL DEFAULT 0,
	"email" VARCHAR(255) NOT NULL DEFAULT '',
	"key" VARCHAR(20) NOT NULL DEFAULT '0',
	"blocked" BOOLEAN NOT NULL DEFAULT 0,
	"warnings" INTEGER NOT NULL DEFAULT 0,
	"group_id" INTEGER NOT NULL DEFAULT 1, vip_time int(15) NOT NULL DEFAULT 0,
	UNIQUE ("name")
)/	Cindexsqlite_autoindex_accounts_1accounts
���
godgodLc�'0
11��Lc�'0
���god1
�{��5!

God Killerd�{�r�r.C��d~^|TQLS��LS�	!ddddd�5+


Account Manager��DLN',d~h|&�LS��`ddddd
���!God Killer+Account Manager
XX&U����?
�Utableplayersplayers
CREATE TABLE "players" (
	"id" INTEGER PRIMARY KEY NOT NULL,
	"name" VARCHAR(255) NOT NULL,
	"world_id" INTEGER NOT NULL DEFAULT 0,
	"group_id" INTEGER NOT NULL,
	"acc-Aindexsqlite_autoindex_players_1players�Q++�Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
	"account_id" INTEGER NOT NULL,
	"world_id" INTEGER NOT NULL DEFAULT 0,
	"player_id" INTEGER NOT NULL,
	UNIQUE ("account_id", "player_id"),
	FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
	FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+indexsqlite_autoindex_account_viplist_1account_viplist�X))�ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (
	"key" INTEGER NOT NULL,
	"world_id" INTEGER NOT NULL DEFAULT 0,
	"value" VARCHAR(255) NOT NULL DEFAULT '0',
	UNIQUE ("key", "world_id")
);O)indexsqlite_autoindex_global_storage_1global_storageount_id" INTEGER NOT NULL,
	"level" INTEGER NOT NULL DEFAULT 1,
	"vocation" INTEGER NOT NULL DEFAULT 0,
	"health" INTEGER NOT NULL DEFAULT 100,
	"healthmax" INTEGER NOT NULL DEFAULT 100,
	"experience" INTEGER NOT NULL DEFAULT 0,
	"lookbody" INTEGER NOT NULL DEFAULT 10,
	"lookfeet" INTEGER NOT NULL DEFAULT 10,
	"lookhead" INTEGER NOT NULL DEFAULT 10,
	"looklegs" INTEGER NOT NULL DEFAULT 10,
	"looktype" INTEGER NOT NULL DEFAULT 136,
	"lookaddons" INTEGER NOT NULL DEFAULT 0,
	"maglevel" INTEGER NOT NULL DEFAULT 0,
	"mana" INTEGER NOT NULL DEFAULT 100,
	"manamax" INTEGER NOT NULL DEFAULT 100,
	"manaspent" INTEGER NOT NULL DEFAULT 0,
	"soul" INTEGER NOT NULL DEFAULT 0,
	"town_id" INTEGER NOT NULL,
	"posx" INTEGER NOT NULL DEFAULT 0,
	"posy" INTEGER NOT NULL DEFAULT 0,
	"posz" INTEGER NOT NULL DEFAULT 0,
	"conditions" BLOB NOT NULL,
	"cap" INTEGER NOT NULL DEFAULT 0,
	"sex" INTEGER NOT NULL DEFAULT 0,
	"lastlogin" INTEGER NOT NULL DEFAULT 0,
	"lastip" INTEGER NOT NULL DEFAULT 0,
	"save" BOOLEAN NOT NULL DEFAULT 1,
	"skull" INTEGER NOT NULL DEFAULT 0,
	"skulltime" INTEGER NOT NULL DEFAULT 0,
	"rank_id" INTEGER NOT NULL,
	"guildnick" VARCHAR(255) NOT NULL DEFAULT '',
	"lastlogout" INTEGER NOT NULL DEFAULT 0,
	"blessings" INTEGER NOT NULL DEFAULT 0,
	"balance" INTEGER NOT NULL DEFAULT 0,
	"stamina" INTEGER NOT NULL DEFAULT 151200000,
	"direction" INTEGER NOT NULL DEFAULT 2,
	"loss_experience" INTEGER NOT NULL DEFAULT 100,
	"loss_mana" INTEGER NOT NULL DEFAULT 100,
	"loss_skills" INTEGER NOT NULL DEFAULT 100,
	"loss_containers" INTEGER NOT NULL DEFAULT 100,
	"loss_items" INTEGER NOT NULL DEFAULT 100,
	"premend" INTEGER NOT NULL DEFAULT 0,
	"online" TINYINT NOT NULL DEFAULT 0,
	"marriage" INTEGER NOT NULL DEFAULT 0,
	"promotion" INTEGER NOT NULL DEFAULT 0,
	"deleted" BOOLEAN NOT NULL DEFAULT 0,
	"description" VARCHAR(255) NOT NULL DEFAULT '', marrystatus INT(10) NOT NULL DEFAULT 0,
	UNIQUE ("name", "deleted"),
	FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)






--����Y�
tableguildsguildsCREATE TABLE "guilds" (
	"id" INTEGER PRIMARY KEY,
	"world_id" INTEGER NOT NULL DEFAULT 0,
	"name" VARCHAR(255) NOT NULL,
	"ownerid" INTEGER NOT NULL,
	"creationdata" INTEGER NOT NULL,
	"motd" VARCHAR(255) NOT NULL DEFAULT '',
	UNIQUE ("name", "world_id"),
	FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)+?indexsqlite_autoindex_guilds_1guilds�''�stableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
	"player_id" INTEGER NOT NULL,
	"guild_id" INTEGER NOT NULL,
	UNIQUE ("player_id", "guild_id"),
	FOREIGN KEY ("player_id") REFERENCES "players" ("id"),
	FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)9M'indexsqlite_autoindex_guild_invites_1guild_invites�o##�%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" (
	"id" INTEGER PRIMARY KEY,
	"guild_id" INTEGER NOT NULL,
	"name" VARCHAR(255) NOT NULL,
	"level" INTEGER NOT NULL,
	FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)


^c����������������������|vpjd^b�a�`�o_�Z^�E]�0\�[�Z�uY�bX�PW�>V�+U�T�
S�{R�jQ�XP�GO�6N�$M�LKlJWIBH,G�j������i	q�h	[�g	G�f	��e	�_dZX
//��!�tablehouseshousesCREATE TABLE "houses" (
	"id" INTEGER NOT NULL,
	"world_id" INTEGER NOT NULL DEFAULT 0,
	"owner" INTEGER NOT NULL,
	"paid" INTEGER NOT NULL DEFAULT 0,
	"warnings" INTEGER NOT NULL DEFAULT 0,
	"lastwarning" INTEGER NOT NULL DEFAULT 0,
	"name" VARCHAR(255) NOT NULL,
	"town" INTEGER NOT NULL DEFAULT 0,
	"size" INTEGER NOT NULL DEFAULT 0,
	"price" INTEGER NOT NULL DEFAULT 0,
	"rent" INTEGER NOT NULL DEFAULT 0,
	"doors" INTEGER NOT NULL DEFAULT 0,
	"beds" INTEGER NOT NULL DEFAULT 0,
	"tiles" INTEGER NOT NULL DEFAULT 0,
	"guild" BOOLEAN NOT NULL DEFAULT FALSE,
	"clear" BOOLEAN NOT NULL DEFAULT FALSE,
	UNIQUE ("id", "world_id")
)+?indexsqlite_autoindex_houses_1houses


@@}���:##�;tablehouse_listshouse_listsCREATE TABLE "house_lists" (
	"house_id" INTEGER NOT NULL,
	"world_id" INTEGER NOT NULL DEFAULT 0,
	"listid" INTEGER NOT NULL,
	"list" TEXT NOT NULL,
	UNIQUE ("house_id", "world_id", "listid"),
	FOREIGN KEY ("house_id", "world_id") REFERENCES "houses" ("id", "world_id")
)5I#indexsqlite_autoindex_house_lists_1house_lists �!!�stablehouse_datahouse_data"CREATE TABLE "house_data" (
	"house_id" INTEGER NOT NULL,
	"world_id" INTEGER NOT NULL DEFAULT 0,
	"data" LONGBLOB NOT NULL,
	UNIQUE ("house_id", "world_id"),
	FOREIGN KEY ("house_id", "world_id") REFERENCES "houses" ("id", "world_id")
)3G!indexsqlite_autoindex_house_data_1house_data#




���
�N))�Wtablehouse_auctionshouse_auctions$CREATE TABLE "house_auctions" (
	"house_id" INTEGER NOT NULL,
	"world_id" INTEGER NOT NULL DEFAULT 0,
	"player_id" INTEGER NOT NULL,
	"bid" INTEGER NOT NULL DEFAULT 0,
	"limit" INTEGER NOT NULL DEFAULT 0,
	"endtime" INTEGER NOT NULL DEFAULT 0,
	UNIQUE ("house_id", "world_id"),
	FOREIGN KEY ("house_id", "world_id") REFERENCES "houses" ("id", "world_id")
	FOREIGN KEY ("player_id") REFERENCES "players" ("id")
);O)indexsqlite_autoindex_house_auctions_1house_auctions%�s''�%tableplayer_deathsplayer_deaths'CREATE TABLE "player_deaths" (
	"id" INTEGER PRIMARY KEY,
	"player_id" INTEGER NOT NULL,
	"date" INTEGER NOT NULL,
	"level" INTEGER NOT NULL,
	FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)


%%4/��otablekillerskillers(CREATE TABLE "killers" (
	"id" INTEGER PRIMARY KEY,
	"death_id" INTEGER NOT NULL,
	"final_hit" BOOLEAN NOT NULL DEFAULT FALSE,
	"unjustified" BOOLEAN NOT NULL DEFAULT FALSE,
	FOREIGN KEY ("death_id") REFERENCES "player_deaths" ("id")
)�x))�+tableplayer_killersplayer_killers*CREATE TABLE "player_killers" (
	"kill_id" INTEGER NOT NULL,
	"player_id" INTEGER NOT NULL,
	FOREIGN KEY ("kill_id") REFERENCES "killers" ("id"),
	FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)�N 33�Ctableenvironment_killersenvironment_killers+CREATE TABLE "environment_killers" (
	"kill_id" INTEGER NOT NULL,
	"name" VARCHAR(255) NOT NULL,
	FOREIGN KEY ("kill_id") REFERENCES "killers" ("id")
)




99���l!//�tableplayer_depotitemsplayer_depotitems,CREATE TABLE "player_depotitems" (
	"player_id" INTEGER NOT NULL,
	"sid" INTEGER NOT NULL,
	"pid" INTEGER NOT NULL DEFAULT 0,
	"itemtype" INTEGER NOT NULL,
	"count" INTEGER NOT NULL DEFAULT 0,
	"attributes" BLOB NOT NULL,
	UNIQUE ("player_id", "sid"),
	FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)A"U/indexsqlite_autoindex_player_depotitems_1player_depotitems-�#--�Wtableplayer_namelocksplayer_namelocks/CREATE TABLE "player_namelocks" (
	"player_id" INTEGER NOT NULL,
	"name" VARCHAR(255) NOT NULL,
	"new_name" VARCHAR(255) NOT NULL,
	"date" INTEGER NOT NULL DEFAULT 0,
	FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)

��������	
	
	
	
	
	
	

��������
11a����-$''�tableplayer_skillsplayer_skills0CREATE TABLE "player_skills" (
	"player_id" INTEGER NOT NULL,
	"skillid" INTEGER NOT NULL,
	"value" INTEGER NOT NULL DEFAULT 0,
	"count" INTEGER NOT NULL DEFAULT 0,
	UNIQUE ("player_id", "skillid"),
	FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)9%M'indexsqlite_autoindex_player_skills_1player_skills1�	&))�Mtableplayer_storageplayer_storage3CREATE TABLE "player_storage" (
	"player_id" INTEGER NOT NULL,
	"key" INTEGER NOT NULL,
	"value" VARCHAR(255) NOT NULL DEFAULT '0',
	UNIQUE ("player_id", "key"),
	FOREIGN KEY ("player_id") REFERENCES "players" ("id")
);'O)indexsqlite_autoindex_player_storage_1player_storage4�())�ktableplayer_viplistplayer_viplist5CREATE TABLE "player_viplist" (
	"player_id" INTEGER NOT NULL,
	"vip_id" INTEGER NOT NULL,
	UNIQUE ("player_id", "vip_id"),
	FOREIGN KEY ("player_id") REFERENCES "players" ("id"),
	FOREIGN KEY ("vip_id") REFERENCES "players" ("id")
)
!������������|qf[PE:/$����������	!�s0	 �p0	�n0	�Y0	�X0	�W0	�V0	�U0	�T0	�S0	�R0	�Q0	�P0	�O0	�N0	�M0	�L0	�K0	�J0	�I0	
�H0	�G0	�F0	
�E0		�D0	�C0	�B0	�A0	�@0	�?0	�>0	�=0	�<0
!�������������~tj`VLB8.$��������	�s!	�p 	�n	�Y	�X	�W	�V	�U	�T	�S	�R	�Q	�P	�O	�N	�M	�L	�K	�J	�I	�H
	�G	�F	�E
	�D		�C	�B	�A	�@	�?	�>	�=	�<


��Ny;
----FIN DEL VOLCADO----

consulta SQL:

SQLite format 3@ 1D�o��������������������������~yto�Y�X�V�S�Q�N�L�J�H�F�D�A�=�:�7F6B4>17,2(.#) &!  ����'password_type!encryption!db_version ����'password_type!encryption!db_version ��I�Welcome to the Real Server, developed by Doidin. Acess: XTibia.com �� ��� L'�� ���L'��	  ������$''�tableserver_configserver_configCREATE TABLE "server_config" ( "config" VARCHAR(35) NOT NULL DEFAULT '', "value" INTEGER NOT NULL, UNIQUE ("config") )9M'indexsqlite_autoindex_server_config_1server_config�C##�Mtableserver_motdserver_motdCREATE TABLE "server_motd" ( "id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "text" TEXT NOT NULL DEFAULT '', UNIQUE ("id", "world_id") )5I#indexsqlite_autoindex_server_motd_1server_motd�[''�utableserver_recordserver_recordCREATE TABLE "server_record" ( "record" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "timestamp" INTEGER NOT NULL, UNIQUE ("record", "world_id", "timestamp") )9M'indexsqlite_autoindex_server_record_1server_record 22���))�utableserver_reportsserver_reportsCREATE TABLE "server_reports" ( "id" INTEGER PRIMARY KEY, "world_id" INTEGER NOT NULL DEFAULT 0, "player_id" INTEGER NOT NULL DEFAULT 0, "posx" INTEGER NOT NULL DEFAULT 0, "posy" INTEGER NOT NULL DEFAULT 0, "posz" INTEGER NOT NULL DEFAULT 0, "timestamp" INTEGER NOT NULL DEFAULT 0, "report" TEXT NOT NULL DEFAULT '', "reads" INTEGER NOT NULL DEFAULT 0 )�z�GtableaccountsaccountsCREATE TABLE "accounts" ( "id" INTEGER PRIMARY KEY NOT NULL, "name" VARCHAR(255) NOT NULL, "password" VARCHAR(255) NOT NULL, "premdays" INTEGER NOT NULL DEFAULT 0, "lastday" INTEGER NOT NULL DEFAULT 0, "email" VARCHAR(255) NOT NULL DEFAULT '', "key" VARCHAR(20) NOT NULL DEFAULT '0', "blocked" BOOLEAN NOT NULL DEFAULT 0, "warnings" INTEGER NOT NULL DEFAULT 0, "group_id" INTEGER NOT NULL DEFAULT 1, vip_time int(15) NOT NULL DEFAULT 0, UNIQUE ("name") )/	Cindexsqlite_autoindex_accounts_1accounts ��� godgodLc�'0 11��Lc�'0 ���god1 �{��5!  God Killerd�{�r�r.C��d~^|TQLS��LS�	!ddddd�5+   Account Manager��DLN',d~h|&�LS��`ddddd ���!God Killer+Account Manager XX&U����? �Utableplayersplayers CREATE TABLE "players" ( "id" INTEGER PRIMARY KEY NOT NULL, "name" VARCHAR(255) NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "group_id" INTEGER NOT NULL, "acc-Aindexsqlite_autoindex_players_1players�Q++�Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" ( "account_id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "player_id" INTEGER NOT NULL, UNIQUE ("account_id", "player_id"), FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"), FOREIGN KEY ("player_id") REFERENCES "players" ("id") )= Q+indexsqlite_autoindex_account_viplist_1account_viplist�X))�ktableglobal_storageglobal_storageCREATE TABLE "global_storage" ( "key" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "value" VARCHAR(255) NOT NULL DEFAULT '0', UNIQUE ("key", "world_id") );O)indexsqlite_autoindex_global_storage_1global_storageount_id" INTEGER NOT NULL, "level" INTEGER NOT NULL DEFAULT 1, "vocation" INTEGER NOT NULL DEFAULT 0, "health" INTEGER NOT NULL DEFAULT 100, "healthmax" INTEGER NOT NULL DEFAULT 100, "experience" INTEGER NOT NULL DEFAULT 0, "lookbody" INTEGER NOT NULL DEFAULT 10, "lookfeet" INTEGER NOT NULL DEFAULT 10, "lookhead" INTEGER NOT NULL DEFAULT 10, "looklegs" INTEGER NOT NULL DEFAULT 10, "looktype" INTEGER NOT NULL DEFAULT 136, "lookaddons" INTEGER NOT NULL DEFAULT 0, "maglevel" INTEGER NOT NULL DEFAULT 0, "mana" INTEGER NOT NULL DEFAULT 100, "manamax" INTEGER NOT NULL DEFAULT 100, "manaspent" INTEGER NOT NULL DEFAULT 0, "soul" INTEGER NOT NULL DEFAULT 0, "town_id" INTEGER NOT NULL, "posx" INTEGER NOT NULL DEFAULT 0, "posy" INTEGER NOT NULL DEFAULT 0, "posz" INTEGER NOT NULL DEFAULT 0, "conditions" BLOB NOT NULL, "cap" INTEGER NOT NULL DEFAULT 0, "sex" INTEGER NOT NULL DEFAULT 0, "lastlogin" INTEGER NOT NULL DEFAULT 0, "lastip" INTEGER NOT NULL DEFAULT 0, "save" BOOLEAN NOT NULL DEFAULT 1, "skull" INTEGER NOT NULL DEFAULT 0, "skulltime" INTEGER NOT NULL DEFAULT 0, "rank_id" INTEGER NOT NULL, "guildnick" VARCHAR(255) NOT NULL DEFAULT '', "lastlogout" INTEGER NOT NULL DEFAULT 0, "blessings" INTEGER NOT NULL DEFAULT 0, "balance" INTEGER NOT NULL DEFAULT 0, "stamina" INTEGER NOT NULL DEFAULT 151200000, "direction" INTEGER NOT NULL DEFAULT 2, "loss_experience" INTEGER NOT NULL DEFAULT 100, "loss_mana" INTEGER NOT NULL DEFAULT 100, "loss_skills" INTEGER NOT NULL DEFAULT 100, "loss_containers" INTEGER NOT NULL DEFAULT 100, "loss_items" INTEGER NOT NULL DEFAULT 100, "premend" INTEGER NOT NULL DEFAULT 0, "online" TINYINT NOT NULL DEFAULT 0, "marriage" INTEGER NOT NULL DEFAULT 0, "promotion" INTEGER NOT NULL DEFAULT 0, "deleted" BOOLEAN NOT NULL DEFAULT 0, "description" VARCHAR(255) NOT NULL DEFAULT '', marrystatus INT(10) NOT NULL DEFAULT 0, UNIQUE ("name", "deleted"), FOREIGN KEY ("account_id") REFERENCES "accounts" ("id") )       --����Y� tableguildsguildsCREATE TABLE "guilds" ( "id" INTEGER PRIMARY KEY, "world_id" INTEGER NOT NULL DEFAULT 0, "name" VARCHAR(255) NOT NULL, "ownerid" INTEGER NOT NULL, "creationdata" INTEGER NOT NULL, "motd" VARCHAR(255) NOT NULL DEFAULT '', UNIQUE ("name", "world_id"), FOREIGN KEY ("ownerid") REFERENCES "players" ("id") )+?indexsqlite_autoindex_guilds_1guilds�''�stableguild_invitesguild_invitesCREATE TABLE "guild_invites" ( "player_id" INTEGER NOT NULL, "guild_id" INTEGER NOT NULL, UNIQUE ("player_id", "guild_id"), FOREIGN KEY ("player_id") REFERENCES "players" ("id"), FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") )9M'indexsqlite_autoindex_guild_invites_1guild_invites�o##�%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" ( "id" INTEGER PRIMARY KEY, "guild_id" INTEGER NOT NULL, "name" VARCHAR(255) NOT NULL, "level" INTEGER NOT NULL, FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") )   ^c����������������������|vpjd^b�a�`�o_�Z^�E]�0\�[�Z�uY�bX�PW�>V�+U�T� S�{R�jQ�XP�GO�6N�$M�LKlJWIBH,G�j������i	q�h	[�g	G�f	��e	�_dZX //��!�tablehouseshousesCREATE TABLE "houses" ( "id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "owner" INTEGER NOT NULL, "paid" INTEGER NOT NULL DEFAULT 0, "warnings" INTEGER NOT NULL DEFAULT 0, "lastwarning" INTEGER NOT NULL DEFAULT 0, "name" VARCHAR(255) NOT NULL, "town" INTEGER NOT NULL DEFAULT 0, "size" INTEGER NOT NULL DEFAULT 0, "price" INTEGER NOT NULL DEFAULT 0, "rent" INTEGER NOT NULL DEFAULT 0, "doors" INTEGER NOT NULL DEFAULT 0, "beds" INTEGER NOT NULL DEFAULT 0, "tiles" INTEGER NOT NULL DEFAULT 0, "guild" BOOLEAN NOT NULL DEFAULT FALSE, "clear" BOOLEAN NOT NULL DEFAULT FALSE, UNIQUE ("id", "world_id") )+?indexsqlite_autoindex_houses_1houses   @@}���:##�;tablehouse_listshouse_listsCREATE TABLE "house_lists" ( "house_id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "listid" INTEGER NOT NULL, "list" TEXT NOT NULL, UNIQUE ("house_id", "world_id", "listid"), FOREIGN KEY ("house_id", "world_id") REFERENCES "houses" ("id", "world_id") )5I#indexsqlite_autoindex_house_lists_1house_lists �!!�stablehouse_datahouse_data"CREATE TABLE "house_data" ( "house_id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "data" LONGBLOB NOT NULL, UNIQUE ("house_id", "world_id"), FOREIGN KEY ("house_id", "world_id") REFERENCES "houses" ("id", "world_id") )3G!indexsqlite_autoindex_house_data_1house_data#     ��� �N))�Wtablehouse_auctionshouse_auctions$CREATE TABLE "house_auctions" ( "house_id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "player_id" INTEGER NOT NULL, "bid" INTEGER NOT NULL DEFAULT 0, "limit" INTEGER NOT NULL DEFAULT 0, "endtime" INTEGER NOT NULL DEFAULT 0, UNIQUE ("house_id", "world_id"), FOREIGN KEY ("house_id", "world_id") REFERENCES "houses" ("id", "world_id") FOREIGN KEY ("player_id") REFERENCES "players" ("id") );O)indexsqlite_autoindex_house_auctions_1house_auctions%�s''�%tableplayer_deathsplayer_deaths'CREATE TABLE "player_deaths" ( "id" INTEGER PRIMARY KEY, "player_id" INTEGER NOT NULL, "date" INTEGER NOT NULL, "level" INTEGER NOT NULL, FOREIGN KEY ("player_id") REFERENCES "players" ("id") )   %%4/��otablekillerskillers(CREATE TABLE "killers" ( "id" INTEGER PRIMARY KEY, "death_id" INTEGER NOT NULL, "final_hit" BOOLEAN NOT NULL DEFAULT FALSE, "unjustified" BOOLEAN NOT NULL DEFAULT FALSE, FOREIGN KEY ("death_id") REFERENCES "player_deaths" ("id") )�x))�+tableplayer_killersplayer_killers*CREATE TABLE "player_killers" ( "kill_id" INTEGER NOT NULL, "player_id" INTEGER NOT NULL, FOREIGN KEY ("kill_id") REFERENCES "killers" ("id"), FOREIGN KEY ("player_id") REFERENCES "players" ("id") )�N 33�Ctableenvironment_killersenvironment_killers+CREATE TABLE "environment_killers" ( "kill_id" INTEGER NOT NULL, "name" VARCHAR(255) NOT NULL, FOREIGN KEY ("kill_id") REFERENCES "killers" ("id") )     99���l!//�tableplayer_depotitemsplayer_depotitems,CREATE TABLE "player_depotitems" ( "player_id" INTEGER NOT NULL, "sid" INTEGER NOT NULL, "pid" INTEGER NOT NULL DEFAULT 0, "itemtype" INTEGER NOT NULL, "count" INTEGER NOT NULL DEFAULT 0, "attributes" BLOB NOT NULL, UNIQUE ("player_id", "sid"), FOREIGN KEY ("player_id") REFERENCES "players" ("id") )A"U/indexsqlite_autoindex_player_depotitems_1player_depotitems-�#--�Wtableplayer_namelocksplayer_namelocks/CREATE TABLE "player_namelocks" ( "player_id" INTEGER NOT NULL, "name" VARCHAR(255) NOT NULL, "new_name" VARCHAR(255) NOT NULL, "date" INTEGER NOT NULL DEFAULT 0, FOREIGN KEY ("player_id") REFERENCES "players" ("id") )  ��������	       �������� 11a����-$''�tableplayer_skillsplayer_skills0CREATE TABLE "player_skills" ( "player_id" INTEGER NOT NULL, "skillid" INTEGER NOT NULL, "value" INTEGER NOT NULL DEFAULT 0, "count" INTEGER NOT NULL DEFAULT 0, UNIQUE ("player_id", "skillid"), FOREIGN KEY ("player_id") REFERENCES "players" ("id") )9%M'indexsqlite_autoindex_player_skills_1player_skills1�	&))�Mtableplayer_storageplayer_storage3CREATE TABLE "player_storage" ( "player_id" INTEGER NOT NULL, "key" INTEGER NOT NULL, "value" VARCHAR(255) NOT NULL DEFAULT '0', UNIQUE ("player_id", "key"), FOREIGN KEY ("player_id") REFERENCES "players" ("id") );'O)indexsqlite_autoindex_player_storage_1player_storage4�())�ktableplayer_viplistplayer_viplist5CREATE TABLE "player_viplist" ( "player_id" INTEGER NOT NULL, "vip_id" INTEGER NOT NULL, UNIQUE ("player_id", "vip_id"), FOREIGN KEY ("player_id") REFERENCES "players" ("id"), FOREIGN KEY ("vip_id") REFERENCES "players" ("id") ) !������������|qf[PE:/$����������	!�s0	 �p0	�n0	�Y0	�X0	�W0	�V0	�U0	�T0	�S0	�R0	�Q0	�P0	�O0	�N0	�M0	�L0	�K0	�J0	�I0	 �H0	�G0	�F0	 �E0	 �D0	�C0	�B0	�A0	�@0	�?0	�>0	�=0	�<0 !�������������~tj`VLB8.$��������	�s!	�p �n	�Y	�X	�W	�V	�U	�T	�S	�R	�Q	�P	�O	�N	�M	�L	�K	�J	�I	�H �G	�F	�E �D	 �C	�B	�A	�@	�?	�>	�=	�<   ��Ny;

MySQL ha dicho: 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQLite format 3' at line 1 
[ Volver ]

The last error I see I think is the most important of everything:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQLite format 3' at line 1


I have two databases (.SQL and .s3db) The first one is only 19 kb and the other 1.2 mb. Sqlitestudio only allows me to open the .s3db file, and I see everything like Accounts, Players etc.

I havent done anything the server is just downloaded and trying to import I see that error. If someone has faced a similar error could help me...

Thanks you!
 
Sort by date Sort by votes
OK, cronox Im gonna explain what I have done. Finally I have import mysql.sql inside the schemas folder and I had some errors in phpmyadmin I could solve.

Now my question is: Phpmyadmin is using the database "mysql.sql" And If i Go to the config.lua I have these parts:

sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "realserver"
sqlFile = "realserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

As you can see the db config.lua is using is this sqlFile = "realserver.s3db" and If I change for mysql.sql I have this error:

 
Upvote 0 Downvote
Why you use file .sql you for created database need use .s3db and use SQLite Studio for create table
mysql.sql is only for phpmyadmin - SQL for Sqlite need use .s3db and import in SQLite Studio
 
Upvote 0 Downvote
Ye I have use Sqlite Studio for editing players ETC, but I want to make a web by importing the database in phpmyadmin etc etc
 
Upvote 0 Downvote
I have read like 20 tutorials like that, is very good explained, but I want to keep this server and you say I need the .s3db database for my Server, and I cant import that database into phpmyadmin, I have to import mysql.sql inside the schemas folder....

These are two different databases, isnt it? If I make changes in .s3db database, the mysql.sql will change them too?
 
Upvote 0 Downvote
Alright, Thats exactly what I have done. Checking .s3db didnt work in mysql I imported mysql.sql, but now how can I load that DATABASE in "Config.lua"???

Thanks!

- - - Updated - - -

Ok solved. Just you have to find your database in the mysql phpdirectory
 
Upvote 0 Downvote
Back
Top