> -----Original Message-----
> From: Robert H.R. Restad [mailto:robertrestad@stripped]
> Sent: Sunday, October 06, 2002 9:04 AM
> To: James Riordon; mysql@stripped
> 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
