Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- John Bailo
May 10, 2007, 6:01 pm
rate this thread
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?
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....
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum