Re: MySQL restore failing

2010-12-21 Thread 杨涛涛
Hi, I think you didn't run mysql_upgrade script. David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 2010/12/3 Shawn Green (MySQL) > On 12/3/2010 03:40, Machiel Richards wrote: > >

Re: MySQL restore failing

2010-12-03 Thread Shawn Green (MySQL)
On 12/3/2010 03:40, Machiel Richards wrote: I checked now and saw that they have already attempted a restore previously and hence the original table was dropped and recreated. I found some links on the internet stating that after restoring the dump file to the new version, the proc table sh

Re: MySQL restore failing

2010-12-03 Thread Machiel Richards
? The current proc tables have 16 columns. Any ideas? Regards Machiel -Original Message- From: partha sarathy To: Machiel Richards , mysql mailing list Subject: Re: MySQL restore failing Date: Fri, 3 Dec 2010 14:02:59 +0530 (IST) In mysql 5.1, mysql.proc table contains 20

Re: MySQL restore failing

2010-12-03 Thread partha sarathy
In mysql 5.1, mysql.proc table contains 20 columns. Can you check your new DB again? -Partha - Original Message From: Machiel Richards To: mysql mailing list Sent: Fri, 3 December, 2010 1:38:24 PM Subject: MySQL restore failing Hi All I am hoping that someone could assist

MySQL restore failing

2010-12-03 Thread Machiel Richards
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 a