SearchSearch   

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

  
   Webmaster Forums (Home) -> MySQL RSS
Next:  mysql intersect help  
Author Message
John Bailo

External


Since: Sep 26, 2006
Posts: 6



(Msg. 1) Posted: Thu May 10, 2007 11:01 am
Post subject: Select/Count not showing me my records...permissions?
Archived from groups: mailing>database>mysql (more info?)
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?
Back to top
Good Man

External


Since: Mar 03, 2006
Posts: 543



(Msg. 2) Posted: Fri May 11, 2007 10:47 am
Post subject: Re: Select/Count not showing me my records...permissions?
Archived from groups: per prev. post (more info?)
John Bailo <jabailo.RemoveThis@texeme.com> 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?
Back to top
John Bailo

External


Since: Sep 26, 2006
Posts: 6



(Msg. 3) Posted: Sun May 13, 2007 9:44 am
Post subject: Re: Select/Count not showing me my records...permissions?
Archived from groups: per prev. post (more info?)
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....
Back to top
Display posts from previous:   
       Webmaster Forums (Home) -> MySQL
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum