According to the manual, 64 to 32 bit shouldn't matter, it should work fine as long as they're both little endian, or they're both big endian.
I've copied MyISAM tables from 64 to 32 bit without a problem. BTW, I suggested that because in the error it said: "myisamchk: error: Key in wrong position at page 715776 - check records and index references" Did you by any chance symlink or move files, or not move the key files? My guess is that might cause that problem, otherwise, I have no idea what would cause it. -Sheeri On 3/29/06, Sander Smeenk <[EMAIL PROTECTED]> wrote: > Quoting sheeri kritzer ([EMAIL PROTECTED]): > > > what's the result of > > SHOW CREATE TABLE games > > It gives me the create statement for that table. > All perfectly normal. MyISAM table, latin1 charset. > > > I'd drop the indexes on the games table, and then run repair tables, > > and then put the indexes back in. Worth a shot. > > Funny, i haven't tried that yet, and lo-and-behold, after rebuilding the > index (that's all i did): > > | [22:27] [EMAIL PROTECTED]:/var/lib/mysql/v] # myisamchk games.MYI > | Checking MyISAM file: games.MYI > | Data records: 10644 Deleted blocks: 0 > | - check file-size > | - check record delete-chain > | - check key delete-chain > | - check index reference > | - check data record references index: 1 > | - check data record references index: 2 > | - check record links > > Aparently, what i heard from a friend, it's not done to binary copy > tables from 32bit systems over to 64bit systems. Is it as bad to binary > copy tables from 64bit to 32bit systems? > > It's vital in our current setup that binary copy of tables works. > Or we need to set up replication right now ;) > > Lemmeknow and Thanks!! > > Sander. > -- > | Lead me not into temptation... I can find it myself. > | 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8 9BDB D463 7E41 08CE C94D > > -- > 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]
