天龙八部通用数据库db

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

4 A, l$ Z" `& c! E7 r" f; Y$ c. [1 WORa数据库导入方法
4 e% [  W5 q' E( J6 Z  L/ Qtl_gameuser.dmp
9 i" j' Y5 X* z) a& Q0 ^tlbb.dmp
先让放入到C盘
1.登陆Oracle配置地址：http://192.168.1.5:5560/isqlplus （192.168.1.5 为我的WIN机内网IP,你们请自行换成你们的外网或内网IP即可）
登陆时输入 用户：system 口令：iernei37d 连接标识符：orcldb （用户为默认，口令和连接标识符为你在安装Oracle时所设置的内容）

6 `9 U8 i# w* G- b/ `- z8 ?2.正常登陆配置地址后，首先输入以下命令创建3个用户（其中iernei37d为请改成您自己的密码）
create user tlbb IDENTIFIED BY iernei37d;
9 j& u: `. g7 x. u# Bcreate user tl_gameuser IDENTIFIED BY iernei37d;
6 ?8 n1 k  g, ]) c1 o* V& Mcreate user tlbb_read IDENTIFIED BY iernei37d;

3.分别给之前创建的3个用户设置角色权限和系统权限
$ J" ]" ]6 M4 L  Z- J/ L) S8 ]--给TLBB用户设置角色权限和系统权限命令
5 O$ c0 [2 c. T-- Grant/Revoke role privileges
grant connect to TLBB;
8 W  v9 @" |9 m( T7 v9 j+ Ngrant resource to TLBB;
, I' l, @5 X$ l& m-- Grant/Revoke system privileges
) i0 c: W+ a! S' z8 pgrant alter session to TLBB;
grant create cluster to TLBB;
grant create database link to TLBB;
% T3 I3 u- ]5 l9 ngrant create sequence to TLBB;
+ X7 p4 V  w7 ], I3 }& M" cgrant create session to TLBB;
7 Q! H# H6 F$ W4 e/ g+ Jgrant create synonym to TLBB;
: v& e: u. P! p$ A0 k2 rgrant create table to TLBB;
4 i" W. ?, {9 U. w( ~9 {+ G7 ]% \grant create view to TLBB;
--给tl_gameuser用户设置角色权限和系统权限命令
-- Grant/Revoke role privileges
grant connect to tl_gameuser;
grant resource to tl_gameuser;
-- Grant/Revoke system privileges
grant alter session to tl_gameuser;
grant create cluster to tl_gameuser;
grant create database link to tl_gameuser;
& E4 N" N. r' ?7 Z- p# r. l6 _grant create sequence to tl_gameuser;
" j1 C. c3 e; V- C1 i) z& u* ogrant create session to tl_gameuser;
3 j# G; t6 a5 S4 fgrant create synonym to tl_gameuser;
* Z5 ]+ Y; d" O' Sgrant create table to tl_gameuser;
grant create view to tl_gameuser;
--给tlbb_read用户设置角色权限和系统权限命令
-- Grant/Revoke role privileges
! l3 T2 u! A! I0 o% F1 t2 U# M* Egrant connect to tlbb_read;
grant resource to tlbb_read;
" x9 J- e  U' L5 K-- Grant/Revoke system privileges
  F  L. y$ R* d% O7 M+ l( Qgrant alter session to tlbb_read;
7 m& n, f+ c9 p  ?. A3 x9 }grant create cluster to tlbb_read;
; P; g3 H+ [8 }! @grant create database link to tlbb_read;
grant create sequence to tlbb_read;
8 z. [/ K7 [- v! s: mgrant create session to tlbb_read;
grant create synonym to tlbb_read;
1 @" F+ A( F( p0 L! ]4 P( Cgrant create table to tlbb_read;
grant create view to tlbb_read;
4.退出Oracle命令执行页面后，开始导入tlbb.dmp 和 tl_gameuser.dmp 数据库
首先把他们2个复制到C盘里。
( N! p% ?# C% s$ a点开始-运行-输入 CMD -回车
1 {) Q- c+ R& ~* ~- |$ mImp tlbb/iernei37d@orcldb file=C:\tlbb.dmp ignore=y
注意：其中tlbb为之前命令所创建的用户名，iernei37d为之前安装Oracle时设置的密码，orcldb为创建的全局数据库名（用户名不变，密码和数据库名更换成你自己所设置的）
( f, x: c- u0 u1 D执行完毕后会看到 成功终止导入, 没有出现警告。 即代表安装成功
, ~* D, u$ B/ b* RImp tl_gameuser/iernei37d@orcldb file=C:\tl_gameuser.dmp ignore=y
: W" B( x3 M  u+ P" f# @! i注意：其中tl_gameuser为之前命令所创建的用户名，iernei37d为之前安装Oracle时设置的密码，orcldb为创建的全局数据库名（用户名不变，密码和数据库名更换成你自己所设置的）
执行完毕后会看到 成功终止导入, 没有出现警告。 即代表安装成功
% x8 e" F( p3 z$ F5 z! G7 P- P4 y# B
. f& k6 `3 F) ~! C* yOK，配置Oracle的部分已完成。
! s3 [  U6 P. U导入MYSQL数据库命令如下：
* Y; b5 o# C3 _2 X导入之前请先把DBInit_0_31_0180_data_mysql.sqlDBInit_0_31_0180_table_mysql.sqltlbbdb_stat.sql3个文件放入到LINUX系统的HOME目录下然后首先输入命令
mysql -u root -p
4 l: T3 z9 J! y) [- w* ][注：如果输入以上命令后提示-bash: mysql: command not found，解决方案为输入命令ln -s /usr/local/mysql-5.0.45/bin/mysql /usr/bin]

, }5 z1 y3 D5 m4 W3 W然后依次
& B, J$ u2 Z9 M7 M& K-----------------------------------------------------
! m+ V5 p. x# O5 kuse mysql; update user set Password=PASSWORD('iernei37d') where User='root'; iernei37d为你要设置mysql管理员的密码
( X! d8 z5 b$ J5 c: F( ~1 p-----------------------------------------------------
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);
-----------------------------------------------------
* H; {8 e9 |: |. qinsert 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);
-----------------------------------------------------
4 O7 i; D3 i; v, }- T) _flush privileges;
/ i( M3 l5 `+ ?8 N( Q, W, K+ m+ w-----------------------------------------------------
create database tlbbdb;
-----------------------------------------------------
create database tlbbdb_stat;
-----------------------------------------------------
; t& ^! F! a- H2 {" W% c. b3 \& Pinsert 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');
! N, X- o7 L+ W  f, }# r+ U-----------------------------------------------------
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');
# Z2 _9 m7 r, I3 Z-----------------------------------------------------
9 a! \2 G- H* l& Dinsert 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');
* o. S7 v; U! k# w& _( E-----------------------------------------------------
, v; P2 P3 ?" @. |+ ^; R# K  pGRANT ALL PRIVILEGES ON *.* TO tlbb@192.168.%.% IDENTIFIED BY iernei37d;
& n; T' J7 b0 l5 F9 C& F% RGRANT ALL PRIVILEGES ON *.* TO tlbbtools@192.168.%.% IDENTIFIED BY iernei37d;
GRANT ALL PRIVILEGES ON *.* TO tlbbdb_stat@192.168.%.% IDENTIFIED BY iernei37d;
6 X1 b' E8 J1 b# r( U- h1 }/ p退出mysql操作，输入命令 exit
, E* Q4 |- X- H2 j1 F* ^" l
; e7 u4 b; j1 v最后导入数据库
3 b) P" ]# k0 }: ~ cd /home
% a8 R9 A2 V1 l# j: T! L! I mysql -uroot -piernei37d tlbbdb  DBInit_0_31_0180_table_mysql.sql; iernei37d为你的mysql root密码
) p* f* \, G( i; [/ G. [ 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数据库导入
* l. t# O# ~, v: P1 n) H* f/ q) @( x下载地址：

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

下载权限:

版本vip会员

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

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