Re: perl dbh->quote and numeric columns

>>if (length($some_variable) == 0) >> { $quoted_some_variable = "NULL"; } >>else >>{ $quoted_some_variable = $dbh->quote($some_variable); } >> &g

TCP/IP Host setup

sql,mysql Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686

Re: Connection Problem

t;>#! /usr/bin/perl -w >># intro6.pl - connect to MySQL, retrieve data, write plain text output >>use strict; >>use DBI; >>use CGI qw(:standard); >> >>my ($dbh, $sth, $count); >>$dbh = DBI->connect ("DBI:mysql:host=localhost;database=***", >> "**", &

Re: Perl version of phpinfo()

BI/DBD module is accessible to Perl on a >>Linux server. >>Will appreciate any help on this. >>-- Margie New at the command line: perl -V or perl -v sql database mysql Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Inte

Re: Stepping through a MySQL_fetch_array in PHP?

characters): [EMAIL PROTECTED] >>Web: http://www.zorka.com (Howto's, News, and hosting!) >> >> "With enough memory and hard drive space >> anything in life is possible!" >>#

Re: perl mysql DBI::db question

t;> >> >>$sql_check->finish; EXTREMELY out-dated! MySQL Version: 3.21.X DBI.pm Version 0.93 <= current 1.21 DBD::mysql.pm Version 1.1832 <= current 2.2 I would not even consider using this for any type of reference. FYI, finish() is not necessary. Read

Re: perl mysql DBI::db question

# I dont like the below die statement, it should exit gracefully. >>$sql_check->execute or die "Can't connect to users table : >>$dbh-errstr"; >>my ($t_user,$t_password,$t_prefs) = $sql_check->fetchrow_array(); >>$dbh->disconnect;

Re: MOD_AUTH_MYSQL and apache

sswd file and put them in my mysql table >>apache cant read them You need to add to your .htaccess file: Auth_MySQL_Encryption_Types Crypt_DES MySQL this tells apache to use either the UNIX crypt or MySQL Password encryption Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thund

Re: Perl core API

ses of the MySQL deamon with Perl in much the same way we access Apache >via mod_perl. Things like: >> >>- Query rewrite >>- Data manipulation, pre-storage >>- Data manipulation, post-query >>- Prodedures >> >> >>--- Mike(mickalo)Blezien =-=-

Re: running mysqlhotcopy error

lib/perl5/site_perl/5.005 .) at ./mysqlhotcopy line 8. >>BEGIN failed--compilation aborted at ./mysqlhotcopy line 8. >> >> >>What is DBI? >> >>I got perl installed at ... >> >>$ which perl >>/usr/local/bin/perl Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=

OT: Auth_MySQL

e and passwords?? Or do I need to specify these paramaters in the httpd.conf with the Auth_MySQL_Info directive?? Again, my apologise to the list if this is off-topic. any response, please send directly to me then. TIA, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Inte

Re: Is The MySQL Mailing List On Crack?

gone wacko the last day or two! :) sql database mysql Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http:/

Re: Obtaining GMT time in mySQL

>>>> Thanks to Chris Land for pointing the UNIX_TIMESTAMP() function >>>> out to me. >>>> >>>> The only prob is daylight savings. We in NSW, Australia a

Re: setup/DBI issues...

unning, and I can >>> > access it with the mysql client, but I get an "unknown" error whenever I >>> > try to connect to it via perl DBI... >>> > >>> > I'm using: >>> > >>> > DBI->connect("DBI:mysql:$User

Re: MySQL gurus - easy one.

;> >> >>I am trying to create a table and made a file as below: I believe the column name your using "date" is a reserved word in MySQL Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Soluti

Re: any good web hosting with php and mysql support?

who have web sites hosted at webhosting service for a >>> reasonably long time without any problems? IF yes, can you please >>> contact me >>> and tell me about it? This might be kind of off-topic for both lists, >>> and i

Re: Newbie Question: Float Type Range

e decimal and the 2 the number of digits after the decimal. >> I think you'll find using the DECIMAL(6,2) works better for dollar values. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http:/

Monitor Mysql Server

automatically in the event someone is not available to restart it. I'm no shell script write... strictly Perl :) Not sure this could be done with Perl. any suggestions would be appreciated. :) Happy Holidays, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publi

Monitor Mysql Server

automatically in the event someone is not available to restart it. I'm no shell script write... strictly Perl :) Not sure this could be done with Perl. any suggestions would be appreciated. :) Happy Holidays, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publi

