> -----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". sql, query --------------------------------------------------------------------- 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