Re: perl dbh-quote and numeric columns
Walt,
Use Perl's 'undef' for NULL values.
$quoted_some_variable = undef;
now the $quoted_some_variable will be a null value.
On Thu, 27 Jun 2002 12:50:55 -0400, walt [EMAIL PROTECTED] wrote:
I'm in the process of re-writing 100+ perl CGIs written for oracle to mysql.
Does anyone know how to get the dbh-quote(some_value) function in perl to
return the string NULL if some_value is empty. Currently its returning
'' (2 ticks) and when you update a numeric column, it sets the value to 0
zero.
For example:
update kids set age = '' where bla bla...
sets the value of age to 0 which is not NULL
That works fine for oracle, but not mysql. I would perfer not to litter the
code with a bunch of
if (length($some_variable) == 0)
{ $quoted_some_variable = NULL; }
else
{ $quoted_some_variable = $dbh-quote($some_variable); }
sql, query
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(985)902-8484
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-
Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
TCP/IP Host setup
Hello, We currently have two MySQL server/clients running on a RH/Linux 6.2 box, 3.23.40(production) and 3.23.49(development) We would like to setup the .49 with a TCP/IP host instead of a socket. The .49 is using the port 3307, the default server hostname is justlightening.justlightening.net(216.118.81.2), but we would like to setup a hostname something like mysql.justlightening.net My question is, what is the best way to setup a hostname without using the default server hostname for a TCP/IP connection, and do we need to enable skip-networking(ON), right now it's OFF thanks, sql,mysql Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: Connection Problem
Will,
In your $dbh connection handler, you need to change the host=localhost and
database= to just localhost and the database name.
$dbh = DBI-connect (DBI:mysql:localhost;database_name,
**, ***, {PrintError = 0, RaiseError = 1});
On Fri, 24 May 2002 16:43:50 +, Will K. [EMAIL PROTECTED] wrote:
I am trying to get an online database set up and running, but I keep getting
error messages at login.
Here are two sample scripts I have been running (both are from Paul DuBois'
book MySQL and Perl for the Web).
## SCRIPT 1 ##
#! /usr/bin/perl -w
# intro4.pl - generate a Web page using the CGI.pm object-based interface
use strict;
use CGI;
my $cgi = new CGI;
print $cgi-header (),
$cgi-start_html (My Page Title),
$cgi-p (My page body),
$cgi-end_html ();
exit (0);
## SCRIPT 2 ##
#! /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=***,
**, ***, {PrintError = 0, RaiseError = 1});
$sth = $dbh-prepare (SELECT name, wins, losses FROM teams);
$sth-execute ();
$count = 0;
while (my @val = $sth-fetchrow_array ())
{
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-
Before posting, please 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Perl version of phpinfo()
On Fri, 8 Mar 2002 12:33:24 -0800 (PST), Margie New [EMAIL PROTECTED] wrote: Is there a Perl function similar to php's phpinfo() that echos or returns a complete synopsis of the Perl configuration core? We are trying to determine whether the MySQL DBI/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 Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: Stepping through a MySQL_fetch_array in PHP?
For $26 a month! That'll buy some excellent reference material instead :)
On Thu, 7 Mar 2002 11:47:51 -0500, Keith Elder [EMAIL PROTECTED] wrote:
Hi Gavin,
I didn't know if you knew this or not but there is a site which
provides lives PHP / MySQL support. Take a look at http://www.phphelpdesk.com . It
is a live PHP support site which helps you get real time answers to PHP problems.
Keith
* Gavin Philips-Page ([EMAIL PROTECTED]) wrote:
User-Agent: Microsoft-Entourage/9.0.2509
Date: Thu, 07 Mar 2002 18:20:31 +0200
Subject: Stepping through a MySQL_fetch_array in PHP?
From: Gavin Philips-Page [EMAIL PROTECTED]
To: MySQL Problems [EMAIL PROTECTED]
Could anybody please help:
In the query I have included a limit string which allows me to display
individual records page by page. The limit string variable is
incremented/decremented using hyperlinks. I feel it would be better if I
could somehow manually step through the returned
$query_data = mysql_fetch_array($result). Is it possible to create a loop
with a counter to step through the records contained in the array?
// PHP Code
$link_id = db_connect($default_dbname) ;
if(!$link_id) error_message(sql_error()) ;
$query = select count(*) from $user_tablename ;
$result = mysql_query($query) ;
if(!$result) error_message(sql_error()) ;
$query_data = mysql_fetch_row($result) ;
$total_num_user = $query_data[0] ;
if(!$total_num_user) error_message('No records found!') ;
$query = select usernumber, userid, userpassword, username, sex,
nationality, usermail, userprofile, registerdate, date_format(registerdate,
'%M, %e, %Y') as formatted_registerdate, lastaccesstime,
date_format(lastaccesstime, '%M, %e, %Y') as formatted_lastaccesstime from
$user_tablename $order_by_str $sort_order_str $limit_str ;
$result = mysql_query($query) ;
if(!$result) error_message(sql_error()) ;
$query_data = mysql_fetch_array($result) ;
// Table displaying the found records from MySQL database
Thanx
Gavin
###
Keith Elder
Email: [EMAIL PROTECTED] AIM: ZZorKKa YIM: keitheld
Phone: 1-734-507-1438
Text Messaging (145 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!
###
-
Before posting, please 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-
Before posting, please 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: perl mysql DBI::db question
Try moving your $dbh-disconnect call after it prints out the fetchrow_array()
my ($t_user,$t_password,$t_prefs) = $sql_check-fetchrow_array();
if($debug_state) {
print S: $t_user,$t_password,$t_prefs\n;
}
$dbh-disconnect();
If your using an older version of DBI, like 1.13 or .14 you may need to call the
finish() after you execute() your statement handle.
sql,database,mysql
On Wed, 27 Feb 2002 11:07:51 -0500, Shon Stephens
[EMAIL PROTECTED] wrote:
i am trying to write a program in perl and am getting a mysql error from my
module. here is the error:
DBI::db=HASH(0x294738)-disconnect invalidates 1 active statement handle
(either destroy statement handles or call finish on them before
disconnecting) at ./pop.pl line 124, GEN1 line 2.
i think a finish statement is what i need, but i don't know how to exec it
properly. here is the code loop that generates this message
my $sql_check = $dbh-prepare(select user,password,prefs from users
where username='$LNAME');
# 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;
if($debug_state) {
print S: $t_user,$t_password,$t_prefs\n;
}
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-
Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: perl mysql DBI::db question
On Wed, 27 Feb 2002 10:40:21 -0600, nickg [EMAIL PROTECTED] wrote: You need to tell the handler you are finished with your statement, this will free resources, etc.. http://www.savebaseball.com/mysql/DBD_3.21.X.php3#finish $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 the man pages of the DBI docs :) sql,mysql,database Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: MOD_AUTH_MYSQL and apache
On Tue, 19 Feb 2002 13:10:01 -0500, John Lord [EMAIL PROTECTED] wrote: HAS anyone every used this Module to access mysql before , i have it working with clear text passwords just fine but when i took the encrypted ones from my old .htpasswd 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: running mysqlhotcopy error
mysqlhotcopy uses the DBI to connect to the mysql database, Perl's API for accessing the database. On Mon, 18 Feb 2002 18:44:24 +0100, [EMAIL PROTECTED] wrote: I'm trying to run mysqlhotcopy for the first time. I get an error that looks like this $ ./mysqlhotcopy X /opt/mysql-3.23.32-sun-solaris2.7-sparc/backup Can't locate DBI.pm in @INC (@INC contains: /usr/local/lib/perl5/5.00503/sun4-solaris /usr/local/lib/perl5/5.00503 /usr/local/lib/perl5/site_perl/5.005/sun4-solaris /usr/local/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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: Perl core API
you may wish to post this to the DBI mailing list: [EMAIL PROTECTED] On Mon, 18 Feb 2002 15:43:59 -0700, Rodney Broom [EMAIL PROTECTED] wrote: Has anybody ever talked seriously about a Perl API for MySQL? I'd like to be able to access all phases 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
OT: Auth_MySQL
Hello All, sorry about the off-topic... somewhat :) We are going to be implementing the mod_auth_mysql apache module on a client's site. And I was wondering, when using this module for password protection, and the appropriate .htaccess file is put into the protected directory, do I need to specify a specific host, username and password in the httpd.conf in order to connect to the MySQL database that stores the httpd_auth table with the usernames and passwords or does the user, where the .htaccess file is located require access privileges to the database?? IE. user account foobar has an account setup: /home/foobar/public_html on the server now foobar puts a .htaccess file in their /home/foobar/public_html/members folder... does foobar need to have to access privileges to MySQL database that stores the httpd_auth table that stores their valid username 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 Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: Is The MySQL Mailing List On Crack?
On Tue, 12 Feb 2002 17:15:24 -0800, Jeremy Zawodny [EMAIL PROTECTED] wrote: I'm getting duplicate messages separated by several hours. Am I alone in this, or are others seeing it too? Jeremy -- Yep... it seems the list mailings have gone wacko the last day or two! :) sql database mysql Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: Obtaining GMT time in mySQL
Using Perl: my $GMTdate = gmtime(time); this will give you the GMT time. On Tue, 05 Feb 2002 15:27:18 +1100, Oliver Mannion [EMAIL PROTECTED] wrote: Right. Perl seems to work with daylight savings, how is this? At 08:03 PM 4/02/2002 -0800, James Montebello wrote: UTC doesn't do daylight savings. One reason is that different places do daylight savings at different times. We here in the Western US, for example, are in standard time right now. In Arizona, they don't do daylight savings at all. james montebello On Tue, 5 Feb 2002, Oliver Mannion wrote: I am close to a solution: select FROM_UNIXTIME(UNIX_TIMESTAMP(), '%Y %D %M %h:%i:%s %x'); UNIX_TIMESTAMP() returns the number of seconds since '1970-01-01 00:00:00' GMT Convert this to a date format and you have a GMT date. Thanks to Chris Land for pointing the UNIX_TIMESTAMP() function out to me. The only prob is daylight savings. We in NSW, Australia are currently in daylight savings and the date returned doesn't accomodate for that. Any one have any ideas why? [mysql] Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: setup/DBI issues...
Chris, It appears your missing the 'host' in your connection DBI:mysql:$UserID:localhost,... On Fri, 1 Feb 2002 12:39:31 -0800 (PST), Chris Petersen [EMAIL PROTECTED] wrote: I did. it dies with unknown error - hence my confusion. and for those who didn't catch it, the userid and database name are identical (hence the double usage of $UserID in the connect parameters).. -Chris On Fri, 1 Feb 2002, Colin Faber wrote: To: Chris Petersen [EMAIL PROTECTED] From: Colin Faber [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Re: setup/DBI issues... Date: Fri, 01 Feb 2002 13:16:49 -0700 A little more information would be helpful, Such as pasting the exact error here. Chris Petersen wrote: ok, after several months away from working with mysql, I figured I should get back into things.. anyway, the server is up and running, 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:$UserID, $UserID, $DBPass); This works on other servers, and is not limited to one single script, so I know it's a config issue on my part.. any help would be greatly appreciated. -Chris Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL gurus - easy one.
On Tue, 29 Jan 2002 08:08:44 +0300, Odhiambo Washington [EMAIL PROTECTED] wrote: Please forgive my bad step of joining the list and begining with questions. I'm a NEWBIE at MySQL with very minimal knowledge. I'm beginning to learn (self-teaching). 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 Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: any good web hosting with php and mysql support?
Check out Just Lightning: http://www.justlightening.net On Mon, 14 Jan 2002 13:55:00 -0500, NDPTAL85 [EMAIL PROTECTED] wrote: On Monday, January 14, 2002, at 01:17 PM, Gurhan Ozen wrote: Hi All, I am currently looking for a reliable web host to host my personal website. I know there are millions of web hosting companies that have PHP and MYSQL support but I just can't trust any of the fully-assured and confident webhosting ads anymore. I would like to get a service from a company for which someone can vouch. I did started hosting my web site at a webhoster that promised 99.99% uptime and my site is hardly ever up and running. They don't answer my emails either. IS there anyone 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 apologize to both lists, so you might want to reply to my email rather than sending it to list(s). Thank you very much. Gurhan Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie Question: Float Type Range
On Sat, 05 Jan 2002 11:28:54 -0800, Kevin Campbell [EMAIL PROTECTED] wrote: Im using a field in a form to record money values: 0.00 9000.00 in my database table. Im planning on using float(4,2). Does the 4 mean the maximum number of digits before the 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://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Monitor Mysql Server
Hello, Sorry for the OT,.. but I was hoping someone may suggest a script that can monitor multiple mysql servers. We have two running and I would like to setup a cron to check the servers once an hour or so to make sure it running and if not, it would be capable of restart the 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 Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: dbi accessor for mysql_insertid
That should be:
$dbh-{mysql_insertid}; if retrieving from a database handle, otherwise use
$sth-{mysql_insertid}; if from a statement handle.
On Fri, 14 Dec 2001 19:45:02 -0600, Rich Duzenbury [EMAIL PROTECTED] wrote:
DBI version 1.15
DBD::mysql 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?
Would you mind telling me what version you are running? Thank you.
Regards,
Rich
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-
Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: Performance
On Thu, 13 Dec 2001 09:33:10 -0800, Michael Migal [EMAIL PROTECTED] wrote: Opening and closing connections on any database is very expensive operation in terms of time. It is better to keep a connection open, if possible, until you have completed displaying the 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 Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: Each user have only see databases they have access too
Which group(s) would this go under in the my.cnf ?? On Wed, 12 Dec 2001 07:27:54 -0600, Kelly Firkins [EMAIL PROTECTED] wrote: I believe that phpmyAdmin uses the show databases syntax to see what is available. To prevent it from seeing any db which the user is not authorized, set the safe_show_database = 1 in the my.ini file (or my.cnf). This will prevent show databases from returning a list of all dbs available. kelly Im running MySQL on my Win98 Desktop and Ive 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. Always an Email Away Kevin Campbell Chief Executive Officer The Club Mix, Inc. http://www.theclubmix.com Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
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! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: Each user have only see databases they have access too
Kelly, If you use the 'skip-show-database' in the [mysqld] group in the my.cnf file, this will give you the same results at start up [mysqld] skip-show-database This will then disable any user from viewing other databases they do not have access too. On Wed, 12 Dec 2001 19:35:29 -0600, Kelly [EMAIL PROTECTED] wrote: My apologies, I was writing that from work, without immediate access to a box running mysql. I tried it just now and have been having problems attempting to put it into a config file. So far, I've only 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 [EMAIL PROTECTED] To: Kelly Firkins [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 11:36 AM Subject: Re: Each user have only see databases they have access too Which group(s) would this go under in the my.cnf ?? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
startup command line
Hello, We currently have two separate MySQL version running, one w/innodb and bdb tables and the other w/o transaction table handlers. We normally shutdown/restart the servers using the --defaults-file=/path/to/my.cnf Now if I want to restart the server w/innodb and bdb tables, and do not want to use the the bdb, if I use the command line: safe_mysqld --defaults-file=/path/to/my.cnf --skip-bdb even tho it was compiled w/bdb tables and has the setting in the my.cnf for them, will the command line over ride the settings in the my.cnf, hence disabling bdb tables untill the server 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)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: just moved from windows to linux mysql
Just to add a few side notes. We have 2 MySQL's running on a RH/Linux 6.2 box, and it has proven to be very stable and very reliable. :) We have approx., 30+ clients that use the one of the MySQL servers, and we set up each client with a .my.cnf in each of the respective root directories: /home/user_name/.my.cnf so when they login thru the shell, all they need to do is type in at the prompt: $bash mysql and they are logged into their database. We do use their UN*X account username and password, as they find this easier then trying to remember separate username/password or password to access the MySQL client. This has worked very well for us :) On Thu, 6 Dec 2001 14:46:19 -0500, Erik Price [EMAIL PROTECTED] wrote: Good move. 1) when I am logged into linux as user1 and I create a database, does this mean that my username and password for the database will be the same as the linux login, or do you have to set username and password when you are creating the database? Some people are confused by the way MySQL keeps track of users because MySQL also features a user called root (like in Unix/Linux). But be assured that you must create your users in MySQL (using GRANT commands) separate from your Unix/Linux users. For sake of ease, you can use the same names, but you don't have to. If you're in Linux, logged in as User1, you can log in to MySQL as User55 like this: $ bin/mysql -u User55 -p samp_db or you can just let the mysql client program assume that you want to log in to MySQL under the same name as your current Linux username (User1) 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 particular MySQL account. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: Error trying to create InnoDB database. HELP
Did you run the 'mysql_install_db' script after installing MySQL?? the database 'mysql' should be located within the datadir, along with the other databases that are created. On Wed, 5 Dec 2001 10:08:38 -0700 , Weaver, Walt [EMAIL PROTECTED] wrote: Okay, I've finally gotten around to trying to create an InnoDB database. I've configured MySQL on Linux Red Hat 6.2, mysql 3.23.44 with the --with-innodb parm. Everything installed wonderfully. When I start up mysqld, the datafiles and logfiles 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' table comes from or where it's supposed reside. Anyone got any ideas while I work through the documentation I have available. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: Load data infile
Thanks john, After some further checking, the files that I was trying to load back into the db where sent to me from a MAC, and had some strange C/R's in it, causing the file be formatted improperly! After fixing that, all the files loaded into the db fine! :) thx's On Tue, 4 Dec 2001 08:45:27 -0600, john [EMAIL PROTECTED] wrote: remove your line termination and it will not look for this non-existing data and run through the whole file. john -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 10:11 PM To: [EMAIL PROTECTED] Subject: Load data infile Be struggling with this all day, try to figure out why when using the 'load data infile..' all it loads is the first line for the text file and that's it! Table structure: CREATE TABLE `retailtag` ( `prodid` smallint(4) NOT NULL default '0', `tagnumber` varchar(10) NOT NULL default '', `code` varchar(10) NOT NULL default '', UNIQUE KEY `tagnumber` (`tagnumber`,`code`), KEY `prodid` (`prodid`) ) TYPE=MyISAM; QUERY: $mysql load data local infile '/home/tracerta/tmp/retailtag.txt' into table retailtag fields terminated by '|' lines terminated 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've tried it with a CSV format, and TAB format, still the same thing, grabs the first line, and that's it?? is the file in the wrong format?? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: Size of table's MYD file?
On Tue, 04 Dec 2001 12:53:33 -0500, Nissim Lugasy [EMAIL PROTECTED] wrote: Why is it that when I delete records from a table in the database, the size of the table's MYD file does not get smaller. It's still the original size. Do I have to flush the table 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.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Load data infile
Be struggling with this all day, try to figure out why when using the 'load data infile..' all it loads is the first line for the text file and that's it! Table structure: CREATE TABLE `retailtag` ( `prodid` smallint(4) NOT NULL default '0', `tagnumber` varchar(10) NOT NULL default '', `code` varchar(10) NOT NULL default '', UNIQUE KEY `tagnumber` (`tagnumber`,`code`), KEY `prodid` (`prodid`) ) TYPE=MyISAM; QUERY: $mysql load data local infile '/home/tracerta/tmp/retailtag.txt' into table retailtag fields terminated by '|' lines terminated 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've tried it with a CSV format, and TAB format, still the same thing, grabs the first line, 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: Changing the socket location?
You can specify the location when you start up the server --socket=/path/to/mysql.sock or enter it in your my.cnf file: socket = /path/to/mysql.sock in the [mysqld] group On Sat, 17 Nov 2001 21:34:24 -0600, Stephen P Toothman [EMAIL PROTECTED] wrote: I was 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: Running queries while queries are still running
On Fri, 30 Nov 2001 15:25:18 -0700, Ken Kinder [EMAIL PROTECTED] wrote: I have a query. It (should) return one row. It normally does, except when I do something like this: (query) (loop through results) (update table that was in the 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 of DBI/Perl question then MySQL.. ;) Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Problem moving database datadir
Hello All, Hoping someone can point where I may have gone wrong on setting our client's databases within their own respective home directories. Here is one of the setups dir tree and settings: The database 'tracers' is symbolically linked from the datadir to the client's home directory. But for some reason, I keep getting the error message that the tables are 'read only'...! what did I go wrong here?? How can I get MySQL to read/write to the database in the client's home directory?? I thought I had all the owner/grp settings correct. Thanks mysql sql database. # client home dir /home/tracerta/tracers drwxrwxrwx2 tracerta mysql4096 Nov 25 22:57 ./ drwx--x--x 13 tracerta tracerta 4096 Nov 27 12:45 ../ -rw-rw-rw-1 tracerta mysql 0 Nov 25 22:57 customers.MYD -rw-rw-rw-1 tracerta mysql1024 Nov 25 22:57 customers.MYI -rw-rw-rw-1 tracerta mysql9010 Nov 25 22:57 customers.frm -rw-rw-rw-1 tracerta mysql 0 Nov 25 22:57 log.MYD -rw-rw-rw-1 tracerta mysql1024 Nov 25 22:57 log.MYI -rw-rw-rw-1 tracerta mysql8610 Nov 25 22:57 log.frm -rw-rw-rw-1 tracerta mysql 0 Nov 25 22:57 membership.MYD -rw-rw-rw-1 tracerta mysql1024 Nov 25 22:57 membership.MYI -rw-rw-rw-1 tracerta mysql8644 Nov 25 22:57 membership.frm -rw-rw-rw-1 tracerta mysql 0 Nov 25 22:57 onlinetag.MYD -rw-rw-rw-1 tracerta mysql1024 Nov 25 22:57 onlinetag.MYI -rw-rw-rw-1 tracerta mysql8592 Nov 25 22:57 onlinetag.frm -rw-rw-rw-1 tracerta mysql 340 Nov 25 22:57 product_id.MYD -rw-rw-rw-1 tracerta mysql3072 Nov 25 22:57 product_id.MYI -rw-rw-rw-1 tracerta mysql8700 Nov 25 22:57 product_id.frm -rw-rw-rw-1 tracerta mysql 0 Nov 25 22:57 recovery.MYD -rw-rw-rw-1 tracerta mysql1024 Nov 25 22:57 recovery.MYI -rw-rw-rw-1 tracerta mysql8990 Nov 25 22:57 recovery.frm -rw-rw-rw-1 tracerta mysql 14904 Nov 25 22:57 retailtag.MYD -rw-rw-rw-1 tracerta mysql 19456 Nov 25 22:57 retailtag.MYI -rw-rw-rw-1 tracerta mysql8616 Nov 25 22:57 retailtag.frm -rw-rw-rw-1 tracerta mysql 0 Nov 25 22:57 tags.MYD -rw-rw-rw-1 tracerta mysql1024 Nov 25 22:57 tags.MYI -rw-rw-rw-1 tracerta mysql8652 Nov 25 22:57 tags.frm -rw-rw-rw-1 tracerta mysql 0 Nov 25 22:57 temptag.MYD -rw-rw-rw-1 tracerta mysql1024 Nov 25 22:57 temptag.MYI -rw-rw-rw-1 tracerta mysql8602 Nov 25 22:57 temptag.frm # dir /var/lib/mysql/var drwx--2 mysqlmysql1024 Jul 30 19:32 jytinter_db/ -rw-r--r--1 mysqlmysql2276 Nov 14 09:56 my.cnf drwx--2 mysqlmysql1024 Jul 31 08:09 mysql/ -rw-rw-r--1 mysqlmysql 65962 Nov 27 13:51 mysql.log -rw-rw1 mysqlmysql 4 Nov 26 22:51 mysql.pid -rw-rw-r--1 mysqlroot 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/tracerta/tracers/ Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: the official name of 3.23.45 source
Try here: ftp://mysql.valueclick.com/pub/mysql/Downloads/MySQL-3.23/mysql-3.23.45.tar.gz I always find this FTP site with the most up-to-date files and is very reliable! :) On Mon, 26 Nov 2001 10:17:22 -0500, Erik Price [EMAIL PROTECTED] wrote: Can anyone tell me the official name of the MySQL 3.23.45 source code file that is downloaded from the web site (www.mysql.com)? I normally grab it with curl off of my local mirror but they didn't have it yet so I used Internet Explorer to grab the file from another (random) mirror -- but the file is called download.php (which I assume is because the mirror dynamically served that page or something). I have the source code and would like to make sure that it's named consistently, otherwise 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
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 both the Mysql and Mysql-Max binaries both support transactions?? Max only. thanks Paul, that's what I thought. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: .pid file missing
On Thu, 22 Nov 2001 05:56:21 -0800 (PST), Michael Bevan [EMAIL PROTECTED] wrote: I think I erased my .pid file in a misguided effort to reset my password, does anyone know how to re-create it or do I need to do a full SQL re-install? Thanks - 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://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: error when running myql on Linux 7.1
Dana, What I did, to set up a second MySQL on our Linux box, compiled the second copy from source, which gives you a lot more control on how MySQL is installed. then created a my.cnf file with all the relavent settings for the second server, port and socket, pid ...etc.. then put this in the datadir folder. Then when I start up the second server i simple do: safe_mysqld --defaults-file=/path/to/datadir/my.cnf then it starts up the second serve without any problems. We are current running two separate servers. 3.23.40 and 3.23.44 and it's been working fine for about a month now. :) On Thu, 22 Nov 2001 10:38:56 -0600, Dana Sharvit [EMAIL PROTECTED] wrote: Hello, As you probably know mysql comes installed in Linux 7.1 as default. I installed my own mysql server in a different location in the file system, In safe_mysqld I indicated the path in which I want the mysql.sock to be created in but when I start my mysql server I get an error message: Can't start server : Bind on unix socket: No such file or direc tory 06 9:56:26 Do you already have another mysqld server running on socket: /v ar/lib/mysql/mysql.sock ? 06 9:56:26 Aborting the default mysql server on Linux 7.1 is not running but even though I can not run my own mysql server. In order to solve this I created a symbolic link between /var/lib/mysql/mysql.sock to the path of my mysql server and that works fine but I am looking for a better solution - does some one have an idea? Thanks Dana - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Upgrade gcc on Linux
Please excuse the OT posting, but I'm am somwhat in a bind and wasn't sure where to post this question. and I've many references to upgrading from the gcc 2.91 to 2.95 I've installed all the dependency for gcc 2.95.1 and when I attempt to install the rpm gcc-2.95.1 I keep getting this message: [justligh@justlightening ~]# rpm -ivh gcc-* Preparing...### [100%] file /usr/bin/egcs from install of gcc-2.95.1-3 conflicts with file from package egcs-1.1.2-30 file /usr/bin/gcc from install of gcc-2.95.1-3 conflicts with file from package egcs-1.1.2-30 file /usr/bin/gcov from install of gcc-2.95.1-3 conflicts with file from package egcs-1.1.2-30 file /usr/bin/i386-redhat-linux-gcc from install of gcc-2.95.1-3 conflicts with file from package egcs-1.1.2-30 file /usr/bin/protoize from install of gcc-2.95.1-3 conflicts with file from package egcs-1.1.2-30 file /usr/bin/unprotoize from install of gcc-2.95.1-3 conflicts with file from package egcs-1.1.2-30 file /usr/i386-redhat-linux/lib/libiberty.a from install of gcc-2.95.1-3 conflicts with file from package egcs-1 .1.2-30 Not being fimilar with rpm's 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 Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fw: LOAD_FILE does not work
On Wed, 21 Nov 2001 17:02:29 -0500, Christopher Book [EMAIL PROTECTED] wrote: UPDATE Software SET Description = LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file) WHERE ID = 9 You have to make sure that not only can mysql read the file, but it also has permissions to the directories that the files are in. Typically your home directory on your server may not be world readable, but for mysql to access it, it must be. Chris Plus I believe you have to have FILE privileges 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 Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: Exporting Data
Cancel this, I found the problem. Had to grant FILE privileges to this user! total forgot about that! TIA, On Tue, 20 Nov 2001 10:14:52 +0100, Giuseppe Maxia [EMAIL PROTECTED] wrote: You can export using SELECT fieldlist INTO OUTFILE filename FROM table; This will create a file with tab separated fields. It is Excel default separator. Within Excel, you can open the file, by giving filetype text, and a wizard will guide you through the translation. You can create a CSV file by adding , at the end of the SQL statement, FIELDS TERMINATED BY ',' ENCLOSED BY '' thanks, that this should work perfectly. one other question regarding the select .. into outfile.. this is the query being used: SELECT * INTO OUTFILE /home/tracerta/tmp/producd_id.txt FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n' FROM product_id; Now if I log 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). But if 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 ?? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
Re: mysqld shutdown
On Wed, 14 Nov 2001 08:38:04 -0800, Bill Adams [EMAIL PROTECTED] wrote: /usr/local/mysql/bin:mysql$ mysqladmin -u root -p shutdown But this one doesn't work for me, even though I am using the proper password and am the proper user. Executing this command just leaves me hanging at the prompt (and the only way to get out of the hang is to either suspend the job, which also has no effect). Do you have a query still running? E.g. does mysqladmin -uroot -p processlist show 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please 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: http://lists.mysql.com/php/unsubscribe.php
