PDA

View Full Version : Cách chép .sql vào server??


vuhuy99v
06-11-11, 09:47 PM
Cho mình hỏi h mình có bộ.sql thì cách nào để mình chép vào Server
Rùi cho mình hỏi cách nào để làm web(Vì mình làm ko đc thấy nó rắc rối wá)
note87
06-11-11, 11:05 PM
SQL server được tích hợp sẵn rồi. mà hơn nữa chạy web thì cài tại máy thật hay ảo đều ok mà.
mình thấy trước HD có bài Hướng dẫn rồi, nhưng khi chuyển qua room mới thì bị move đi đâu thì không biết :) chờ coi có ai HD không hoặc tìm lại trên google xem chắc vẫn lưu bản sao clbgames trong kho dữ liệu của nó. :))
Không thấy thì add bằng tay cho lành.
huuduyen_05
06-11-11, 11:07 PM
Câu hỏi của bạn mập mờ quá...không hiểu là đang hỏi về cách import file sql vào mysql ? hay là gì ?
|Rick|
06-11-11, 11:14 PM
Ý bạn ấy là import *.sql vào mysql đấy
=> Không hiểu 1 tý gì về sql sao mà cài website :|
heybaby2707
06-11-11, 11:19 PM
SQL học để hiểu sâu thì khó chứ học để làm web hay private cơ bản thì cũng nhanh thôi! Bạn tra google nhiều tài liệu lắm chứ cái này hỏi không kiếm đc nhiều thông tin bằng vừa đọc vừa làm đâu!
vuhuy99v
06-11-11, 11:50 PM
chiện đó sang 1 bên nhe.Các bạn và anh HD xem giúp mình file serverinfo.ini của mình đã chỉnh đúng chưa sao nó cứ báo lỗi ko kết nối đc.Mình dùng IP:192.168.1.3.Ko bik có
sai sót gì mong anh em giúp đỡ.

[Mother]
IP=192.168.1.3
Port=1014

[World]
IP=192.168.1.3
Port=777

[Billing]
Number=1
IP0=192.168.1.3
Port0=15680
IP1=0.0.0.0
Port1=10101
IP2=0.0.0.0
Port2=10101
IP3=0.0.0.0
Port3=10101
IP4=0.0.0.0
Port4=10101

[Proxy]
Proxy0ForCncUser=127.0.0.1
;Proxy1ForCncUser=127.0.0.1
Proxy0ForCtcUser=127.0.0.1
;Proxy1ForCtcUser=127.0.0.1
Proxy0ForEduUser=127.0.0.1
;Proxy1ForEduUser=127.0.0.1

[Server0]
ServerID=0
MachineID=0
IP0=192.168.1.3
Port0=3731
IP1=192.168.1.3
Port1=8880
Type=0
IP(CNC)= 0.0.0.0
Port(CNC)=1000
IP(CTC)=0.0.0.0
Port(CTC)=0
IP(EDU)= 0.0.0.0
Port(EDU)=1000
HumanSMKey=1001
PlayShopSMKey=4001
ItemSerialKey=7001
CommisionShopKey=6001
EnableShareMem=1

[Server1]
ServerID=2
MachineID=0
IP0=192.168.1.3
Port0=90
IP1=192.168.1.3
Port1=8882
Type=1
IP(CNC)= 0.0.0.0
Port(CNC)=1000
IP(CTC)=0.0.0.0
Port(CTC)=0
IP(EDU)= 0.0.0.0
Port(EDU)=1000
HumanSMKey=1003
PlayShopSMKey=4003
ItemSerialKey=7003
CommisionShopKey=6003
EnableShareMem=0
huuduyen_05
07-11-11, 08:42 AM
Về cơ bản thì config như vậy không thấy gì sai, tuỳ theo nó báo lỗi kiểu gì thì mới biết sai chỗ nào được.
vuhuy99v
07-11-11, 10:15 AM
Em ko bik day la loi gi nua:
Login_fix