Re: dbi accessor for mysql_insertid

l version 2.0416 >> >>Blows up on trying to use $dbh->mysql_insertid(): >>Can't locate object method "mysql_insertid" via package "DBI::db" (perhaps >>you forgot to load "DBI::db"? >> >>Wou

Re: Performance

he page. >> >>mike With Perl and DBI, you can have multiple querys executing with one database handle and only need one to close it once all queries have been executed. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Sol

Re: Each user have only see databases they have access too

been able to get >>it to work by passing --safe-show-database to the service as it starts. >>If/when I discover how to add this option to the my.cnf file I'll let you >>know. >> >>Kelly >>- Original Message - >>From: "Mike(mickalo)Blezien&qu

my.cnf settings

Which group(s) would the following options be put under to enable in the my.cnf. safe_show_database skip_show_database Thx's mysql sql database Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work!

Re: Each user have only see databases they have access too

Desktop and I’ve created a new user and only >>>granted access to one database, but when I use myPhpAdmin the user can >>>still >>>see all the databases. What can I do so that each user only see the >>>databases they have access too. >>> >>>&qu

startup command line

r is restarted and the bdb table handler is enabled again. Thx's database mysql sql Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225

Re: just moved from windows to linux mysql

;>like this: >> >>$ bin/mysql -p samp_db >> >>see? Omit the -u argument and the mysql client uses your Unix/Linux >>username as the MySQL username. Note that the -p flag is optional if >>you do not have a password set for that pa

Re: Error trying to create InnoDB database. HELP

are created just fine. >>But, when everything is done the following error appears: >> >>/usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Table 'mysql.host' >>doesn't exist >> >>I haven't yet found where the 'mysql.host' tab

Re: Size of table's MYD file?

ble to get the accurate size? run OPTIMIZE on the table. that usually corrects that. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.th

Re: Load data infile

erminated by '\n'; >> >>the text file is contructed as such: >> >>ID|NUM|CODE >>ID|NUM|CODE >>ID|NUM|CODE >>etc >> >>approx., 1600 records >>But it only grabs the file line, and stops. I&

Load data infile

and that's it?? is the file in the wrong format?? thx's mysql database sql Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=

Re: Changing the socket location?

as wondering is there anyway to change the socket location from >>/tmp/mysql.sock to something else, other than recompiling :-)? If there is >>not I would like to highly recommend it as an option. >> >>TIA >>stevet Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Re: Running queries while queries are still running

first query) >> >>When I do this logic in Perl/DBI, it seems to restart the loop, returning the >>same row, over and over again. Can this be right? It helps to post part of the code your using to better understand the problem. :) Altho this more

Problem moving database datadir

lroot 6450 Nov 26 22:51 mysql_log.err -rw-rw1 mysqlmysql 54739 Nov 26 22:51 mysql_update.log drwx--2 mysqlmysql1024 Jul 30 19:31 referra1/ lrwxrwxrwx1 mysqlmysql 22 Nov 25 23:00 tracers -> /home/

Re: the official name of 3.23.45 source

I'll end up with a bunch of "download.php" >>source code files in my source code directory over time. The 3.23.44 >>file was called "mysql-3.23.44.tar.gz" , but I don't want to make an >>assumption about the filename. Mike(mickalo)Blezien =-=-

Re: MySQL Binary

On Fri, 23 Nov 2001 23:46:40 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote: >>At 10:14 PM -0600 11/23/01, Mike(mickalo)Blezien wrote: >>>Hello all, >>> >>>I'm a bit confused. Does the Mysql-Max only come with BDB/Innodb >>>support or does

Upgrade gcc on Linux

could some one be so kind, reponding off the list, as what is need to upgrade our gcc compilier.. Much appreciated and again, my appologise to the list for the OT posting database mysql Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet

Re: error when running myql on Linux 7.1

ase check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >>To request this thread, e-mail <[EMAIL PROTECTED]> >>To unsubscribe, e-mail <[EMAIL PROTECTED]> >>Trouble unsubscribing? Try:

Re: .pid file missing

- Mike No, simple restart the MySQL server. Make sure it's properly been shutdown, then restart it. I will automatically create the pid file. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http:/

Re: Fw: LOAD_FILE does not work

ivileges enabled in the mysql.user table. I had a similar problem with a client, and after granting FILE privileges, it worked perfectly! :) Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Inter

