INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Reinstallation Issues

Reinstallation Issues

(OP)
I had to reinstall Windows the other day and am getting the development server WAMP working again but have been having no end of trouble with MySQL. Apparently it saves two different copies of my.ini: one in the previous folder of the database folder and another in the installation folder. No matter what path I give it in the Workbench Server Administration to point to the existing databases, it wants to add a subfolder of "data" to it. When I look in the my.ini in the application folder, it has the correct path but nothing else; the copy if the database folder as the entire my.ini but has the /data/ appended to the path. It's like Workbench is saving one copy but MySQL is reading another.

Having said that and removing the improper folder name, it now sees the databases but two of them have the name prepended with #mysql50# even though it had before, and has now, v5.5 installed. How can I restore the proper names to these two databases? There are a number of databases but only two are misnamed in this way. It's not as though I'm a newbie - I've installed MySQL countless times in the past but never had such odd issues before.

Thank you!

RE: Reinstallation Issues

Does the error log say something? The funny names seem like error situations to me. Anyway, renaming and repairing should fix this. Off course, it is good to run ANALYZE TABLE on them first and run the backup.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)

RE: Reinstallation Issues

(OP)
That's a good question. Oddly, even though I installed only v 5.5, there are log files from last night in C:\ProgramData\MySQL\MySQL Server 5.1 but they appear to be in a binary format. There IS a folder for C:\ProgramData\MySQL\MySQL Server 5.5 but it shows logs from two days ago when I first tried installing v5.5 and the logs are also apparently binary. I don't even have a downloaded version of 5.1 but I noticed in my earlier attempts to install that a setting was looking in the v5.1 folder and had to be reselected to see the v5.5 folder.

These rather odd multiple locations for files seem to reflect the multiple my.ini locations so possibly there is a bug in the installer, perhaps something that wasn't updated from a previous version.

I just noticed that the Workbench Configuration File setting is pointing to C:\Program Files\MySQL\MySQL Server 5.5\my.ini but changing the my.ini there seems to do nothing while changing the copy that it created under the data folders does affect changes.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close