DBThread::mCharDBInterface->Connect() Get Errors: [unixODBC][Driver Manager]Invalid string or buffer length,TID = -1673606240,ErrorCode =0 (-1673606240)(T0=2011-11-7_10:14:11 T1=81.0110)
DBThread g_DBConnectThread = 0 IGNORE reconnect database,TID=-1610667104 (-1610667104)(T0=2011-11-7_10:14:11 T1=81.0120)
DBThread::mCharDBInterface->Connect() Get Errors: [unixODBC][Driver Manager]Invalid string or buffer length,TID = -1736545376,ErrorCode =0 (-1736545376)(T0=2011-11-7_10:14:11 T1=80.9980)
Send LOGIN_SERVER state=LNOTIFY_BILLING_DISCONNECT to World...OK (-1369400416)(T0=2011-11-7_10:14:13 T1=82.3550)
ERROR: ConnectBillingServer( ) Pos:0 IP:192.168.1.3 Port:15680 ServerID:2 ...Faile (-1369400416)(T0=2011-11-7_10:14:13 T1=82.5620)
Send LOGIN_SERVER state=LNOTIFY_BILLING_DISCONNECT to World...OK (-1369400416)(T0=2011-11-7_10:14:15 T1=84.5640)
ERROR: ConnectBillingServer( ) Pos:0 IP:192.168.1.3 Port:15680 ServerID:2 ...Faile (-1369400416)(T0=2011-11-7_10:14:15 T1=84.8090)
DBThread::mCharDBInterface->Connect() Get Errors: [Driver Manager]Invalid string or buffer length,TID = -1589687392,ErrorCode =0 (-1589687392)(T0=2011-11-7_10:14:16 T1=85.9960)
DBThread::mCharDBInterface->Connect() Get Errors: [unixODBC][Driver Manager]Invalid string or buffer length,TID = -1568707680,ErrorCode =0 (-1568707680)(T0=2011-11-7_10:14:16 T1=85.9970)

World_fix


ServerManager::AcceptNewConnection(SOCKET:4,IP=192 .168.1.3)...OK (-1208599904)(T0=2011-11-7_10:13:22 T1=43.1380)
ServerManager::AcceptNewConnection(SOCKET:-1,IP=,Step:15)...OK (-1208599904)(T0=2011-11-7_10:13:22 T1=43.1420)
[U]SendPacket! ID=287 (-1208599904)(T0=2011-11-7_10:13:24 T1=45.3080)
SSConnectHandler...ServerID=2 (-1208599904)(T0=2011-11-7_10:13:24 T1=45.3350)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:24 T1=45.3350)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:27 T1=47.4690)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:29 T1=49.5980)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:31 T1=51.8010)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:33 T1=54.0400)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:35 T1=56.2250)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:38 T1=58.4830)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:40 T1=60.7340)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:42 T1=62.9050)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:44 T1=65.1450)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:46 T1=67.3310)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:49 T1=69.5230)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:51 T1=71.7650)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:53 T1=73.9730)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:55 T1=76.1390)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:57 T1=78.3710)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:0 T1=80.5930)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:2 T1=82.7510)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:4 T1=85.1030)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:6 T1=87.2950)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:9 T1=89.5460)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:11 T1=91.7960)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:13 T1=94.0080)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:15 T1=96.2440)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:18 T1=98.5130)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:20 T1=100.7520)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:22 T1=102.9420)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:24 T1=105.1270)
[1111071014] m_pSocketInputStream->Fill ret:-8 EWOULDBLOCK (-1208599904)(T0=2011-11-7_10:14:26 T1=107.3470)
ServerManager::RemovePlayer(PID:0 ServerID=2) Login...OK (-1208599904)(T0=2011-11-7_10:14:26 T1=107.3480)
vuhuy99v
08-11-11, 01:14 AM
Có ai giúp mình sửa lỗi này ko dzậy trùi T_T
freelancer
08-11-11, 03:09 AM
Em ko bik day la loi gi nua:
Login_fix