Re: Query Execution Time Perl/DBD

;>> How do I get the query execution time from Perl/DBD? MySQL client returns >>> this in the console window. Is this value available through the Perl DBD >>> interface? >>> >>> Thanks. >>> >>> Gordan Mike(mick

Re: Exporting Data

into mysql under the client's username password, which has full >privilegs on the database being used here: 'tracers' it will not allow this query to >be executed, I keep getting the error, "access denied for tracerta@localhost using >password (yes)." >>

Re: Exporting Data

I log into mysql under 'root', then I can execute the query with no problems. The OUTFILE is in the client's account on the server, the 'tmp' folder is chmoded 0777 and owned by the client 'tracerta' Is there a special privilege setting for selecting into outfile ?

Exporting Data

Hello, Sorry about the OT, but I need to export data from various MySQL tables and import into Excell spread sheets. Was hoping someone could suggest the best format, TAB, CSV..etc delimited, which is the preferred format? thanks, mysql database Mike(mickalo)Blezien

Re: mysqld shutdown

any locks? If so, can you kill the thread with mysqladmin >>kill? Have you tried ./mysqladmin -u root -p shutdown when in the 'bin' folder otherwise typing mysqladmin, it will check the server PATH, to find the mysqladmin Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Re: hostname.err file

for the .err file created instead of the default hostname.err. Can this be done >>> thru the my.cnf option somehow?? >>> >>> thx's >>> >> >>This file is created by safe_mysqld script. >>The script accepts an option --err-log to change

hostname.err file

7;s mysql database Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(22

compiling from source - OT

cc on a RH/Linux box?? Sorry about the slightly OT posting... mysql database. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com

Join two tables to each other

| 3 | NUL | "X" | | 4 | "c" | "Y" | | 5 | NUL | "Z" | | 6 | "d" | NUL | +-+-+ That is, it gets the x key(s) from both tables, and the data (foo and bar) from one or both the tables who

Need query help

emid | name| email | zip | +---+-+---+---+ |21 | Charge Schwartz | [EMAIL PROTECTED] | 33308 | |22 | Check Schwartz | [EMAIL PROTECTED] | 33308 | +---+-+---+---+ mysql

Re: HOW do I return the results of a count to a variable

gt;> >>$prep = "SELECT COUNT(*) FROM go.objectives WHERE subjects_id='1' AND >>subjectHeadings_id='2' ORDER BY displayOrder"; >> >>$sth = $dbh->prepare($prep); >> >>$sth->execute; >> >>So what I need to do is ad

Re: web-based interface for manipulating MySQL tables?

Edelstein wrote: >>>If you have PHP installed, try phpMyAdmin. It's a very good tool, easy use >>>and installing. >>>Regards. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thun

Re: (errno: 40)

ulltext index. I can't find an >>explanation of (errno: 40). I am guessing the problem is with either a temp >>directory or some file permission on our UNIX system? What do you think? >> >>Thank you, perror 40 Error code 40: Too many levels of symbolic links

Re: Table Names

gt;>CREATE TABLE 201 ( tagnumber varchar(8) not null default '' ) >>CREATE TABLE 301 ( tagnumber varchar(8) not null default '' ) >>I've looked thru various documentation about table reservered names and couldn't >>find any info abou

Re: Table Names

27; ) >>> I've looked thru various documentation about table reservered >>> names and couldn't >>> find any info about numerical table names only. >>> >>> Are numerical valued tables names not allowed then?? >> >>Correct. Table na

Table Names

rchar(8) not null default '' ) I've looked thru various documentation about table reservered names and couldn't find any info about numerical table names only. Are numerical valued tables names not allowed then?? TIA, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=

Re: Sessions

DATADIR, this will tell you who's doing what and when. database mysql Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! ht

myisamchk error

Hello All, When repairing a MySql table, I keep getting following error: 'mydatabase.MYD' doesn't have a correct index definition What exactly does this mean or what needs to be done to correct it? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Inte

Control Database size

Is there away to control the max size of each database create by user. I mean built into MySQL?? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002

Server Problems

from table handler - No space left on device Is there an way to remedy this problem? Obviously we have a setup error or something as there is a 20gig drive in the mySQL server. mysql database Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing

Server Problems

from table handler - No space left on device Is there an way to remedy this problem? Obviously we have a setup error or something as there is a 20gig drive in the mySQL server. mysql database Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing

