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
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
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
.
-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
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
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
] ' '
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
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