Re: Prevent execution of queries without a WHERE clause

use 3. Multiple-table SELECT statments are allowed only if MySQL will examine no more than 1,000,000 rows to process the query. The --i-am-a-dummy option is a synonym for --safe-updates. :) Gluck Darren On Tue, Sep 8, 2009 at 10:25 AM, Ian Simpson wrote: > Thanks John, that's done the tri

Re: optimize my.cnf

nf! Gluck Darren www.mysqlpreacher.com - yet another blog from a mysql dba www.securich.com - a mysql security plugin On Thu, Sep 3, 2009 at 10:06 AM, Christos Pelekis wrote: > Hi, > can you please send me some optimization examples for my.cnf ? > I use mysql 5.1.37 > The server run j

Re: reverting to passwd-less root w/out --skip-grant-tables

Log in as root and run: set password = ''; OR update mysql.user set Password='' where User='root'; this is TOTALLY INSECURE but if that's what you want, then it should do the trick. Regards, Darren Cassar www.mysqlpreacher.com www.securich.com On Wed,

Re: Unicode (utf8) and MySQL (with Perl)

rovements after 5.8.1, especially since Unicode support is used a lot less than ascii historically. Also, make sure you have DBI 1.46 and DBD::mysql the newest. -- Darren Duncan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[OT] HP DL760G2 vs Opteron for large DB on Linux

Hi all, I am looking to purchase hardware for a large database running MySQL or Oracle on Linux. Was thinking of the Opteron for its good scalability and memory bandwidth until my friend told me that the DL760 from HP that uses the F8 (from Intel Profusion) chipset allowing up to 8 CPUs and me

RE: moving records between tables?

