Re: how to use index with order by here

Rob Wultsch schrieb: On Mon, Mar 17, 2008 at 4:36 AM, Arthur Fuller [EMAIL PROTECTED] wrote: I love when this happens. I woke in the middle of the night with an idea for you. It now occurs to me that the query you want is dead simple. It just took me a while to see: SELECT * FROM messages

How to import oracle dump?

Hello I have got one question. I need to convert oracle dump file and import it to MySQl server. I have found some utitlity OraDump-to-MySQL but it is not free and convert only 5 record from each table. Can somebody help me ? Thanks -- View this message in context:

Re: [ANN] PBXT storage engine version 1.0-Alpha released

Paul McCullagh schrieb: Hi All, I have just released the first fully durable version of PBXT. Because of the amount of new code I have reverted PBXT to Alpha status. This version, 1.0-alpha, can be downloaded from: http://www.primebase.org/download. will there be any Windows builds

Re: [ANN] PBXT storage engine version 1.0-Alpha released

Yes, definitely. Previous versions of PBXT built on Windows, so there can't be much work to get it going. But I don't think I will get around to firing up my Windows VM until after the conference... On Mar 18, 2008, at 8:30 AM, Sebastian Mendel wrote: Paul McCullagh schrieb: Hi All, I

mysql privileges

We are currently running MySQL 4.0.15a on a Sun Solaris server. We are moving to a Linux machine running MySQL 5.0.45. I am having a problem with permissions in MySQL. On the current machine running 4.0.15a, when I connect to MySQL as the user super and give the command: select lname from hr

Re: mysql privileges

Hi, On Tue, Mar 18, 2008 at 8:49 AM, Malka Cymbalista [EMAIL PROTECTED] wrote: We are currently running MySQL 4.0.15a on a Sun Solaris server. We are moving to a Linux machine running MySQL 5.0.45. I am having a problem with permissions in MySQL. On the current machine running 4.0.15a,

RE: How to import oracle dump?

Have you tried the MySQL Migration Toolkit? Check http://www.mysql.com/products/tools/migration-toolkit/ Raj Mehrotra HCCS - Experts in Healthcare Learning -Original Message- From: Metalpalo [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 3:25 AM To: mysql@lists.mysql.com

Re: mysql privileges

Thanks for your reply. When I do show grants, I get back GRANT SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'super' @ 'localhost' ( mailto:super'@ 'localhost' ) identified by password... So it looks like super doesn't have rights to select from the hr table. But why

Re: how to use index with order by here

On Mon, Mar 17, 2008 at 11:35 PM, Sebastian Mendel [EMAIL PROTECTED] wrote: hu? ... i am pretty sure i had a similar problem, i solved this by adding the column with the order to the index, which 'solved' the filesort (except the ORDER is in reverse) I don't think we can lose the filesort

Information schema question.

Hi all! Well, question is how could I to retrieve information about types supported . In PostgreSQL the query would be: -- SELECT pg_type.oid, typname, usename, obj_description(pg_type.oid) FROM pg_type, pg_user WHERE

default my.cnf?

hi all... i have a 5.0.33 build from source on a freebsd 4.10 machine... i'm looking for a my.cnf file. ps tells me that the base dir is /usr/local but there is no my.cnf there. and i cant find one anywhere. i can get all the variables set up from the cli but i need to change some of them.

Re: default my.cnf?

I had the same problem. I found the distribution contains some prototypes, with slightly more elaborate names. Regards, Mike kalin m [EMAIL PROTECTED] 03/18/08 01:06 PM To mysql@lists.mysql.com cc Subject default my.cnf? hi all... i have a 5.0.33 build from source on a freebsd 4.10

mysqlimport load data infile

i read about mysqlimport load data infile for mysql, but i can't find a way to import text file using length of column, instead of delimiter my text file contains fixed length column: -- i can use ms excel to convert all files to .csv format and import, but it would

Re: default my.cnf?

Hi, On Tue, Mar 18, 2008 at 1:06 PM, kalin m [EMAIL PROTECTED] wrote: hi all... i have a 5.0.33 build from source on a freebsd 4.10 machine... i'm looking for a my.cnf file. ps tells me that the base dir is /usr/local but there is no my.cnf there. and i cant find one anywhere. i can

the limitaiton of table size

Dear all, I have a question about the limitatin of table size. If I use the InnoDB engine, I don't have to worry that the total size of table is greater than the single filesize? Thanks a lot! Best, Sookhyun.