Well, then I'll just go back to my original problem if you have read through this thread from the beginning. Because copying files did not work, I turned to try mysqldump. Mysqldump does not work for me either. So there really isn't a way to create a dump on 5.0.x that's compatible with 3.23.x?
Bing > I have not tried 5.0.x to 3.23.x but give this a try: > Flush the tables with read lock or flush the tables and shutdown the > database > tar.gz the files > Move the files to the the new server > Untar/unzip the files > Start up both databases > > > -----Original Message----- > From: 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 >> 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 >> should have an option --compatible=name. I tried > --compatible=mysql323 >> with mysqldump on my version 5.0 server, but got "mysqldump: ERROR: >> unknown variable 'compatible=mysql323'". 'mysqldump --help' does not >> show >> --compatible as a valid option. 'mysqldump -V' shows >> mysqldump Ver 9.10 Distrib 4.0.18, for pc-linux (i686). I also > looked >> through mysqldump help but did not find any option that could be used > to >> produce a backward compatible dump. >> >> Any ideas? >> >> Bing >> >>> 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. >>> >>> 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 error in your SQL syntax near >>> 'ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='List the names and >>> locations of fi' at line 12 >>> >>> Line 12 the above error refers to exists in the following CREATE > TABLE >>> statement: >>> >>> 1. CREATE TABLE mytable ( >>> 2. attachment_id mediumint(5) NOT NULL auto_increment, >>> 3. task_id mediumint(10) NOT NULL default '0', >>> 4. orig_name varchar(100) NOT NULL default '', >>> 5. file_name varchar(30) NOT NULL default '', >>> 6. file_desc varchar(100) NOT NULL default '', >>> 7. file_type varchar(50) NOT NULL default '', >>> 8. file_size mediumint(20) NOT NULL default '0', >>> 9. added_by mediumint(3) NOT NULL default '0', >>> 10. date_added varchar(12) NOT NULL default '', >>> 11. PRIMARY KEY (attachment_id) >>> 12. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='List the names >> and >>> locations of files attached to tasks'; >>> >>> I did a test, seems after removing 'DEFAULT CHARSET=latin1' from line >>> 12, >>> the table could be imported fine. Is there some syntax of version > 3.* >>> that is not supported in version 5.*? Like I said, there are a lot >>> tables >>> that need to be transferred, manually editting the dump file is not >>> acceptable. Any workaround? >>> >>> Bing >>> >>>> >>>> >>>> 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 database called >>>>>'mydb'. Then I copied three files mytable.frm, mytable.MYD, >>> mytable.MYI >>>>>from server A's /var/lib/mysql/mydb/ directory to server B's >>>>>/var/lib/mysql/mydb directory. >>>>> >>>> Make sure mysql owns mydb and all of its files. >>>> >>>>> >>>>>Now on server B, when running the command 'mysql -h localhost -u > root >>> -p >>>>>mydb', I got the following messages back: >>>>> >>>>>---- >>>>>Didn't find any fields in table 'mytable' >>>>>---- >>>>> >>>>>By the way, I did restart the mysql server on server B after copying >>>>> files. >>>>> >>>>>Does that mean version 3.* can not read version 5.* tables? How >>> should I >>>>>set up the same database and tables on another server just by > copying >>>>>files because I have a lot tables that need to be moved over? >>>>> >>>>>Thanks in advance for any help. >>>>> >>>>>Bing >>>>> >>>>> >>>>> >>>> >>>> >>>> >>> >>> >>> -- >>> MySQL General Mailing List >>> For list archives: http://lists.mysql.com/mysql >>> To unsubscribe: >>> http://lists.mysql.com/[EMAIL PROTECTED] >>> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]