the above statement to move the record to archive_table and add in two more fields? -Original Message- From: darren [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 11:44 PM To: [EMAIL PROTECTED] Subject: moving records between tables? Hi all, I have 2 tables...one for keeping ac

moving records between tables?

Hi all, I have 2 tables...one for keeping active items while the other is for older records. A housekeep program will come in every night to move some records (matching several criteria from the active table to the history one. I am currently doing SELECT, INSERT and then DELETE. i.e. a "select

Re: Re: threading problems in linux C client

/usr/lib/libmysqlclient_r.so.10 #1 0x08054d40 in th_connection () #2 0x40036fef in pthread_start_thread () from /lib/i686/libpthread.so.0 #3 0x400370df in pthread_start_thread_event () from /lib/i686/libpthread.so.0 -Original Message- From: Eric Bergen <[EMAIL PROTECTED]> To:

threading problems in linux C client

Hi all, I am writing a multi-threaded client that requires shared access to a single MySQL connection. The environment is Redhat 7.3 with the patched mysql-3.23.58-2.71.i386.rpm installed and compiled with -l libmysqlclient_r. The connection is made from the main thread and a MYSQL_RES* myres d

select and update field in one query

Hi all, I need to select the top 1000 records based on the "usage" field and update the "checked" field to '1'. I am currently doing it in 2 statements; i.e. select first then update from a MYSQL_ROW array. How do I do it in just a single statement? Please advice on a better way. Also...will doi

Encrypt().

and what I can do to make it work? Thanks, I appreciate your attention, Darren. Darren Green Strategic ICT Research and Development Cheshire County Council 5th Floor, Commerce House, Hunter Street, Chester CH1 1SR * 01244 602104 fax 01244 603939 * <mailto:[EMAIL PROTECTED] &

RE: Random Selects

3.23.54 on Linux. And it worked. Thx. Seems to be "not so random", but then with more records to sample from the "randomness" would increase. True? -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Saturday, March 08, 2003 2:33 PM To: Darren You

Random Selects

I have a table called testimonials: +--+-+--+-+-++ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-++ | id | tinyint(3) | | PRI | NULL| auto_incre

Regular Expressions

I've looked through the mysql manual for information on regualar expressions, and all that it seems to have are references such as: SELECT "fo\nfo" REGEXP "^fo$"; How can the REGEXP be applied to a 'SELECT field FROM table' kind of statement?

Client History

Where does the mysql client store the query history information? I'm referring to the information that it pulls up when you hit the up or down arrow keys. There was a rather complex query that I came up with a while ago and don't feel like 'up arrowing' all night... Thanks, D

Windows & InnoDB

Is the InnoDB table type available on Windows? Darren Young [EMAIL PROTECTED] mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: SQL Question

that have booked (via count() and group), but this one is eluding me.. Any help or suggestions on where to get more info would be appreciated. Thanks, Darren Young The Freight Depot - Before posting, please check: http

mysql-3.23.53 compile issue

; make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/build/mysql-3.23.53' make: *** [all-recursive-am] Error 2 =====8<= any ideas? I've also tried with no extra ./configure options and get the same resu

mysql 3.23.53 compile issue

; make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/build/mysql-3.23.53' make: *** [all-recursive-am] Error 2 =====8<= any ideas? I've also tried with no extra ./configure options and get the same resul

error: 'Host '' is not allowed to connect to this MySQL server'

the manual for more instructions. . . However, when I attempt to run the second of these I get the following error: [root@ root]# mysqladmin -u root -h mysqladmin: connect to server at '' failed error: 'Host '' is not allowed to connect to this MySQL server' Any help appre

Perl API

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Where are places to obtain information about the Perl API for MySQL? Is there possibly a list specific to that topic? Thanks. -BEGIN PGP SIGNATURE- Version: PGP Personal Security 7.0.3 iQA/AwUBPViONutdIID34ZgYEQLPQACfTkcpF5O7nklg3vkeNPtJP

4.0.2 libmysqlclient.so.10 not found

I tried adding /usr/lib & /usr/lib/mysql /etc/ld.so.conf and ran ldconfig which yielded the same results. Any thoughts on how I could get this library in place with 4.0.2? Thanks, Darren Young [EMAIL PROTECTED] - Bef

4.0.2 libmysqlclient.so.10 not found

ied adding /usr/lib & /usr/lib/mysql /etc/ld.so.conf and ran ldconfig which yielded the same results. Any thoughts on how I could get this library in place with 4.0.2? Thanks, Darren Young [EMAIL PROTECTED] - Bef

MySQL List

eas what error 111 and/or 2003 is? Other thoughts? The actual debug used in the code is: mysql_debug("d:t:F:L:n:N:P:o:, /tmp/client.trace"); The username/password/host/database all work fine from the mysql client as well as from other programs that use similar share

Error & segfault

nd programs. The only thing this program does is runs a single select query against the db. Any ideas what error 111 and/or 2003 is? Other thoughts? The actual debug used in the code is: mysql_debug("d:t:F:L:n:N:P:o:, /tmp/client.trace"

Re: Re: problem with load data local infile

> >Both files are world readable. > > How do you know this? Because FTP tells me they are. > > Also, when you say "client machine", what do you mean? In particular, > are the web server and the MySQL servers running on the same machine? > Client machine is the machine running the webserver and

Re: Re: problem with load data local infile

server? - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 6:14 AM Subject: Re: Re: problem with load data local infile > Darren, > Saturday, April 20, 2002, 1:23:54 PM, you wrote: >

Re: problem with load data local infile

The file does exist. The file and its directory are 0777 permission. Darren - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 4:32 AM Subject: Re: problem with load data local infile >

Fw: problem with load data local infile (repeat)

I never saw this message make this list so I'm reposting it. - Original Message - From: "Darren Vollmer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 19, 2002 7:33 AM Subject: problem with load data local infile > I am having proble

problem with load data local infile

I am having problems with load data local infile. The mysql host server is running 3.23.23 I was able to successfully use load data local infile before to import data off of a client machine onto the mysql host but now all i get is a can't stat file errcode2 message. I know that the pathname I

Re: PERL DBB::MYSQL MAKE TEST PROBLEM....

AIL PROTECTED]> wrote: > Hi Darren, >The tests rely on the perl BDB and mysql-modules > packages for perl. > Have you installed and tested these? > Ken > - Original Message - > From: "Darren Ball" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> &g

PERL DBB::MYSQL MAKE TEST PROBLEM....

I've been having some troubles install dbd::mysql on Solaris 2.4 - make test is failing and I can't figure out what is going wrong. The following shows the results coming back from make test If anybody can help me out here, I would appreciate it. Thanks. make[1]: Entering directory `/hom

RE: Queries entering "Sleep" state.

If say, that client closes the connection at some point in the future...that will clean up then? Or has the connection been severed? -Original Message- From: James Montebello [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 1:59 PM To: Greer, Darren (MED) Cc: '[

Queries entering "Sleep" state.

Hello again all. Thanks for the help on the query time issue, I have begun a transition. I have another question. I have some queries which are apparently going into a "Sleep" mode in my database. Can anyone point me in the right direction on this for more information? Thank

RE: General Query time question

If I move the status to another table, and then wanted to get a count of everyone who is of status 'A', how would that be any quicker? Would I join the tables? -Original Message- From: Carl Troein [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 11:34 AM To: [EMAIL PROTECTED]

RE: General Query time question

You are correct, they are simple Y/N fields. I am not familiar with the process you mentioned, but will do some digging. If you have any information you could give me that doesn't require too much of your time, I would appreciate it. Thanks, Darren -Original Message- From: B

RE: General Query time question

Correction on the query: SELECT count(*) as count FROM userdata WHERE status = 'A'; Sorry. -Original Message- From: Greer, Darren (MED) Sent: Tuesday, January 08, 2002 10:20 AM To: '[EMAIL PROTECTED]' Subject: General Query time question Hello all. I have a data

General Query time question

record DB? Or, are the 40 char(1) fields just slowing it down? Thanks for any help, Darren - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: making a dsn-LESS connection

I believe your provider must be a valid db drivermake sure it exists on your machine. you may want to check out www.4guysfromrolla.com they have a great section on asp dsn/dsn-less connections. Hope it helps. Darren S. Ball Software QA Engineer Lucent Technologies - InterNetworking Systems

mysqld daemon ended on first connection

ng of the database tables but to no avail! Please help... Thanks, Darren

Build problems.

apologies if this is documented somewhere, but i have found much of the material confusing. I am attempting to build mysql-3.23.39 on a sun Solaris 2.6 box, with the languages / utilities installed. 1. perl5.6.1 2. GNUmake 3. GNUm4 4. GNUtar 5. apache1.3.19 6. autoconf-2.13 7. automake-1.4 8. ga

AIX recommendations

eeing test failures for tests rpl15 and rpl16 that I haven't dug into yet but everything else looks ok. Darren Henderson [EMAIL PROTECTED] [EM

MySQL Failing in Runlevel 5 on SuSE Linux 7.1 Pro

bases etc. I would be very grateful if anyone has advice that would enable me to track down the cause of the message and the problem (if there is a problem). Many Thanks Darren Watson Web Developer e-mail: [EMAIL PROTECTED] www.e-skylark.com Evans House Monckton Rd Wakefield WF2 7AS