天龙八部通用数据库db

软件简介：
; ?1 ?4 h. w" o6 i天龙八部通用数据库db
, V- J. E, z% s2 z
ORa数据库导入方法
tl_gameuser.dmp
; ^7 G& g2 {& d' a2 \tlbb.dmp
! E6 ^! _, K+ P+ T先让放入到C盘
. H: G' {3 h- x. P$ d1.登陆Oracle配置地址：http://192.168.1.5:5560/isqlplus （192.168.1.5 为我的WIN机内网IP,你们请自行换成你们的外网或内网IP即可）
/ I  d9 _) V% m0 R; E6 i 登陆时输入 用户：system 口令：iernei37d 连接标识符：orcldb （用户为默认，口令和连接标识符为你在安装Oracle时所设置的内容）

; c- q+ ?% C* }1 p0 s2.正常登陆配置地址后，首先输入以下命令创建3个用户（其中iernei37d为请改成您自己的密码）
8 @+ t& A1 P$ Z6 c, j# {  |/ N3 t: L) Screate user tlbb IDENTIFIED BY iernei37d;
create user tl_gameuser IDENTIFIED BY iernei37d;
* z8 a* F6 E0 l: h. y/ Ocreate user tlbb_read IDENTIFIED BY iernei37d;
" R- T% j% o7 l( Z7 D/ n$ X- B
3.分别给之前创建的3个用户设置角色权限和系统权限
  e1 s' Y) c9 q# g. a! q--给TLBB用户设置角色权限和系统权限命令
( g0 g) j9 \6 v-- Grant/Revoke role privileges
grant connect to TLBB;
grant resource to TLBB;
-- Grant/Revoke system privileges
grant alter session to TLBB;
grant create cluster to TLBB;
grant create database link to TLBB;
grant create sequence to TLBB;
: w2 T% i; T/ h8 W* _9 |5 ]- f9 d) n5 egrant create session to TLBB;
grant create synonym to TLBB;
  ]2 t% W/ q) C  O3 c; r* b- ugrant create table to TLBB;
