John Bailo wrote:
Quote:
>
I imported 600,000 records from SQL Server 2005 to mySQL.
>
I know they are in there -- I just can't see them!
>
When I do a SELECT, it processes for a while, and then returns nothing.
>
Same with a count, it sits there processing, and then returns a '0'
>
However when I do the same on a table I know has no rows, it definitely
comes back right away.
>
I'm logged in as root. Do I need to assign myself some permissions to
see these records? And the count numbers?
|
Ok, the first time I imported, I stopped it 2/3rds of the way and I
thought I had 2/3rds of the records, but apparently not.
I let it run all the way through and it works brilliantly.
mySQL is faster than sql2005 for sure....
