Mysql Query Browser and Mysql Administrator Issue

Posted on 2011-05-07
Last Modified: 2012-08-14
- Windows 2003 R2 x64
- MySql 4.1
- PHP 5.2.5

I created a "full" backup job through MySql Administrator, and it ran fine from the GUI. Then I monitored the scheduled task it created, and the job failed. I tried fixing the schedule task by creating a new connection instance, but then noticed that I can't access MySql Query Browser or Administrator anymore. I tried re-installing both applications with no luck. The tricky part is that are no clues to why I can't access Query Browser or Administrator. The root login takes, but there's no displayed data in either GUI. The only clue I had was from the failing backups:

Faulting application MySQLAdministrator.exe, version, faulting module libmysqladmin.dll, version, fault address 0x00005d00.

I spent a TON of time on Google, and no I'm completely lost on how to troubleshoot/fix this issue of getting Query Browser and Administrator back.

Thanks in advance for your help. If I missed any information, please ask. Also, please do not add comments that do not offer a solution to this specific problem (ie. both apps are EOL, or why don't I upgrade to MySql 5).

Question by:radox44
    LVL 11

    Expert Comment

    by:Ovid Burke
    Perhaps you could try using MySQL Workbench, which is a single interface which now includes all the GUI Tools.

    Author Comment

    That product only support mysql 5 and above which I'm not prepared to upgrade to yet. Thanks.
    LVL 2

    Expert Comment

    Question: Is the MySQL server working properly? Is your data in there? If you are only having problems with the client programs why not just install them on a different machine and access your server remotely?

    Accepted Solution

    Again, wasn't looking for alternate solutions but rather to fix the problem. Even though the mysql server was working properly, somehow creating a backup through the admin gui broke the tools. I ended up exporting the mysql user table through command line. Removing all instances of mysql (including the server) and re-installing the entire system. Everything is now working. If was a little tricky to bring back in the mysql db and involved create a "mysql_old" db. Then, I just stopped the new install and changed "mysql_old" to "mysql". I appreciate your input.

    Author Closing Comment

    I had to provide my own solution as this was not solved by anyone else. I explicitly put in the new post that I wanted a FIX, not alternate solutions.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now