Select/Count not showing me my records...permissions?

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?

Re: Select/Count not showing me my records...permissions?

John Bailo wrote in
news:TaGdnTepTYaew97bnZ2dnUVZ_gqdnZ2d@speakeasy.net:

>
> 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?
>

What is your query?

Re: Select/Count not showing me my records...permissions?

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....