Re: running a mysql query inside a loop of another without a sync error

>From 1 feet, what you are attempting to do looks like it would be very easily accomplished with a join, leaving you with 1 result set to process. I realize that isn't the question, but it might be a solution. - michael dykman On Wed, Jan 19, 2011 at 9:54 PM, Delan Azabani wrote: > Hi all,

Re: running a mysql query inside a loop of another without a sync error

Hello Delan, On 1/19/2011 21:54, Delan Azabani wrote: Hi all, I'm using MySQL with C in a CGI application. I hope this is the right list to ask for help. If I have this simplified code: MYSQL_RES *res; MYSQL_ROW row; mysql_query(mysql, "some select query"); res = mysql_use_result(mysql); whil

running a mysql query inside a loop of another without a sync error

Hi all, I'm using MySQL with C in a CGI application. I hope this is the right list to ask for help. If I have this simplified code: MYSQL_RES *res; MYSQL_ROW row; mysql_query(mysql, "some select query"); res = mysql_use_result(mysql); while (row = mysql_fetch_row(res)) { MYSQL_RES *res2;

Re: Can't read dir of '.' (errno: 13)

One simple querstion: did you try "chown -R mysql:mysql /your/whole/data/dir" if not do this and after that the problem is gone or not - if it's gone all is ok, if not let us look for other ideas And yes it is possible tha mysql can authenticate the user when bad permissions came after caching so

RE: Can't read dir of '.' (errno: 13)

Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com >-Original Message- >From: Joerg Bruehe [mailto:joerg.bru...@oracle.com] >Sent: Wednesday, January 19,

Re: Can't read dir of '.' (errno: 13)

Hi ! Jerry Schwartz wrote: >> -Original Message- >> From: Joerg Bruehe [mailto:joerg.bru...@oracle.com] >> Sent: Wednesday, January 19, 2011 10:43 AM >> To: mysql@lists.mysql.com >> Cc: Jerry Schwartz >> Subject: Re: Can't read dir of '.' (errno: 13) >> >> Hi! >> >> >> Jerry Schwartz wrot

RE: Can't read dir of '.' (errno: 13)

>-Original Message- >From: Joerg Bruehe [mailto:joerg.bru...@oracle.com] >Sent: Wednesday, January 19, 2011 10:43 AM >To: mysql@lists.mysql.com >Cc: Jerry Schwartz >Subject: Re: Can't read dir of '.' (errno: 13) > >Hi! > > >Jerry Schwartz wrote: >>> -[[...]] >>> >> [JS] I have a related que

Re: Can't read dir of '.' (errno: 13)

Hi! Jerry Schwartz wrote: >> -[[...]] >> > [JS] I have a related question: how can MySQL authenticate a user if file > system permissions won't let it read any databases? To me, your question sounds like you forgot the difference between server and client: - The MySQL server processes always r

RE: Can't read dir of '.' (errno: 13)

>-Original Message- >From: Adarsh Sharma [mailto:adarsh.sha...@orkash.com] >Sent: Wednesday, January 19, 2011 12:45 AM >To: mysql@lists.mysql.com >Subject: Can't read dir of '.' (errno: 13) > >Dear all, > >I am facing the issue mentioned below while issuing show databases command. > > >root

Re: Can't read dir of '.' (errno: 13)

Check owner of the MySQL data directory. 2011/1/19 Pintér Tibor > > mysql> show databases ; > > ERROR 1018 (HY000): Can't read dir of '.' (errno: 13) > > mysql> show databases; > > ERROR 1018 (HY000): Can't read dir of '.' (errno: 13) > > mysql> > > $ perror 13 > OS error code 13: Permission d

Re: ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI' (Errcode: 13)

Hi everybody! Peng Yu wrote: > Hi, > > I run the following command. But I got the following error. I'm not > sure what causes the problem. I have seen the same issue before, but > it disappeared even I didn't take any action. Could anybody let me > know how to fix the problem? > > mysql -ugenom