Re: Information schema question.

Carlos Savoretti schrieb: Hi all! Well, question is how could I to retrieve information about types supported. IMHO, no -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql privileges

Malka Cymbalista schrieb: 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 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.

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

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

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

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. i

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 typowner=usesy

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 filesor

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 no

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

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.

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 w

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 ha

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 availabl

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: http://www.nabble.com/How-