JIVE用MYSQL数据库的问题(菜鸟级)

03-07-02 drgoo

JIVE的安装步骤:

1.数据库安装,database目录中选择对应数据库如jive_mysql.sql

在你数据库服务器上建立数据库名Jive 导入jive_mysql.sql

请问该怎样将jive_mysql.sql导入到我的MYSQL中呢~~

我在DOS下进入mysql命令行模式用什么命令才能实现呢

bmw008
2003-07-02 20:32

有\.这个命令

mysql>use jive;//进入jive库

mysql>\. c:\Jive_mysql.sql//假设你的sql文件在c盘

但我在windows下试总说执行文件出错,我就把源代码拷进去执行

如:

mysql>use jive;

mysql>create table……;回车,一样可以建表!

在linux下就不会报那个错,但我在jive安装设置界面,到测试数据库连接

时,报错:数据库连接不能建立。打开日志文件"jiveHome\logs\

DefaultConnectionProvider.log" 查看错误信息然后返回修正错误。

DefaultConnectionProvider.log内容如下:

Starting ConnectionPool:

dbDriver = org.gjt.mm.mysql.Driver

dbServer = jdbc:mysql://localhost/jive

dbLogin = root

log file = /opt/tomcat/webapps/jive/WEB-INF/jiveHome/logs/DefaultConnectionProvider.log

minconnections = 3

maxconnections = 10

Total refresh interval = 0.5 days

-----------------------------------------

--->Attempt (1 of 5) failed to create new connections set at startup:

java.sql.SQLException: Invalid authorization specification: Access denied for user: 'root@BMW' (Using password: YES)

Will try again in 10 seconds...

--->Attempt (2 of 5) failed to create new connections set at startup:

java.sql.SQLException: Invalid authorization specification: Access denied for user: 'root@BMW' (Using password: YES)

Will try again in 10 seconds...

--->Attempt (3 of 5) failed to create new connections set at startup:

java.sql.SQLException: Invalid authorization specification: Access denied for user: 'root@BMW' (Using password: YES)

Will try again in 10 seconds...

--->Attempt (4 of 5) failed to create new connections set at startup:

java.sql.SQLException: Invalid authorization specification: Access denied for user: 'root@BMW' (Using password: YES)

Will try again in 10 seconds...

All attempts at connecting to Database exhausted

还请高手指点!!!!感谢!!!

lodi
2003-07-02 21:24

C:\mysql\bin\>mysql

mysql>create database jive

mysql>exit

修改jive_mysql.sql,加入在第一行

use jive

......

......

c:\mysql\bin\>mysql < jive_mysql.sql

C:\mysql\bin\>mysql

mysql>use jive

mysql>show tables

可以看到所有的表了

drgoo
2003-07-04 10:31

行了,太感谢两位了~~

楚天一笑
2003-07-06 20:56

我按照楼上大侠的方法,在Jive_mysql.sql中增加了一行

use Jive;

然后打开mysql.exe

mysql>Jive_mysql.sql

mysql>\g

却提示说第一行出错

请问这是怎么回事(菜菜的问)

2Go 1 2 下一页