MySQL data files

someone moved them!

[grandpa]

I think I may have discovered the root cause for our MySQL server crash over the summer. A recent problem with Norton AV, and the steps to fix that problem, somehow ended up with the MySQL service no longer working. I'm not sure how or why yet, I just know that I had to reinstall the Service (Windows 2000) after I got the AV reinstalled.

Now I have a simple problem, but I haven't been able to track it down. I'm hopeful that someone can hand me the solution on this one... I cannot seem to get my datafile path set to the previous database location. In the my.ini file I have set this parameter:

datadir="D:/MySQL/bin/bin/data/"

My database files are located in that data directory. However, with that setting the service will not run. It starts and then stops.

If I move the datadir back one directory the service will run, but the database files are not the right ones.

I've probably overlooked something simple, what was it? The system path information is correct, and I'm reading the correct ini file.

Thanks.

[coopster]

Which version of MySQL did you load?

[grandpa]

Ver 5.0. Would this be related to my permissions or users table?

[Anyango]

This isn't a reason of why it is doing so but this could well be a solution to that .

That said, If i would be you and if i wasnt able to find reason for this , i would do this. Make a new installation of MySQL right now let it have default data directory and don't change its value in ini file then move your existing data files from your previous installation , which i guess are in

"D:/MySQL/bin/bin/data/"

to the data folder of the new installation.

Simple as that ;)

[grandpa]

I don't know which came first, the chicken or the egg. Right now I dont even care!

Norton AntiVirus crashed, and I'm guessing that it took the MYSQL service with it. After 5 days of screwing with Norton and never getting it to work correctly, its been removed, permanantly, completely, and forever.

Which bring me to MySQL.

I was using Ver 4.0.1 and tried to upgrade to Ver 5.0.

At this time I cannot run MySQL, or install it as a service. That's either version.

I'm at the end of this rope! Any suggestions?

[grandpa]

Nevermind. I just took an axe to the old PC.

Time to start over.

[Anyango]

why to start over? take your mysql data folder along as well and all your databases will be there into your second pc, wont that be good?

[grandpa]

Anyango, did you read what I posted? I thought not.

MySQL cannot be installed as a service, and it will not run as a stand alone. I'll move the data files anywhere you suggest, it won't matter, because MySQL is not functioning.