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

[John Bailo]

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?

[Good Man]

Post by John Bailo
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?

[John Bailo]

Post by John Bailo
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....