We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

My SQL Error message

Medium Priority
990 Views
Last Modified: 2012-05-11
I have imported a sql dump on to a server.

The tables appear to have the correct information but I am getting an error

1548 Cannot load from mysql.proc. The table is probably corrupted.

I found some articles on this but could not follow the information provided, I do not have much knowledge re MySql.

I wonder if some one can help me with this please?

Thanks
John
Comment
Watch Question

HI

This is a known bug , please run the following command from a command prompt (shell)

> mysql_upgrade

Author

Commented:
Thanks elimesika

When I do this I get an error 'mysql_upgrade' is not recognised as an internal or external command, operable program or batch file.

Commented:
Check whether you have the necessary data storage engine of the database you are importing. e.g. if you dont have the Innodb support, then your importing will give error and vice-versa if you are trying to import MyISAM sql into Innodb database, then it would give you error.
ha , you are running mysql on windows , so you have to run the following :

(see also : http://bugs.mysql.com/bug.php?id=17531)

those are the commands
> mysqlcheck --for-upgrade --all-databases --auto-repair
> mysql_fix_privilege_tables
Cedric Obinna A.Full Stack Developer
CERTIFIED EXPERT
Top Expert 2008

Commented:
To run the mysql_upgrade command successfully, you need to browse (or change directory) to the BIN directory of your Mysql installation.

Alternatively, you can browse to the folder and execute the file from the bin directory.

Author

Commented:
Thanks all,
I should have said I am on a server Windows Server 2008.

I found a bin directory in ProgramFiles/MySQL.MySQLServer5.5/bin

Which file should I execute please?
on windows the mysql_upgrade is not supported
please run

> mysqlcheck --for-upgrade --all-databases --auto-repair
> mysql_fix_privilege_tables

Author

Commented:
I typed this in the command line but again received the same error message:

"is not recognised as an internal or external command, operable program or batch file."

Should this be done from any particular directory?

 cmd line
from the bin directory of your mysql installation ....

Author

Commented:
Getting closer!

I am now working in the bin directory.

I suspect that
mysqlcheck --for-upgrade should be written as mysqlcheck -g
but when I do this I get an error of
You forgot to give arguments!

Can you say how this should be written please?
Thanks John
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Sorry  to be so long in answering I will come back in a couple of days.
Regards
John
Cedric Obinna A.Full Stack Developer
CERTIFIED EXPERT
Top Expert 2008
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Sorry to have been so long in coming back.
Eventually I overcame the problem by dumping the Mysql table and importing the information.
So the problem was solved but not as expected.

Many thanks for all the help.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.