DBThread::mCharDBInterface->Connect() Get Errors: [unixODBC][Driver Manager]Invalid string or buffer length,TID = -1673606240,ErrorCode =0 (-1673606240)(T0=2011-11-7_10:14:11 T1=81.0110)
DBThread g_DBConnectThread = 0 IGNORE reconnect database,TID=-1610667104 (-1610667104)(T0=2011-11-7_10:14:11 T1=81.0120)
DBThread::mCharDBInterface->Connect() Get Errors: [unixODBC][Driver Manager]Invalid string or buffer length,TID = -1736545376,ErrorCode =0 (-1736545376)(T0=2011-11-7_10:14:11 T1=80.9980)
Send LOGIN_SERVER state=LNOTIFY_BILLING_DISCONNECT to World...OK (-1369400416)(T0=2011-11-7_10:14:13 T1=82.3550)
ERROR: ConnectBillingServer( ) Pos:0 IP:192.168.1.3 Port:15680 ServerID:2 ...Faile (-1369400416)(T0=2011-11-7_10:14:13 T1=82.5620)
Send LOGIN_SERVER state=LNOTIFY_BILLING_DISCONNECT to World...OK (-1369400416)(T0=2011-11-7_10:14:15 T1=84.5640)
ERROR: ConnectBillingServer( ) Pos:0 IP:192.168.1.3 Port:15680 ServerID:2 ...Faile (-1369400416)(T0=2011-11-7_10:14:15 T1=84.8090)
DBThread::mCharDBInterface->Connect() Get Errors: [Driver Manager]Invalid string or buffer length,TID = -1589687392,ErrorCode =0 (-1589687392)(T0=2011-11-7_10:14:16 T1=85.9960)
DBThread::mCharDBInterface->Connect() Get Errors: [unixODBC][Driver Manager]Invalid string or buffer length,TID = -1568707680,ErrorCode =0 (-1568707680)(T0=2011-11-7_10:14:16 T1=85.9970)

World_fix


ServerManager::AcceptNewConnection(SOCKET:4,IP=192 .168.1.3)...OK (-1208599904)(T0=2011-11-7_10:13:22 T1=43.1380)
ServerManager::AcceptNewConnection(SOCKET:-1,IP=,Step:15)...OK (-1208599904)(T0=2011-11-7_10:13:22 T1=43.1420)
[U]SendPacket! ID=287 (-1208599904)(T0=2011-11-7_10:13:24 T1=45.3080)
SSConnectHandler...ServerID=2 (-1208599904)(T0=2011-11-7_10:13:24 T1=45.3350)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:24 T1=45.3350)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:27 T1=47.4690)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:29 T1=49.5980)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:31 T1=51.8010)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:33 T1=54.0400)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:35 T1=56.2250)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:38 T1=58.4830)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:40 T1=60.7340)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:42 T1=62.9050)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:44 T1=65.1450)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:46 T1=67.3310)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:49 T1=69.5230)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:51 T1=71.7650)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:53 T1=73.9730)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:55 T1=76.1390)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:13:57 T1=78.3710)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:0 T1=80.5930)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:2 T1=82.7510)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:4 T1=85.1030)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:6 T1=87.2950)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:9 T1=89.5460)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:11 T1=91.7960)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:13 T1=94.0080)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:15 T1=96.2440)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:18 T1=98.5130)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:20 T1=100.7520)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:22 T1=102.9420)
LWNotifyUserHandler...LNOTIFY_BILLING_DISCONNECT received, abandon all prize! (-1208599904)(T0=2011-11-7_10:14:24 T1=105.1270)
[1111071014] m_pSocketInputStream->Fill ret:-8 EWOULDBLOCK (-1208599904)(T0=2011-11-7_10:14:26 T1=107.3470)
ServerManager::RemovePlayer(PID:0 ServerID=2) Login...OK (-1208599904)(T0=2011-11-7_10:14:26 T1=107.3480)

Vấn đề này là không kết nối được mysql. Bạn kiểm tra lại nội dung của file /etc/odbc.ini xem có giống như sau không ?



[tlbbdb]
Driver = /usr/lib/libmyodbc5.so
Description = MyODBC 5 Driver DSN
SERVER = 192.168.1.3
PORT = 3306
USER = tlbb
Password = tlbb1234
Database = tlbbdb
OPTION = 3
SOCKET =
BMK
08-11-11, 09:04 AM
Cũng tùy theo các port của bản server mở port nào và billing & world port nào.
vuhuy99v
08-11-11, 10:03 AM
cho mình hỏi làm thế nào để bik sv cần mở port nào?
Mình đang cài bản 7 skill, 4 lỗ của anh HD ấy.Làm tới đó thì bị đứng lun.