天龙八部通用数据库db

软件简介：
天龙八部通用数据库db

3 ^, ^8 M5 i+ D" g4 B/ LORa数据库导入方法
( z$ U& [4 r) a6 h8 p4 Ktl_gameuser.dmp
tlbb.dmp
先让放入到C盘
) U8 k3 m7 n: L1 R/ }0 C) B1.登陆Oracle配置地址：http://192.168.1.5:5560/isqlplus （192.168.1.5 为我的WIN机内网IP,你们请自行换成你们的外网或内网IP即可）
0 Q" u: S" k8 l2 H8 m 登陆时输入 用户：system 口令：iernei37d 连接标识符：orcldb （用户为默认，口令和连接标识符为你在安装Oracle时所设置的内容）
- Q: Y7 ^$ y1 U, J6 _# U
3 z& Y: K5 g9 t2.正常登陆配置地址后，首先输入以下命令创建3个用户（其中iernei37d为请改成您自己的密码）
! k. g& O# B$ o* M1 Tcreate user tlbb IDENTIFIED BY iernei37d;
, U1 d* R: z4 a' H$ xcreate user tl_gameuser IDENTIFIED BY iernei37d;
create user tlbb_read IDENTIFIED BY iernei37d;
" S- b  `6 a, p6 Z! w( K5 h3 ?
3.分别给之前创建的3个用户设置角色权限和系统权限
8 R* D, j9 U4 A; m--给TLBB用户设置角色权限和系统权限命令
" w9 t  A5 v5 Q6 y& V-- Grant/Revoke role privileges
7 E, B8 ?& p: _" m# L3 Vgrant connect to TLBB;
grant resource to TLBB;
-- Grant/Revoke system privileges
grant alter session to TLBB;
( l2 J: s1 L; R$ ^grant create cluster to TLBB;
8 [$ l2 A1 A/ |) k; l1 M# m$ Q  Agrant create database link to TLBB;
+ N) Q7 @5 J( R$ ^grant create sequence to TLBB;
grant create session to TLBB;
grant create synonym to TLBB;
4 j- c" p; s) l, K2 O' tgrant create table to TLBB;
9 S& N* H$ g1 X- n: ?# p; Sgrant create view to TLBB;
--给tl_gameuser用户设置角色权限和系统权限命令
-- Grant/Revoke role privileges
- I( K4 j+ M7 v7 N6 t' A* A3 ggrant connect to tl_gameuser;
grant resource to tl_gameuser;
-- Grant/Revoke system privileges
7 R4 i4 A# o& Y( b5 Ngrant alter session to tl_gameuser;
grant create cluster to tl_gameuser;
grant create database link to tl_gameuser;
' E; W  [# W$ ~8 u! K6 a" kgrant create sequence to tl_gameuser;
grant create session to tl_gameuser;
grant create synonym to tl_gameuser;
grant create table to tl_gameuser;
3 Z" \( Y* b. T; |grant create view to tl_gameuser;
--给tlbb_read用户设置角色权限和系统权限命令
-- Grant/Revoke role privileges
' d6 i% Q$ y9 j/ x. e: Bgrant connect to tlbb_read;
( L; q' f  p* `" D8 Agrant resource to tlbb_read;
-- Grant/Revoke system privileges
; K! `9 Z5 r+ i' [; v8 k8 H  Qgrant alter session to tlbb_read;
. S5 P: N9 m2 C" Rgrant create cluster to tlbb_read;
grant create database link to tlbb_read;
+ |. i) X9 ~) Wgrant create sequence to tlbb_read;
6 V5 n5 s3 r+ G: P# a; ^4 z& g  r% dgrant create session to tlbb_read;
3 P* M) S2 F2 o: W& h" b2 Qgrant create synonym to tlbb_read;
grant create table to tlbb_read;
! k& i1 ^, M# T. Bgrant create view to tlbb_read;
" Q+ [) h& a( [3 q& s4.退出Oracle命令执行页面后，开始导入tlbb.dmp 和 tl_gameuser.dmp 数据库
( g! B  w: A5 H- ?& N6 w; d3 o6 e7 t首先把他们2个复制到C盘里。
点开始-运行-输入 CMD -回车
Imp tlbb/iernei37d@orcldb file=C:\tlbb.dmp ignore=y
注意：其中tlbb为之前命令所创建的用户名，iernei37d为之前安装Oracle时设置的密码，orcldb为创建的全局数据库名（用户名不变，密码和数据库名更换成你自己所设置的）
执行完毕后会看到 成功终止导入, 没有出现警告。 即代表安装成功
  g& @) a+ |6 B) `+ w! z" y! s" W# ZImp tl_gameuser/iernei37d@orcldb file=C:\tl_gameuser.dmp ignore=y
8 J$ }  w+ e& ?& H  Z注意：其中tl_gameuser为之前命令所创建的用户名，iernei37d为之前安装Oracle时设置的密码，orcldb为创建的全局数据库名（用户名不变，密码和数据库名更换成你自己所设置的）
. }( R7 Q+ w* A! K% T5 i+ W执行完毕后会看到 成功终止导入, 没有出现警告。 即代表安装成功
4 V7 j8 e- @0 f
OK，配置Oracle的部分已完成。
导入MYSQL数据库命令如下：
导入之前请先把DBInit_0_31_0180_data_mysql.sqlDBInit_0_31_0180_table_mysql.sqltlbbdb_stat.sql3个文件放入到LINUX系统的HOME目录下然后首先输入命令
9 ~: u) A- H  M/ o0 Fmysql -u root -p
- v* Q& u1 a/ f7 r, c[注：如果输入以上命令后提示-bash: mysql: command not found，解决方案为输入命令ln -s /usr/local/mysql-5.0.45/bin/mysql /usr/bin]

, `* s6 W/ z: H* D; s' a然后依次
% {- i% S5 @- v' p/ y-----------------------------------------------------
6 C3 D# w2 z6 ]5 ]2 g' Nuse mysql; update user set Password=PASSWORD('iernei37d') where User='root'; iernei37d为你要设置mysql管理员的密码
-----------------------------------------------------
insert into mysql.user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Create_user_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions, max_updates, max_connections, max_user_connections) value ('192.168.%.%', 'tlbb', 'iernei37d', 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);
-----------------------------------------------------
" ?4 D; Y$ s+ _) d- linsert into mysql.user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Create_user_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions, max_updates, max_connections, max_user_connections) value ('192.168.%.%', 'tlbbtools', 'iernei37d', 'Y','Y','Y','Y','N','Y','N','N','N','N','N','Y','Y','N','N','N','Y','N','Y','N','N','Y','Y','N','N','N','','','','',0,0,0,0);
-----------------------------------------------------
flush privileges;
-----------------------------------------------------
; E7 [1 i, W& D: L: d- Hcreate database tlbbdb;
-----------------------------------------------------
: y5 E- @6 r* Icreate database tlbbdb_stat;
: \3 H7 j8 x8 L' c' }-----------------------------------------------------
9 @$ X6 v8 A) E2 r! ?1 Vinsert into mysql.db ( Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv) value( '192.168.%.%', 'tlbbdb','tlbb', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
-----------------------------------------------------
insert into mysql.db ( Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv) value( '192.168.%.%', 'tlbbdb','tlbbtools', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'Y');
; J; {* O' K6 Q3 Y3 p6 J: D-----------------------------------------------------
insert into mysql.db ( Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv) value( '192.168.%.%', 'tlbbdb_stat','tlbb', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
-----------------------------------------------------
GRANT ALL PRIVILEGES ON *.* TO tlbb@192.168.%.% IDENTIFIED BY iernei37d;
  q! @$ v; J# U/ N& V, c' ?+ pGRANT ALL PRIVILEGES ON *.* TO tlbbtools@192.168.%.% IDENTIFIED BY iernei37d;
GRANT ALL PRIVILEGES ON *.* TO tlbbdb_stat@192.168.%.% IDENTIFIED BY iernei37d;
退出mysql操作，输入命令 exit
( G! i& |! b. t% p% _4 O
最后导入数据库
cd /home
! D# P; w* `: y& P% J0 A* a mysql -uroot -piernei37d tlbbdb  DBInit_0_31_0180_table_mysql.sql; iernei37d为你的mysql root密码
mysql -uroot -piernei37d tlbbdb  DBInit_0_31_0180_data_mysql.sql; iernei37d为你的mysql root密码
& x4 t9 s# T% k8 D! Z mysql -uroot -piernei37d tlbbdb_stat  tlbbdb_stat.sql; iernei37d为你的mysql root密码
完成mysql数据库导入
$ y" S* J8 ~8 s$ ^5 K# z下载地址：

2011-9-27 18:59 上传 天龙八部通用数据库db.rar

下载权限:

版本vip会员

本地下载 检测资源

有些游戏资源需要vip下载开通请点击开通vip