|
Posted by John Bailo on May 13, 2007, 12:44 pm
Please log in for more thread options John Bailo wrote:
>
> 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....
| 
XML Sitemap