>> I am moving a table from a 3.23.56 db to a 4.1.7 db. I currently only >> testing to see if I can. So far, I have been able to create the receiving >> table, but not be able to insert the data. (The only difference I see when >> using phpMyAdmin is the collation column on the 4.1.7 server) ... > I have figured my problem out. I was trying to do too much through > phpMyAdmin. I was able to get the data into the db by doing '/usr/bin/mysql > -u root -p test_cm_xoops < xoops_users2', which worked flawlessly.
Is there any performance hit by having the fields ordered one way (1,2,3,4,5,6) on the originating server (3.23.56) and ordered a different way (6,3,5,1,2,4) on the end server (4.1.7)? Or, there is not performance hit because of the KEYs and the SELECT statements? These may be obvious questions for others, but I am just learning the database commands. thanks eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
