Re: Anybody can tell me the differences between show variables and show status?

Am Dienstag, den 08.01.2008, 14:48 +0800 schrieb Moon's Father: > I always confused to them. It's explained in the documentation: http://dev.mysql.com/doc/refman/5.0/en/show-status.html http://dev.mysql.com/doc/refman/5.0/en/show-variables.html Norbert -- MySQL General Mailing List Fo

Re: Odd behavior of 'load data'

Thanks a lot Joe, the LOAD DATA LOCAL did the trick, but just to be courius, why work LOAD DATA with user root but not with filasPOS user, and LOAD DATA LOCAL work with both users? thanks in advance 2008/1/8, joe <[EMAIL PROTECTED]>: > > forgot to mention that I an using 5.1 > I use mysql_loca

Re: Odd behavior of 'load data'

That's the output of the stat command: File: `/var/www/apache2-default/filas/admin/upload/rankeo_pos.csv' Size: 2909Blocks: 8 IO Block: 4096 archivo regular Device: 802h/2050d Inode: 672206 Links: 1 Access: (0666/-rw-rw-rw-) Uid: ( 33/www-data) Gid: ( 33/

Re: group_concat display limit

learnt. On Jan 8, 2008 2:11 PM, Werner Puschitz <[EMAIL PROTECTED]> wrote: > Andrey Dmitriev wrote: > > All, > > > > We are using group_concat but there seems to be some sort of display > > limit. > > Is there are a way to unset or increase it? > > > > Thanks, > > Andrey > > > > You can change th

Re: group_concat display limit

Andrey Dmitriev wrote: > All, > > We are using group_concat but there seems to be some sort of display > limit. > Is there are a way to unset or increase it? > > Thanks, > Andrey > You can change the maximum length by setting the group_concat_max_len system variable to a higher value which is

Re: Odd behavior of 'load data'

You should paste the result of command show grants for 'filasPOS'@'localhost',not the message pasted here. On Jan 8, 2008 12:04 PM, Mauricio Tellez <[EMAIL PROTECTED]> wrote: > Hi, I'm developing a PHP/MySQL app, and I use "load data infile" to feed > data to MySQL. At the develop server I hav

Re: group_concat display limit

You should change your sql to related sub query. On Jan 8, 2008 1:34 PM, Andrey Dmitriev <[EMAIL PROTECTED]> wrote: > All, > > We are using group_concat but there seems to be some sort of display > limit. > Is there are a way to unset or increase it? > > Thanks, > Andrey > > -- I'm a mysql DBA

Re: Odd behavior of 'load data'

Mauricio Tellez wrote: Hi, I'm developing a PHP/MySQL app, and I use "load data infile" to feed data to MySQL. At the develop server I haven't any error, the app works great, but when I upload to the production server, all the "load data infile" statements fails with an error like this: can't sta

group_concat display limit

All, We are using group_concat but there seems to be some sort of display limit. Is there are a way to unset or increase it? Thanks, Andrey

Re: Search for column value in a string variable?

There is also a function named instr.You should visit the section directorly from the document. On Jan 7, 2008 3:38 AM, Barry Newton <[EMAIL PROTECTED]> wrote: > OK, never mind. I finally found the 'locate' function. I knew it had > to be there somewhere! > > -- > > Barry > > > -- > MySQL Gener

Odd behavior of 'load data'

Hi, I'm developing a PHP/MySQL app, and I use "load data infile" to feed data to MySQL. At the develop server I haven't any error, the app works great, but when I upload to the production server, all the "load data infile" statements fails with an error like this: can't stat path/to/my_cvs_file The

Re: INNODB ENGINE NOT AVAILABLE

Hi all, There is no errors. the log_error file is blank Thanks, Prajapati On Jan 4, 2008 5:46 PM, Moon's Father <[EMAIL PROTECTED]> wrote: > You should paste all your error messages here. > > > On Jan 4, 2008 7:29 PM, Vitaliy Okulov <[EMAIL PROTECTED]> wrote: > > > You must copy all files from