Re: MSSQL Server to MYSQL migration problems
Hi Joshua, > Making the MySQL indexes would be your responsibility. Importing the data > would most likely not import the index definitions also. You need to > recreate those. Your explain seems to indicate that you have *no* indexes on > your table. I would guess that your query doesn't hang it just takes a very > long time to return. I'm not a MySQL hacker, but... > > Joshua, maybe there are some ineficient indexes, I don't know, because > > the MSSQL database was not made by me. Iam just trying to migrate the > > database to MYSQL and check that everything works fine. > > My query is > > "SELECT * FROM postulantes LIMIT 1,30" Why should this query use any indices? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MSSQL Server to MYSQL migration problems
Please reply to the list, and not to me. Thanks. Making the MySQL indexes would be your responsibility. Importing the data would most likely not import the index definitions also. You need to recreate those. Your explain seems to indicate that you have *no* indexes on your table. I would guess that your query doesn't hang it just takes a very long time to return. j- k- On Monday 05 April 2004 06:00 pm, Rodrigo Galindez said something like: > Joshua, maybe there are some ineficient indexes, I don't know, because > the MSSQL database was not made by me. Iam just trying to migrate the > database to MYSQL and check that everything works fine. > My query is > "SELECT * FROM postulantes LIMIT 1,30" > My phpmyadmin hungs :( > When i put EXPLAIN in the query, phpmyadmin returns the following: > table typepossible_keys key key_len ref rowsExtra > postulantes ALL /NULL/ /NULL/ /NULL/ /NULL/ 4499 > > Thanks for your help, im still confused :( > > Joshua J. Kugler wrote: > >MySQL is very stable on large databases...I would suspect inefficient > > indexes. What does your query look like? What is the output when you put > > "EXPLAIN" in front of your query? > > > >I don't know anything about SQLYog blob display, so can't comment there. > > > >j- k- > > > >On Monday 05 April 2004 05:41 pm, Rodrigo Galindez said something like: > >>Im using SQLYog to display results. It lets me to display blob data > >>types. By the way, i was trying to do some queries with phpmyadmin ... > >>but, it "hungs" ... hmmm ... inestability with large databases in mysql > >>maybe ? :S > >> > >>Joshua J. Kugler wrote: > >>>You "can't?" How are you trying to display? What are you using? A CGI > >>>script? A database utility? Something else? We need a bit more > >>>information to answer the question. > >>> > >>>j- k- > >>> > >>>On Monday 05 April 2004 05:19 pm, Rodrigo Galindez said something like: > Hello list, > Recently I've been in the job of migrating a large (about 1.5GB) > database build in MSSQL Server to MYSQL. The migration was done OK, I > used the "SQLYog" utility to do this. The problem is that one table has > image column types ... I tried to view this column types (blob data > types now) but I can't in the MYSQL migrated data base, ... it just > don't display anything. Any ideas ? Is there any issue problem when > migrating MSSQL image column types to MYSQL ? > Thanks in advance, cheers from Argentina, -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MSSQL Server to MYSQL migration problems
Since you have used SQLyog, I will say you contact the SQLyog people about this. Karam --- "Joshua J. Kugler" <[EMAIL PROTECTED]> wrote: > You "can't?" How are you trying to display? What > are you using? A CGI > script? A database utility? Something else? We > need a bit more information > to answer the question. > > j- k- > > On Monday 05 April 2004 05:19 pm, Rodrigo Galindez > said something like: > > Hello list, > > Recently I've been in the job of migrating a > large (about 1.5GB) > > database build in MSSQL Server to MYSQL. The > migration was done OK, I > > used the "SQLYog" utility to do this. The problem > is that one table has > > image column types ... I tried to view this column > types (blob data > > types now) but I can't in the MYSQL migrated data > base, ... it just > > don't display anything. Any ideas ? Is there any > issue problem when > > migrating MSSQL image column types to MYSQL ? > > Thanks in advance, cheers from Argentina, > > -- > Joshua J. Kugler > Fairbanks, Alaska > Computer Consultant--Systems Designer > .--- --- ... ..- .--.- ..- --. .-.. . .-. > [EMAIL PROTECTED] > ICQ#:13706295 > Every knee shall bow, and every tongue confess, in > heaven, on earth, and under > the earth, that Jesus Christ is LORD -- Count on it! > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MSSQL Server to MYSQL migration problems
MySQL is very stable on large databases...I would suspect inefficient indexes. What does your query look like? What is the output when you put "EXPLAIN" in front of your query? I don't know anything about SQLYog blob display, so can't comment there. j- k- On Monday 05 April 2004 05:41 pm, Rodrigo Galindez said something like: > Im using SQLYog to display results. It lets me to display blob data > types. By the way, i was trying to do some queries with phpmyadmin ... > but, it "hungs" ... hmmm ... inestability with large databases in mysql > maybe ? :S > > Joshua J. Kugler wrote: > >You "can't?" How are you trying to display? What are you using? A CGI > >script? A database utility? Something else? We need a bit more > > information to answer the question. > > > >j- k- > > > >On Monday 05 April 2004 05:19 pm, Rodrigo Galindez said something like: > >>Hello list, > >>Recently I've been in the job of migrating a large (about 1.5GB) > >>database build in MSSQL Server to MYSQL. The migration was done OK, I > >>used the "SQLYog" utility to do this. The problem is that one table has > >>image column types ... I tried to view this column types (blob data > >>types now) but I can't in the MYSQL migrated data base, ... it just > >>don't display anything. Any ideas ? Is there any issue problem when > >>migrating MSSQL image column types to MYSQL ? > >>Thanks in advance, cheers from Argentina, -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MSSQL Server to MYSQL migration problems
You "can't?" How are you trying to display? What are you using? A CGI script? A database utility? Something else? We need a bit more information to answer the question. j- k- On Monday 05 April 2004 05:19 pm, Rodrigo Galindez said something like: > Hello list, > Recently I've been in the job of migrating a large (about 1.5GB) > database build in MSSQL Server to MYSQL. The migration was done OK, I > used the "SQLYog" utility to do this. The problem is that one table has > image column types ... I tried to view this column types (blob data > types now) but I can't in the MYSQL migrated data base, ... it just > don't display anything. Any ideas ? Is there any issue problem when > migrating MSSQL image column types to MYSQL ? > Thanks in advance, cheers from Argentina, -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
