Re: Didn't find any fields in table, why?

2004-06-29 Thread gerald_clark
Bing Du wrote: I have two mysql servers as shown below: MySQL server A: version 3.23.58, database: mydb, table: mytable MySQL server B: version 5.0.0-alpha-standard-log I want the server B to have the exact same database and table as those on the server A. So, on server B, I manually created a

Re: Didn't find any fields in table, why?

2004-06-29 Thread Bing Du
Yes, both user and group ownership of the mydb directory and all its sub directories/files are mysql. I also tried on server A 'mysqldump mydb /tmp/mydb.dump'. Then copy /tmp/mydb.dump to server B. On server B, I did 'mysql mydb /tmp/mydb.dump'. Then I got ERROR 1064 at line 11: You have an

RE: Didn't find any fields in table, why?

2004-06-29 Thread Victor Pendleton
ENGINE syntax is availiable in 4.1.x and later versions. -Original Message- From: Bing Du To: [EMAIL PROTECTED] Sent: 6/29/04 2:30 PM Subject: Re: Didn't find any fields in table, why? Yes, both user and group ownership of the mydb directory and all its sub directories/files are mysql

RE: Didn't find any fields in table, why?

2004-06-29 Thread Bing Du
. -Original Message- From: Bing Du To: [EMAIL PROTECTED] Sent: 6/29/04 2:30 PM Subject: Re: Didn't find any fields in table, why? Yes, both user and group ownership of the mydb directory and all its sub directories/files are mysql. I also tried on server A 'mysqldump mydb /tmp

RE: Didn't find any fields in table, why?

2004-06-29 Thread Victor Pendleton
Are you migrating from 5.0.x to 3.23.x? Do you have any innodb or dbd tables? -Original Message- From: Bing Du To: '[EMAIL PROTECTED] ' Sent: 6/29/04 3:59 PM Subject: RE: Didn't find any fields in table, why? Yup, that's it. I just checked out the mysql online documents. mysqldump

RE: Didn't find any fields in table, why?

2004-06-29 Thread Bing Du
Yes, migrate from 5.0.x to 3.23.x. No innodb and dbd tables. Bing Are you migrating from 5.0.x to 3.23.x? Do you have any innodb or dbd tables? -Original Message- From: Bing Du To: '[EMAIL PROTECTED] ' Sent: 6/29/04 3:59 PM Subject: RE: Didn't find any fields in table, why

RE: Didn't find any fields in table, why?

2004-06-29 Thread Victor Pendleton
] ' ' Sent: 6/29/04 4:13 PM Subject: RE: Didn't find any fields in table, why? Yes, migrate from 5.0.x to 3.23.x. No innodb and dbd tables. Bing Are you migrating from 5.0.x to 3.23.x? Do you have any innodb or dbd tables? -Original Message- From: Bing Du To: '[EMAIL PROTECTED

RE: Didn't find any fields in table, why?

2004-06-29 Thread Bing Du
To: ''[EMAIL PROTECTED] ' ' Sent: 6/29/04 4:13 PM Subject: RE: Didn't find any fields in table, why? Yes, migrate from 5.0.x to 3.23.x. No innodb and dbd tables. Bing Are you migrating from 5.0.x to 3.23.x? Do you have any innodb or dbd tables? -Original Message- From: Bing Du