In mysql 5.1, mysql.proc table contains 20 columns. Can you check your new DB
again?
-Partha
----- Original Message ----
From: Machiel Richards <machi...@rdc.co.za>
To: mysql mailing list <mysql@lists.mysql.com>
Sent: Fri, 3 December, 2010 1:38:24 PM
Subject: MySQL restore failing
Hi All
I am hoping that someone could assist me with this one.
I am trying to restore a database to a new machine for testing
purposes.
The current machine is running mysql-5.0.72sp1 and the new
machine 5.1.50.
When running the restore is runs for quite a while and then
crashes with the following message:
[r...@mysql2 home]# mysql -u root -p <
mysql_full_021210.dump
Enter password:
ERROR 1547 (HY000) at line 14284: Column count
of mysql.proc is wrong. Expected 20, found 16.
The table is probably corrupted
I have checked the current production system for this table and
the column count is 16, I then checked the new system as well as a newly
setup clean MySQL-5.1.50 database and they are all 16 columns and
exactly the same as far as I can see.
Is there anyone that might know why I am getting this?
I would really apprecaite any help as this machine needs to be
up and running by eod today.
Regards
Machiel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
