Help! Running into issues when importing schema tables into mysql from Windows

Openfire Openfire Support
1

Using the Openfire Admin guide, I’m running the following command to import the schema tables from Openfire into mysql database and I get the error,

C:\program files\openfire\resources\database>** openfire_mysql.sql | mysql openfire;**

I get the following error:

‘mysql’ is not a recognized as an internal or external command, operable program or batch file.

any assistance is appreciated.

2

I can help. I have many external IM accounts you can use to contact me:

removed to protect my privacy

3

also if you just edit your openfire.xml file so the setup tag read false you can then use the server config to auto setup the tables for you. Start with a new empty MySQL catalog.

4

how did you make out?

5

Hi I’m having this same issue. Did you ever find a fix for this? Thanks!

6

Hi I"m having the same schema import issue on windows / mysql. do you haven any suggestions?