• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 969
  • Last Modified:

My SQL Error message

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
0
johnhardy
Asked:
johnhardy
  • 6
  • 6
  • 2
  • +1
2 Solutions
 
elimesikaCommented:
HI

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

> mysql_upgrade
0
 
johnhardyAuthor 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.
0
 
shaunakCommented:
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.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
elimesikaCommented:
ha , you are running mysql on windows , so you have to run the following :

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

0
 
elimesikaCommented:
those are the commands
> mysqlcheck --for-upgrade --all-databases --auto-repair
> mysql_fix_privilege_tables
0
 
Cedric Obinna A.Full Stack DeveloperCommented:
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.
0
 
johnhardyAuthor 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?
0
 
elimesikaCommented:
on windows the mysql_upgrade is not supported
please run

> mysqlcheck --for-upgrade --all-databases --auto-repair
> mysql_fix_privilege_tables
0
 
johnhardyAuthor 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
0
 
elimesikaCommented:
from the bin directory of your mysql installation ....
0
 
johnhardyAuthor 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
0
 
johnhardyAuthor Commented:
Sorry  to be so long in answering I will come back in a couple of days.
Regards
John
0
 
Cedric Obinna A.Full Stack DeveloperCommented:
@Which file should I execute please?

mysql_upgrade.exe is the file to execute.
0
 
johnhardyAuthor 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.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 6
  • 6
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now