At 11:17 -0500 10/06/2002, I whispered: > > -----Original Message----- >> From: Robert H.R. Restad [mailto:[EMAIL PROTECTED]] >> Sent: Sunday, October 06, 2002 9:04 AM >> To: James Riordon; [EMAIL PROTECTED] >> Subject: RES: Re: Server comparison running Mysql >> >> Another thing... I noticed once when I moved a website from one server to >> another, that when exporting/importing the MySQL databases, there >> was a few >> errors which theoretically shouldnt have been possible to get. >> Illegal/duplicate indexes etc. I had to override and supress >> error messages >> to actually be allowed to import the database at all. (Even if >> the original >> database worked - appearantly - perfect on the original webserver) > >How did you move the tables over? I've never had a problem moving databases >between machines when I use mysqldump like "mysqldump -C --add-drop-table >blah --databases DB1 DB2 DB3|rsh newhost mysql".
I moved the databases over as such mysqldump --add-drop-table DB1 Then on the new machine I rebuild the index via OPTIMIZE TABLE tablename; REPAIR TABLE tablename QUICK; for each table. Perhaps i did something wrong? sql, select --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php