Cách chép .sql vào server??

[vuhuy99v]

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]

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]

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|]

Ý 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]

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]

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]

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]

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: [unixODBC][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)
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]

Có ai giúp mình sửa lỗi này ko dzậy trùi T_T

[freelancer]

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: [unixODBC][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)
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 =