?
Solved

Mysql Query Browser and Mysql Administrator Issue

Posted on 2011-05-07
5
Medium Priority
?
655 Views
Last Modified: 2012-08-14
Environment:
- 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 1.1.9.0, faulting module libmysqladmin.dll, version 0.0.0.0, 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).

Thanks!!
0
Comment
Question by:radox44
  • 3
5 Comments
 
LVL 11

Expert Comment

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

Author Comment

by:radox44
ID: 35715951
That product only support mysql 5 and above which I'm not prepared to upgrade to yet. Thanks.
0
 
LVL 2

Expert Comment

by:matstein
ID: 35967284
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?
0
 

Accepted Solution

by:
radox44 earned 0 total points
ID: 35967862
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.
0
 

Author Closing Comment

by:radox44
ID: 35997813
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.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month14 days, 13 hours left to enroll

839 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