need to reset mysql

[macraigh]

I have screwed up countless and countless times trying to get a minilogin server up and running, and I think that now the reason it isn't working is because mysql has all these screw ups in it. Is there any way to totally reset mysql or uninstall it?

[johane]

Originally Posted by macraigh

I have screwed up countless and countless times trying to get a minilogin server up and running, and I think that now the reason it isn't working is because mysql has all these screw ups in it. Is there any way to totally reset mysql or uninstall it?

Hmmm...

It's pretty wierd to actually break MySQL. If you mean that your database is screwed, then you might want to drop it and re-initialise it. It all depends on if you've made many changes. On the assumption you havent made it work at all:


login to MySQL as root (or whatever the admin for windows is if you run MySQL on windows [boggle]). At the prompt type :

drop eqemu_database_whatever_its_name_is ;

create database eqemu_database_whatever_its_name_is ;

and then re-source the data like you did to set it up the first time.

Mind you, there should only be records in the variables table and the account table that relate to minilogin, so you might want to use ALTER, DELETE and INSERT queries to clear any data that is causing problems.

Johane

[macraigh]

Thanks much. I have everything sorted out now. I'm still not getting server working, but at least now I now where I'm at.