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!!!