mySQL error

General discussion about netjukebox
Post Reply
highmighty
User
Posts: 19
Joined: Thu Apr 28, 2005 6:58 pm
Location: Montreal, QUEBEC
Contact:

mySQL error

Post by 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
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by 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 :wink:

Willem
highmighty
User
Posts: 19
Joined: Thu Apr 28, 2005 6:58 pm
Location: Montreal, QUEBEC
Contact:

Post by 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
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post by 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
User
Posts: 19
Joined: Thu Apr 28, 2005 6:58 pm
Location: Montreal, QUEBEC
Contact:

Post by 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
Post Reply