天龙八部通用数据库db

软件简介：
! p4 Q1 ~) V4 H/ g天龙八部通用数据库db
4 {  t) [6 H+ A
ORa数据库导入方法
tl_gameuser.dmp
tlbb.dmp
先让放入到C盘
0 \' {! c, s, ], x0 y1.登陆Oracle配置地址：http://192.168.1.5:5560/isqlplus （192.168.1.5 为我的WIN机内网IP,你们请自行换成你们的外网或内网IP即可）
登陆时输入 用户：system 口令：iernei37d 连接标识符：orcldb （用户为默认，口令和连接标识符为你在安装Oracle时所设置的内容）
. w3 r! E7 w8 P+ p: s7 L
3 V! T2 [9 b6 |. m2.正常登陆配置地址后，首先输入以下命令创建3个用户（其中iernei37d为请改成您自己的密码）
create user tlbb IDENTIFIED BY iernei37d;
9 P7 A' I) D" n" h) m0 kcreate user tl_gameuser IDENTIFIED BY iernei37d;
. U/ [( j. R, ?! K. d4 C8 O2 V. lcreate user tlbb_read IDENTIFIED BY iernei37d;

3.分别给之前创建的3个用户设置角色权限和系统权限
8 ^8 i- [, l7 c; j( F; q--给TLBB用户设置角色权限和系统权限命令
-- Grant/Revoke role privileges
grant connect to TLBB;
. L' H, d2 {" jgrant resource to TLBB;
-- Grant/Revoke system privileges
' }0 Q5 s" L* [3 wgrant alter session to TLBB;
grant create cluster to TLBB;
  F' l  a0 M" I, U' F; X$ `7 Pgrant create database link to TLBB;
6 T5 o0 a& F  M1 h9 x1 t6 C2 t* b( c" Pgrant create sequence to TLBB;
grant create session to TLBB;
7 Y2 J4 ]$ d/ R1 l; _# A9 Jgrant create synonym to TLBB;
  N, H" K' A; b. X1 Q5 qgrant create table to TLBB;
grant create view to TLBB;
, F% e0 W  p7 o--给tl_gameuser用户设置角色权限和系统权限命令
, h4 \$ V) T3 W* A- e& V-- Grant/Revoke role privileges
grant connect to tl_gameuser;
grant resource to tl_gameuser;
. U0 D1 _! e! G$ X- h/ y5 i-- Grant/Revoke system privileges
grant alter session to tl_gameuser;
grant create cluster to tl_gameuser;
grant create database link to tl_gameuser;
7 Y% g/ F" d0 H& t" t/ _grant create sequence to tl_gameuser;
+ M3 h$ G! W5 R$ d' G6 U5 fgrant create session to tl_gameuser;
; U  R* d" N+ ?! \5 ]( x0 pgrant create synonym to tl_gameuser;
grant create table to tl_gameuser;
6 N! U$ ]' O$ W6 w! M* p: h* e; Ngrant create view to tl_gameuser;
7 ~+ f% \: ]# i( _. l9 A9 f- L--给tlbb_read用户设置角色权限和系统权限命令
-- Grant/Revoke role privileges
grant connect to tlbb_read;
& `  o. J; j- Cgrant resource to tlbb_read;
# ?/ d9 P; |, s8 W0 j8 {-- Grant/Revoke system privileges
grant alter session to tlbb_read;
grant create cluster to tlbb_read;
8 x4 A: R6 ?7 T( |. ?: rgrant create database link to tlbb_read;
grant create sequence to tlbb_read;
0 v/ {. p+ M0 r5 ~' Egrant create session to tlbb_read;
grant create synonym to tlbb_read;
grant create table to tlbb_read;
grant create view to tlbb_read;
4.退出Oracle命令执行页面后，开始导入tlbb.dmp 和 tl_gameuser.dmp 数据库
$ X+ Z! P1 Q+ J5 k$ y! @1 _4 ]首先把他们2个复制到C盘里。
+ A+ |' `5 }# R( k- s; Y点开始-运行-输入 CMD -回车
9 b/ Q) e& R; ^# N. v$ IImp tlbb/iernei37d@orcldb file=C:\tlbb.dmp ignore=y
注意：其中tlbb为之前命令所创建的用户名，iernei37d为之前安装Oracle时设置的密码，orcldb为创建的全局数据库名（用户名不变，密码和数据库名更换成你自己所设置的）
2 C: E% i+ _$ m6 m$ H& O& `执行完毕后会看到 成功终止导入, 没有出现警告。 即代表安装成功
# l1 T" @2 e7 s$ ZImp tl_gameuser/iernei37d@orcldb file=C:\tl_gameuser.dmp ignore=y
  x$ z. X( ~0 g/ F" C) L注意：其中tl_gameuser为之前命令所创建的用户名，iernei37d为之前安装Oracle时设置的密码，orcldb为创建的全局数据库名（用户名不变，密码和数据库名更换成你自己所设置的）
' X- G; K% j- Y9 |8 `# M执行完毕后会看到 成功终止导入, 没有出现警告。 即代表安装成功

! L5 R1 U+ C5 Y( R# m! O1 POK，配置Oracle的部分已完成。
导入MYSQL数据库命令如下：
导入之前请先把DBInit_0_31_0180_data_mysql.sqlDBInit_0_31_0180_table_mysql.sqltlbbdb_stat.sql3个文件放入到LINUX系统的HOME目录下然后首先输入命令
mysql -u root -p
[注：如果输入以上命令后提示-bash: mysql: command not found，解决方案为输入命令ln -s /usr/local/mysql-5.0.45/bin/mysql /usr/bin]
4 L/ [% ]  i# Z. K; G
) _% \/ ^- v# N" b3 \$ r' M然后依次
-----------------------------------------------------
: ?1 l* T2 g# a  @+ _6 juse mysql; update user set Password=PASSWORD('iernei37d') where User='root'; iernei37d为你要设置mysql管理员的密码
, ?- i) T/ g' ]4 @& a-----------------------------------------------------
5 O% n5 r' @2 Q3 n( Dinsert 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);
% f& {0 X8 ?; `-----------------------------------------------------
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);
" b; Q9 @- S& ?5 Y-----------------------------------------------------
# b+ b2 E$ I  b/ x2 i( Fflush privileges;
. N- t2 H4 i0 W. x' ?-----------------------------------------------------
- W$ h) Q- x8 Qcreate database tlbbdb;
-----------------------------------------------------
0 a. e  B) J; v) N( ~create database tlbbdb_stat;
-----------------------------------------------------
& z8 V6 h1 d8 Y5 Winsert 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');
9 q. R. I6 Q4 Y9 W% \) ^2 v-----------------------------------------------------
0 I) P0 F  f' uinsert 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');
-----------------------------------------------------
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');
6 G8 g9 E6 |+ p: _-----------------------------------------------------
; I9 P: @# y4 ]2 _GRANT ALL PRIVILEGES ON *.* TO tlbb@192.168.%.% IDENTIFIED BY iernei37d;
GRANT ALL PRIVILEGES ON *.* TO tlbbtools@192.168.%.% IDENTIFIED BY iernei37d;
& Y- y5 @2 E: M: U( |- l" yGRANT ALL PRIVILEGES ON *.* TO tlbbdb_stat@192.168.%.% IDENTIFIED BY iernei37d;
, m0 v! D4 ~# J- q退出mysql操作，输入命令 exit
& O+ I: [8 [6 b8 S7 W
最后导入数据库
& _/ N( g2 f" h1 `. O( {& a. o cd /home
mysql -uroot -piernei37d tlbbdb  DBInit_0_31_0180_table_mysql.sql; iernei37d为你的mysql root密码
( g( w" b1 o$ W 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数据库导入
* o" w0 T! S% e( X% L下载地址：

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

文件大小:

未知

下载次数:

0

下载权限:

版本vip会员

VIP专享 检测资源

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

VIP专享,点击开通vip

确认