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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-