powered by Jive Software

Problem creating db on mysql on Windows

can someone help regarding on this issue?

I installed Mysql4.1 and openfire, along with spark client on my windows machine(essentially a server now)

i need help with step by step guide for creating a db on mysql on mysql client

i did mysql> create database openfire;

it updated 1 row or something

than when i was trying to do:

Windows: type openfire_mysql.sql | mysql [databaseName];

openfire_mysql.sql | mysql openfire;

im getting the following error:

mysql> openfire_mysql.sql | mysql openfire;

No connection. Trying to reconnect…

ERROR 2005 (HY000): Unknown MySQL server host ‘|’ (11001)

on setup tool: DB SETTINGS

error log file:

2012.07.26 14:28:49 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.UnknownHostException

MESSAGE: [host-name]

STACKTRACE:

java.net.UnknownHostException: [host-name]

at java.net.InetAddress.getAllByName(Unknown Source)

at java.net.InetAddress.getAllByName(Unknown Source)

at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:246)

at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)

at com.mysql.jdbc.Connection.(Connection.java:1555)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

** END NESTED EXCEPTION **

com.mysql.jdbc.Driver

jdbc:mysql://localhost:3306/openfire

PLS HELP!!!