( n- Y0 g$ W# X  a6 M" Mgrant create view to TLBB;
& [9 a% {. S6 v' U--给tl_gameuser用户设置角色权限和系统权限命令
" L. f& B; m1 P* Y! M-- Grant/Revoke role privileges
grant connect to tl_gameuser;
" q# l# N  T9 q9 Bgrant resource to tl_gameuser;
* k+ x: F. B0 j- k-- Grant/Revoke system privileges
grant alter session to tl_gameuser;
, }, ?' q, y* f$ zgrant create cluster to tl_gameuser;
grant create database link to tl_gameuser;
grant create sequence to tl_gameuser;
grant create session to tl_gameuser;
grant create synonym to tl_gameuser;
, O. r! B/ N! ?grant create table to tl_gameuser;
grant create view to tl_gameuser;
--给tlbb_read用户设置角色权限和系统权限命令
: K6 S+ Y! k! E3 G" Z-- Grant/Revoke role privileges
& o4 [1 [. }7 y% K( l% {& tgrant connect to tlbb_read;
grant resource to tlbb_read;
-- Grant/Revoke system privileges
. }) n0 o- v+ Q  u0 |grant alter session to tlbb_read;
; o: J& p! }, N% ^. e" Fgrant create cluster to tlbb_read;
grant create database link to tlbb_read;
+ {3 W2 P3 b, W, d. ~4 Mgrant create sequence to tlbb_read;
  T" {, G1 I- Z1 `! Q' }+ T4 Egrant create session to tlbb_read;
$ M* v* m* v6 s" y" _, u4 bgrant create synonym to tlbb_read;
grant create table to tlbb_read;
grant create view to tlbb_read;
4.退出Oracle命令执行页面后，开始导入tlbb.dmp 和 tl_gameuser.dmp 数据库
首先把他们2个复制到C盘里。
  [3 F; G7 j3 A" T' x4 k" ]4 d% {点开始-运行-输入 CMD -回车
3 K5 t9 {  e& H: a# H& N% ]Imp tlbb/iernei37d@orcldb file=C:\tlbb.dmp ignore=y
+ i6 U% H; I" p! L. [) Y0 V注意：其中tlbb为之前命令所创建的用户名，iernei37d为之前安装Oracle时设置的密码，orcldb为创建的全局数据库名（用户名不变，密码和数据库名更换成你自己所设置的）
! m+ N* F. ?5 @& G% j; k& k' h执行完毕后会看到 成功终止导入, 没有出现警告。 即代表安装成功
, N9 _7 Q- Y3 K" I2 R2 [6 CImp tl_gameuser/iernei37d@orcldb file=C:\tl_gameuser.dmp ignore=y
+ r9 t" ^; F  f4 {1 a注意：其中tl_gameuser为之前命令所创建的用户名，iernei37d为之前安装Oracle时设置的密码，orcldb为创建的全局数据库名（用户名不变，密码和数据库名更换成你自己所设置的）
* w7 x; O  u3 F7 b执行完毕后会看到 成功终止导入, 没有出现警告。 即代表安装成功

OK，配置Oracle的部分已完成。
导入MYSQL数据库命令如下：
3 c! `3 B  R0 K5 `0 i6 b  V- f" T导入之前请先把DBInit_0_31_0180_data_mysql.sqlDBInit_0_31_0180_table_mysql.sqltlbbdb_stat.sql3个文件放入到LINUX系统的HOME目录下然后首先输入命令
mysql -u root -p
4 P) \  T4 j" E3 X7 C' q- H% J[注：如果输入以上命令后提示-bash: mysql: command not found，解决方案为输入命令ln -s /usr/local/mysql-5.0.45/bin/mysql /usr/bin]

8 e$ e* d- E( C. z' ^然后依次
-----------------------------------------------------
use mysql; update user set Password=PASSWORD('iernei37d') where User='root'; iernei37d为你要设置mysql管理员的密码
! E, k8 p5 w$ t( z* Z! I-----------------------------------------------------
4 J/ ^& ^9 ?) W" ~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);
-----------------------------------------------------
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.%.%', '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);
3 b" I4 P' S3 n-----------------------------------------------------
( Z* i3 D* }9 ^! o0 Kflush privileges;
-----------------------------------------------------
1 M4 T0 l& K8 \: m; t9 n) Lcreate database tlbbdb;
' ~8 k% f) h) p; w- E-----------------------------------------------------
create database tlbbdb_stat;
-----------------------------------------------------
* u9 p) w( E( o. einsert 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');
-----------------------------------------------------
$ G7 U4 v' ?1 l* x  |' finsert 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');
0 c& Y8 Z; E$ ]9 _-----------------------------------------------------
" L( U! V2 q" Y) q" Jinsert 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');
, T8 }. W* s; S. T) [9 h, o+ f5 o' s-----------------------------------------------------
! m# y9 h% o6 H+ |GRANT ALL PRIVILEGES ON *.* TO tlbb@192.168.%.% IDENTIFIED BY iernei37d;
8 T8 K& |$ g8 I2 rGRANT ALL PRIVILEGES ON *.* TO tlbbtools@192.168.%.% IDENTIFIED BY iernei37d;
GRANT ALL PRIVILEGES ON *.* TO tlbbdb_stat@192.168.%.% IDENTIFIED BY iernei37d;
8 g2 p  J2 L9 R# h  \$ S$ G退出mysql操作，输入命令 exit

最后导入数据库
cd /home
( N; l) c! @6 e, a' H 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密码
mysql -uroot -piernei37d tlbbdb_stat  tlbbdb_stat.sql; iernei37d为你的mysql root密码
完成mysql数据库导入
' [, Y4 N; l% w1 ~8 k4 ?下载地址：

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

下载权限:

版本vip会员

本地下载 检测资源   提取码: 需要终身vip或更高权限

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