mySQL error

[highmighty]

Hi Willem,

I screwed up, I deleted the content of the /DATA folder under mySQL folder which contained two folders: mysql & netjukebox. I did that because I wanted a "clean" install of 3.76...

Now I'm, of course, getting this error: Can't connect to MySQL server on:
localhost.

Also, here's what's in the Event log: Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

So how do I repair this mySQL issue without re-installing it?

Thanks!

highmighty

[wbartels]

The data directory also contains all the MySQL privileges.
1) I thinks the easiest way is to reinstall MySQL on the same directory.
2) Start netjukebox, it will automatically create a new database.
(of course you now have lost all the settings in the database: favorites, httpQ configuration, Images, etc...)

The next time you don't have to do anything with the database.
netjukebox will detect an "old netjukebox database" and incremental update when needed.

Good luck with the recovery

Willem

[highmighty]

Ok I did reinstall mySQL... but here's another error in getting while accessing netjukebox:

MySQL update error
Incremental upgrade is not supported from this database version.

* Delete your old database.
* On the next start netjukebox automatic creates a new MySQL database and table structure.


What's next?

Thanks!
highmighty

[wbartels]

I think you have deleted a portion of the netjukebox database.
This is how to recover:

Start the command promt (I asume you have windows)
1) click on Start > Run
2) type: cmd <enter>
3) type: net stop mysql <enter>
4) remove now only the directory ...\mysql\data\netjukebox
5) type: net start mysql <enter>
6) start netjukebox

Good luck

[highmighty]

Thanks Willem, that's what I did also, I deleted only the 'netjukebox' folder this time and it worked!

I screwed up earlier because I didn't remember how I was "cleaning" it in the past... now it makes sense, I remember, it's this only folder I was deleting

Thanks a bunch!

highmighty