Re: Granting all to a user with a db name prefix

Thanks a lot Michael. I can't believe i didn't see that little detail... that happens when you're just exhausted, i guess. Thanks a lot. :-) Francisco - Original Message - From: Michael Stassen To: Paco Zarabozo A. Cc: Sent: Tuesday, July 25, 2006 1:

Granting all to a user with a db name prefix

Hello All, I'm trying to GRANT ALL to a user only on DBs that math a prefix, but i can't find the way to so it on the documentation. Let's assume the username is "john". I want him to have all privileges only on databases with the prefix john, so he can: - create and drop databases starting ON

cache queries

Hi.. I'm using "cache queries" with MySQL 4.0.13 during three days and I get a little better speed. Value of Query_cache_size = 20 Mb. I have two questions. 1.- Is there any way to see which queries are being stored ?? 2.- How can I delay "qcache_lowmen_pruenes" ?? In three day values of it i

Re: Backup question.

pshot in MySQL and use this to back up > data? > > Simon > > -Original Message- > From: Paco Martinez [mailto:[EMAIL PROTECTED] > Sent: 18 November 2003 10:00 > To: Christensen, Dave; 'Richard Reina'; [EMAIL PROTECTED] > Subject: Re: Backup question. > &g

Re: Backup question.

Is there any problem executing "rsync /var/lib/mysql/data/" from one host to another host and therefore having same file in obth machines?? Is it unsafe this method ?? Could be crashed meanwhile transferring ?? Thanks !!! - Original Message - From: "Christensen, Dave" <[EMAIL PROTECTED

mysql_pconnect

Hi My server www has Suse 8.2, apache-1.3.27, mod_php4-4.3.1, and my server mysql has Suse 8.2, and mysql.4.0.12-Max-log Sometimes, not always, it appears an error in www. Warning: mysql_pconnect() [function.mysql-pconnect]: Link to server lost, unable to reconnect in db_mysql.inc on line 73

MySql eats CPU

Estimated gurus. My PC has RH 6.2, 510 Mb RAM, 812 MB swap, Kernel 2.2.23 and Mysql 3.23.55-log. Normaly my CPU is about 2 % , but sometimes increases until 65 %. And memory free swings from 45 Mb to 2 Mb. Web pages creates many temporary tables. Environment variables are. back_log 50 | based

mysql++

Hello, I'm having problems compiling the C++ mysql api on linux, here's the output: automake automake: Makefile.am: required file `./INSTALL' not found automake: Makefile.am: required file `./NEWS' not found automake: Makefile.am: required file `./COPYING' not found automake: Makefile.am: requir

MYSQL C++ API

I'm having probles with the c++ api of mysql... could somebody help me plesae? -- --Paco "Open Source, Open Mind" "Slackware, sending kiddies to /dev/null, since 1993" - Before posti

compiling

simple.cpp -o simple -I /usr/local/mysql/include/mysql/ and when I try to run the examples I got: $./simple1 lt-simple1: error while loading shared libraries: cannot open shared object file: cannot load shared object file: No such file or directory then when I try to see the lib that are missing

Found link that points

Estimated gurus. I've got a MyISAM table with 3000 rows. Two days ago, it showed an error "Got error 127 from table handler".Therefore, I made "OPTIMIZE TABLE tabla" and it was solutioned. But today, table has 3200 rows, and it shows another error "Found link that points at 2325343242342323 (ou

Re: mysql and cgi

ta: $DBI::errstr"; print "$rows row(s) added to bandbook\n"; I must admit that I don't understand the purpose of the ?'s but after many hours of debugging, I'm not complaining. --- Jason Wong <[EMAIL PROTECTED]> wrote: > On Saturday 03 November 2001 04:26,

Re: mysql and cgi

oops, I meant to type Perl for 4 weeks, I am using version Perl 5.6.0 --- Michael Ayres <[EMAIL PROTECTED]> wrote: > Hi Paco, > > If I could make a suggestion... I think you'll be > much happier using a > newer version of perl than 4. With perl 5 and up > yo

mysql and cgi

ue to my unfamiliarity with either language, I am definately not ruling out a syntax error. Thank You, Paco __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com ---

Upgrading from 3.23.34 to 3.23.37

Estimated gurus. I'd like to know if is it essential to upgrade from 3.23.34 to 3.23.37 or changes are not very important. In case of necessary, how can I do this upgrading?? Downloading binary file or RPM file?? Is there any process to upgrade MySQL automaticaly?? Thank you very much

MySQL + htdig

Is there any problem with htdig and MySQL 3.23.??? My PC was executing "htdig htfuzzy, htmerge", etc and suddenly all indexes into tables MySQL were duplicated. For example, there is an index called "count" and another index was added with name "count_2". Is there any warning using "mysql" comm