Change Date

ate format) The 'expdate' is the date that I need to extract with the incorrect date format. thx's Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rai

Multiple queries

ck): select format(sum(p.amt_check),2) as TotalCheck from payin p,payhistory ph where ph.paydate between '2001-09-01' and '2001-09-14' and p.payid = ph.payid; == Appreciate any suggestion or help. mysql database. M

Reset Auto Increment

alter" syntax to reset it?? thx's mysql database Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel:

Syntax Help - CANCEL

;> >>If I remove the "format()" from the query, it works prefectly! I'm trying to >format the result. >> >>Any help, appreciated! ;) >> >>mysql data

Syntax Help

ck != '0.00') MySQL said: You have an error in your SQL syntax near ') as Badcheck from payout p,payhistory ph where ph.paydate between '2001-09-2' at line 1 If I remove the "format()" from the query, it works prefectly! I'm trying to format the

Interesting results

data, all came back without running either isamchk or myisamchk utilities! I just thought I'd pass this on. :) Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel:

Re: Query Help

ble, "customers" each account is created in a "customer" table, the orderid is an >auto increment type and this is what ties the "tags" and "membership" table to the

Re: Query Help

>> > KEY `days` (`days`) >>> > ) >>> > >>> > CREATE TABLE `tags` ( >>> > `tagid` int(8) NOT NULL auto_increment, >>> > `orderid` int(8) NOT NULL default '0', >>> > `finderid

Re: Query Help

E `tags` ( >>> `tagid` int(8) NOT NULL auto_increment, >>> `orderid` int(8) NOT NULL default '0', >>> `finderid` int(8) NOT NULL default '0', >>> `tagnumber` varchar(10) NOT NULL default '', >>> PRIMARY K

Query Help

;membership" tables. I just can't seem to get the results I need. Any help would be much appreciated. Mysql version 3.23.40 THX's Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain In

Re: MySQL error 145

, TIME_STAMP, ACCTSESSIONTIME, >>ACCTINPUTOCTETS, ACCTOUTPUTOCTETS , FRAMEDIPADDRESS from ACCOUNTING where >>USERNAME = 'jhfgd' and ACCTSTATUSTYPE='Stop' order by TIME_STAMP': Can't >>open file: 'ACCOUNTING.MYD'. (errno: 145) Mike(mickalo)B

Re: DBI bug, InnoDB bug, MySQL bug, or I'm just plain missing something.

th DBI. >> >>Has anyone seen this problem? Is do'ing the BEGIN and COMMIT valid? Eric, the only way this is affective, is if your using transaction supported table handlers, like BDB or Innodb. If your using MYISAM type tables, this has no affect. If I'm understanding your p

Re: mysql only stores one word?

r "description" I put in "My little white dog" it only stores "My" in >the database. Would appreciate any insight you may have! Thanks. what type of column are you using in your table, the data type, CHAR, VARCHAR, TEXT,..etc.. ?? Mike(mickalo)Blezien =-=-=-=-=-=

Re: I blew it big time... locked myself out of mysql

7;help;' or '\h' for help. Type '\c' to clear the buffer >>mysql> grant all privileges on *.* to root@localhost identified by 'xx'; >>ERROR 1047: Unknown command that should be: grant all on *.* to root@localhost identified by 'xx' with g

Re: encrypt/decrypt question

there but >they couldn't understand them by just reading it. >> >>It may be a dump question but I would be greatly appreciated for any suggestion >or help. Mi

Re: help (urgent!!!) with a query

yng to do is to delete all records that are 3 (or more) days old >>i've looked around in the manual but couldn't find a "working answer", date >>functions are only explained for select queries... I believe that should TIMESTAMP_COLUMN(curdate(), interval 3 day) &

Re: Zerofill Auto_Increment

2'; or SELECT * FROM table_name WHERE memid = '0012'; >>> >>>I get the same results, whether I use '12' or '0012' >>> >>>Is this suppose to do that?? Just curious :) >> >> >>LAST_INSERT_ID() returns a function

Zerofill Auto_Increment

M table_name WHERE memid = '0012'; I get the same results, whether I use '12' or '0012' Is this suppose to do that?? Just curious :) THX's Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providi

Zerofill Auto_Increment

M table_name WHERE memid = '0012'; I get the same results, whether I use '12' or '0012' Is this suppose to do that?? Just curious :) THX's Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providi