Re: 5.1.51 Database Replica Slows Down Suddenly, Lags For Days, and Recovers Without Intervention

[Tyler Poland]

Luis,

How large is your database?  Have you checked for an increase in write
activity on the master leading up to this? Are you running a backup against
the replica?

Thank you,
Tyler

Sent from my Droid Bionic
On Oct 23, 2011 5:40 AM, Luis Motta Campos luismottacam...@yahoo.co.uk
wrote:

 Fellow DBAs and MySQL Users

 [apologies for eventual duplicates - I've posted this to
 percona-discuss...@googlegroups.com also]

 I've been hunting an issue with my database cluster for several months now
 without much success. Maybe I'm overlooking something here.

 I've been observing the database slowing down and lagging behind for
 thousands of seconds (sometimes over the course of several days) even
 without any query load besides replication itself.

 I am running Percona MySQL 5.1.51 (InnoDB plug-in version 1.12) on Dell
 R710 (6 x 3.5 inch 15K RPM disks in RAID10; 24GB RAM; 2x Quad-core Intel
 processors) running Debian Lenny. MySQL data, binary logs, relay logs,
 innodb log files are on separated partitions from each other, on a RAID
 system separated from the operating system disks.

 Default Storage Engine is InnoDB, and the usual InnoDB memory structures
 are stable and look healthy.

 I have about 500 (read) queries per second on average, and about 10% of
 this as writes on the master.

 I've been observing something that looks like between 6 and 10 pending
 reads per second uniformly on my cacti graphs.

 The issue is characterized by the server suddenly slowing down writes
 without any previous warning or change, and lagging behind for several
 thousand seconds (triggering all sorts of alerts on my monitoring system). I
 don't observe extra CPU activity, just a reduced disk access ratio (from
 about 5-6MB/s to 500KB/s) and replication lagging. I could correlate it
 neither InnoDB hashing activity, nor with long-running-queries, nor with
 background read/write thread activities.

 I don't have any clues of what is causing this behavior, and I'm unable to
 reproduce it under controlled conditions. I've observed the issue both on
 severs with and without workload (apart from the usual replication load). I
 am sure no changes were applied to the server or to the cluster.

 I'm looking forward for suggestions and theories on the issue - all ideas
 are welcome.
 Thank you for your time and attention,
 Kind regards,
 --
 Luis Motta Campos
 is a DBA, Foodie, and Photographer


 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/mysql?unsub=tpol...@engineyard.com

Re: select ... into local outfile ... ???

[Tyler Poland]

Dennis,

The following closely simulates the default INTO OUTFILE, you'll have 
to modify it slightly for your purposes:

mysql --delimiter=comma -N  select_statement.sql \
  | sed 's/\/\\\/g' \
  | sed 's/\t/\,\/g' \
  | sed 's/$/\/g' \
  | sed 's/^/\/g' \
  | sed 's/\NULL\/\\N/g' \
  | sed 's/\\t/\t/g' '  output.txt


Tyler
*

*On 9/2/11 3:40 PM, Dennis wrote:

hi, there,
the following is my sql statement:
SELECT   HIGH_PRIORITY   SQL_BIG_RESULT   SQL_NO_CACHE
   tb.url_sign,  m_url,m_title,   m_weightINTO OUTFILE   '/tmp/a.csv'  
FIELDS TERMINATED BY ','  ENCLOSED BY '\'   LINES  TERMINATED BY '\n' STARTING 
BY '='
FROM d_local.ta, d_news.tbWHERE ta.url_sign = tb.url_sign

Before, the server and the client were on the same machine; now, I need to generate the 
output file on client (which is on a different machine from the server). But it seams 
that there is no select ... into LOCAL file statement.Any suggestion is 
appreciated.
Dennis

Re: MySQL replication server

[Tyler Poland]

Additionally, if a user has the SUPER privilege (eg. all privileges on 
*.*) they can write to a database running in read-only mode.  Yet 
another reason to never allow this privilege for general purpose users.


Tyler

On 11/22/10 8:08 AM, John Daisley wrote:

The replicated database should not be accepting writes, if it is then you
haven't set it up correctly

On 22 November 2010 13:03,a.sm...@ukgrid.net  wrote:


Hi,

  I think you are wrong, slaves will always accept writes unless you set
readonly in the mysql config.
Due to this, and if you dont specifically set readonly on the slave you
have to be very careful in order to maintain data integrity on the slave and
also not to break repliacton. Tools like Maatkit are designed to check data
integrity on the slave due to exactly this issue,

thanks Andy.


Quoting John Daisleydaisleyj...@googlemail.com:

You are correct, in a master slave setup the slave does not accept writes.

John

On 22 November 2010 11:06, Machiel Richardsmachi...@rdc.co.za  wrote:











--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Changing database tables to different storage engine.

[Tyler Poland]

Machiel,

Each table will be write locked while it is being altered so this will 
most likely impact the application.  In addition to the write lock, the 
conversion causes each table to be completely rewritten in the new 
format so this will have a high impact on IO write activity and so it 
will impact overall IO throughput.  If your application is mostly reads, 
is well cached in memory, and the tables are small this should be pretty 
fast and relatively pain free.  If you aren't sure about the impact and 
conversion time you may want to restore a backup of the database to 
another location and run through the conversion while monitoring 
performance numbers.


Tyler


On 11/22/10 5:55 AM, Machiel Richards wrote:

Thank you John

   I have in the meantime fond this to be the case (** someone
changed config files without my knowledge it seems as this was setup
properly and working**)

 Anyhow, in order for the innodb to be active again I need to
restart the database, however aftewards I assume the tables will still
be MyIsam.

 In this event I will need to manually alter each table, and I am
concerned about the impact of this on the system performance.

Regards
Machiel


-Original Message-
From: John Daisleydaisleyj...@googlemail.com
To: Machiel Richardsmachiel.richa...@gmail.com
Cc: mysql mailing listmysql@lists.mysql.com
Subject: Re: Changing database tables to different storage engine.
Date: Mon, 22 Nov 2010 10:51:23 +

I have frequently seen Innodb 'silently' disabled if the
innodb_log_file_size is different to the files size on disk (quite
common when moving systems about). You wont be able to use innodb until
you resolve this either by deleting the log files and restarting
mysqld so they get recreated or changing the innodb_log_file_size to
match the size of the files on disk.

If the Innodb engine is not available then MySQL will use the default
(usually MyISAM) storage engine even if Innodb was specified. You can
stop this behaviour by setting sql-mode=NO_ENGINE_SUBSTITUTION

Regards

John


On 22 November 2010 10:12, Machiel Richardsmachiel.richa...@gmail.com
wrote:

 Hi All

Sorry but things have now changed, and I found the following.


The tables was in fact restored as Innodb, however
 someone seems
 to have gone and changed something causing innodb to be
 disabled, this
 caused the tables to be defaulted back to MyIsam.

Should this not rather have just resulted in an error
 allowing
 to fix the problem in the first place instead of changing the
 storage
 engines?

Anyone have some thoughts on the best solution to fix
 this? I
 will look into the innodb not working soon.

 Machiel




 -Original Message-
 From: Machiel Richardsmachi...@rdc.co.za
 To: mysql mailing listmysql@lists.mysql.com
 Subject: Changing database tables to different storage engine.
 Date: Mon, 22 Nov 2010 11:59:03 +0200


 Good day all

Hope all is well.

 I have something to ask as someone might have done
 this as
 well and may have a good solution on how to fix this.

During a database migration this weekend to move a
 MySQL
 database from windows to linux, we created a backup and restore
 of the
 database.

However, form my part I made a mistake by overlooking
 the
 fact that the windows database was configured to use default
 storage
 engine as Innodb.

On the new server, the default was set to MyIsam.

   This resulted in all the tables being restored to
 the new
 system as MyIsam instead of Innodb.

In order to fix this, I know you can use alter
 table to
 change the storage engine, however I need to know the following:

1. this is a production system and can't
 afford any
 downtime or as little performance degration as possible.

What is the best way to do this in
 order to
 have the least amount of effect on the database and it's
 performance?


 Regards
 Machiel









--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: uninstall/reinstall

[Tyler Poland]

 Tammie,

You might just try resetting the root password 
http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html#resetting-permissions-windows.


Hope this helps,
Tyler



On 10/19/10 12:38 PM, Montgomery, Tammie wrote:

I had an old version of mySQL on my computer but never used it. I thought I 
knew the root password but it wouldn't let me in. I went ahead and uninstalled 
it thinking I would get a newer version anyway. I used the Windows interface to 
uninstall the previous version. It appeared to be gone but when I installed the 
new version, it asked me what the previous root password was and then give new 
one. I left previous blank and gave it the new password. Now it has been 
sitting at the screen in the configuration wizard for Apply security settings 
for about 20 minutes. How should I recover from this?

Barracuda 400 vers 3.5.12 Checked - Virus Free




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL crashes

[Tyler Poland]

Charlene,

You should check the mysql error log and if there isn't a message about 
the cause there you may want to check /var/log/syslog for mysql being 
killed by oomkiller.


Tyler

On 6/21/10 11:11 AM, Charlene wrote:
Anybody have any idea why MySQL would start to have this error message 
every 4 or so days at midnight:


Connection error: Can't connect to local MySQL server through socket 
'/var/lib/mysql/mysql.sock' (2)


This just started happening a little more than 2 weeks ago.  The 
server has been running fine for almost two years.


MySQL is on a Linux system.  There are about 750 dbs and accessed by 
approximately half that number websites (375).  Half of the websites 
are on a different server than the MySQL server.


Charlene




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Trouble compiling C on OS X

[Tyler McMullen]

First off, I apologize for the fact that I'm not more versed in the inner
workings of GCC and linking libraries and etc, I'm a web developer and I'm
just using C to try to cut down on some speed problems.

This is my little test program:
#include stdio.h
#include stdlib.h
#include math.h
#include mysql.h

MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW row;

void exiterr(int exitcode) {
   fprintf( stderr, %s\n, mysql_error(mysql) );
}

int main( int argc, char *argv[] ) {
   uint i = 0;

   if(!(mysql_connect(mysql,localhost,root,password)))
   exiterr(1);

   if (mysql_select_db(mysql,hallow))
   exiterr(2);

   if(mysql_query(mysql,SELECT * FROM sections))
   exiterr(3);

   if(!(res = mysql_store_result(mysql)))
   exiterr(4);

   while((row = mysql_fetch_row(res))) {
   for(i=0; i  mysql_num_fields(res); i++)
   printf(%s|,row[i]);
   printf(br);
   }

   mysql_free_result(res);
   mysql_close(mysql);
   return 0;
}

and I'm attempting to compile it with this command:
gcc -I/usr/include concept.c -L/usr/lib/mysql -lmysqlclient -lm -o concept
-lz

I'm quite certain that the header files are in /usr/include.  And, what I
assume to be the libraries are in /usr/lib/mysql. (libdbug.a,libmygcc.a,
libmysql.imp, etc...)

This is the error I get when trying to compile:
/usr/bin/ld: Undefined symbols:
_mysql_connect
collect2: ld returned 1 exit status

Any thoughts on why this might be happening?  Is there any other information
that I can provide which will help to determine whats wrong?

Thanks in advance for the help,
Tyler McMullen

A little help with this select?

[Tyler Longren]

Hi,

I'm baffled.  Been lookin at this for the last hour now.

SELECT worker.fname,worker.lname,worker.workerid FROM
worker,webprojectassign WHERE worker.workerid!=webprojectassign.workerid
ORDER BY worker.lname ASC;

That's the SQL in question.  There's currently nothing in the
webprojectassign table.  So shouldn't this SQL just return the
fname,lname,workerid from the workers table?  Could someone just
explain to me why this doesn't work the way I expected it to?

Maybe I'm doing something wrong.

THANKS!

Best Regards,
--
Tyler Longren
J.D. Web Services, L.C.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: A little help with this select?

[Tyler Longren]

Rory, that's awesome.  Exactly what I needed.  After reading your first
reply I wrote a query that was very similar to the one you just posted
(included below).  It didn't quite work right however.  It was still a
lot closer than I was before.  Thanks again!

SELECT worker.fname,worker.lname,worker.workerid FROM worker LEFT JOIN
webprojectassign ON worker.workerid = webprojectassign.workerid WHERE
webprojectassign.workerid IS NULL ORDER BY worker.lname ASC

Tyler

On Tue, 2004-01-06 at 02:22, Rory McKinley wrote:
 On 6 Jan 2004 at 9:31, Noamn wrote:
 
  Rory wrote:
  The query is behaving exactly as it should. Your query asks it to return
  only those 
  workers that are listed in the webprojectassign table. Seeing as there are
  no entries in 
  the webprojectassign table, no workers match and hence no results are
  produced.
  
  No'am adds:
  I think that Tyler wanted the workers who aren't listed in the
  webprojectassign table - his query contains
  WHERE worker.workerid!=webprojectassign.workerid
  
  Is != a different way of writing ?
  
  If he wants the unassigned workers, then he needs what I've seen referred to
  as a 'theta join', and I too would be interested to see how to do this in
  mySQL. When I've needed such a query, to find 'childless' records, I've
  always done it with a looped query in the client program.
  
  
  -Original Message-
  From: Rory McKinley [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, January 06, 2004 9:19 AM
  To: Tyler Longren; [EMAIL PROTECTED]
  Subject: Re: A little help with this select?
  
  
  On 6 Jan 2004 at 1:00, Tyler Longren wrote:
  
   Hi,
   
   I'm baffled.  Been lookin at this for the last hour now.
   
   SELECT worker.fname,worker.lname,worker.workerid FROM
   worker,webprojectassign WHERE worker.workerid!=webprojectassign.workerid
   ORDER BY worker.lname ASC;
   
   That's the SQL in question.  There's currently nothing in the
   webprojectassign table.  So shouldn't this SQL just return the
   fname,lname,workerid from the workers table?  Could someone just
   explain to me why this doesn't work the way I expected it to?
   
   
  
  
  -- 
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
  
  
 
 Oooops...my apologies to all...I guess it helps if one actually reads properly.
 
 In this case, the solution to Tyler's problem will be a left join. The query should 
 look 
 something like this :
 
 SELECT worker.fname,worker.lname,worker.workerid FROM
   worker LEFT JOIN webprojectassign ON worker.workerid = 
 webprojectassign.workerid WHERE webprojectassign.workerid IS NULL
   ORDER BY worker.lname ASC
 
 This will retrieve all the worker details where there are no matching entries in the 
 webprojectassign table.
 
 
 Rory McKinley
 Nebula Solutions
 +27 82 857 2391
 [EMAIL PROTECTED]
 There are 10 kinds of people in this world, 
 those who understand binary and those who don't (Unknown)


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problems with MySQL on Linux (Linux Newbie)

[Donald Tyler]

Hi,

 

I am just learning to use Linux and I am having some problems with
getting MySQL to load.

 

I have successfully installed  tested both Apache  PHP, so I am pretty
comfortable with the whole configure and make processes.

 

I followed the MySQL installation docs to the letter, however when I try
to load the MySQL daemon as instructed, the program just quits after a
few seconds. Here is the terminal output:

 

[EMAIL PROTECTED] mysql]# ./bin/mysqld_safe --user=mysql 

[1] 30010

[EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from
/var/lib/mysql

030923 09:30:18 mysqld ended

 

Anyone know what I am doing wrong?

 

Thanks

RE: [PHP] Lost Connection to MySQL server during query

[Donald Tyler]

I am using mysql_connect. But I just changed it to mysql_pconnect and it did
exactly the same thing.

-Original Message-
From: Marek Kilimajer [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 09, 2003 10:48 AM
To: Donald Tyler
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Lost Connection to MySQL server during query

Are you using mysql_pconnect or just mysql_connect?

Donald Tyler wrote:

 I have a script that is processing data from a single table and splitting
it
 into smaller normalized tables.
 
  
 
 The script takes anywhere between 5-10 minutes to complete, and as it runs
 it constantly outputs a report on its progress.
 
  
 
 The script seems to run fine the first time I run it, but with subsequent
 runs (To see if it incorrectly creates duplicates of records etc), after a
 couple of minutes the script ends with an error message saying Lost
 connection to MySQL server during query.
 
  
 
 During the first run, the script is mostly just chopping up the data and
 placing it in the new tables, and doing a little comparing. But during
 subsequent runs, all of the records in the new tables should already
exist,
 so the script see's this, and instead of creating new records, it compares
 them to see if its correct.
 
  
 
 Does anyone have any idea why it would be losing connection all the time?
 
  
 
 This is just being run on a test server at the moment. Being used as the
 server and also the client, configured as follows:
 
  
 
 Windows XP Tablet Edition
 
 PHP 4.3.3
 
 PHP Extensions:   XmlRPC
 
 MySQL 4.0.14
 
 Apache 2.0.47
 
  
 
 Please help, this has been making my life hell for a week now!
 
  
 
 Thanks
 
  
 
  
 
 Donald
 
 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Lost Connection to MySQL server during query

[Donald Tyler]

I have a script that is processing data from a single table and splitting it
into smaller normalized tables.

 

The script takes anywhere between 5-10 minutes to complete, and as it runs
it constantly outputs a report on its progress.

 

The script seems to run fine the first time I run it, but with subsequent
runs (To see if it incorrectly creates duplicates of records etc), after a
couple of minutes the script ends with an error message saying Lost
connection to MySQL server during query.

 

During the first run, the script is mostly just chopping up the data and
placing it in the new tables, and doing a little comparing. But during
subsequent runs, all of the records in the new tables should already exist,
so the script see's this, and instead of creating new records, it compares
them to see if its correct.

 

Does anyone have any idea why it would be losing connection all the time?

 

This is just being run on a test server at the moment. Being used as the
server and also the client, configured as follows:

 

Windows XP Tablet Edition

PHP 4.3.3

PHP Extensions:   XmlRPC

MySQL 4.0.14

Apache 2.0.47

 

Please help, this has been making my life hell for a week now!

 

Thanks

 

 

Donald

FW: Can MySQL 4.0.14 store HTML? Among other things....

[Donald Tyler]

Yes it can. But you should understand the three distinct levels of that
situation.

You need the following:

Database
Web Server
Server-Side Scripting Language

I would suggest using AMP (Apache, MySQL  PHP). If you want to know more
about how these work in conjunction I would suggest the excellent book:

Web Database Applications by Oreilly.

It is the perfect beginners guide for this area.

Good luck.


-Original Message-
From: Machiste' N. Quintana [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 08, 2003 3:29 PM
To: [EMAIL PROTECTED]
Subject: Can MySQL 4.0.14 store HTML? Among other things

Hey. I'm New (as you probably can tell), and I was wondering if MySQL 4.0.14
can store HTML, PHP, JavaScript and/or Flash. Can it? I'm assuming it would
be stored as a string, and if outputted by PHP, would it output as HTML? (Or
JavaScript, PHP, or Flash) 



Thanks!



--Machiste' N. Quintana

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

FW: mysql LOAD DATA INFILE

[Donald Tyler]

I see you still have the word LOCAL in there. Did you try and remove it?

To do that in PHPMyAdmin you will need to run the import so you get the
error message and then copy and paste it into the SQL section of the
PHPMyadmin tool. Delete the world LOCAL and then run the query. It should
work.

-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 08, 2003 2:59 PM
To: Donald Tyler; [EMAIL PROTECTED]
Subject: RE: mysql LOAD DATA INFILE


Sorry, that is the error - my mistake.  I am getting this:

LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
TERMINATED BY ';' LINES TERMINATED BY '\r\n'

I am using phpMyAdmin 2.3.3 - would an upgrade to the latest version remedy
the issue?

Thanks,

-Mike



 -Original Message-
 From: Donald Tyler [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 3:42 PM
 To: [EMAIL PROTECTED]
 Subject: RE: mysql LOAD DATA INFILE


 PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just remove the word
 LOCAL and it should work fine.

 -Original Message-
 From: Mike At Spy [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 2:35 PM
 To: [EMAIL PROTECTED]
 Subject: mysql LOAD DATA INFILE


 When I come across this error:

 The used command is not allowed with this MySQL version

 Does this mean that I need a whole different verison of MySQL, or just a
 different compile?  The command was 'LOAD DATA INFILE' and I was doing it
 through phpMyAdmin.

 Thanks,

 -Mike



 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

FW: mysql LOAD DATA INFILE

[Donald Tyler]

Then the only way you can do it that I can think of is to write a PHP script
to do basically what PHPMyAdmin is trying to do but without the LOCAL in
there.

However to do that you would need to be able to place the PHP file on the
server, and I guess you probably can't do that either. Talk about catch
22...

The only other way I can think of is to install MySQL on a machine you
control, then import the data there using the method I suggested earlier. 

Once you have done that, you can use PHPMyAdmin to export the database from
your machine. It should give you a SQL command that will create the data on
another machine. Just copy and paste that into the SQL window on the main
server and that will insert it.

It's a little messy but that's the only other way I can think of doing it.
Sorry.

-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 08, 2003 3:24 PM
To: Donald Tyler; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: mysql LOAD DATA INFILE


Ah.  No wonder it dinna work.  Neither did specifying the columns as Jay
suggested.

I also have no choice but to do it through the browser - I don't have
command line access on the server. :\

-Mike


 -Original Message-
 From: Donald Tyler [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 4:08 PM
 To: [EMAIL PROTECTED]
 Subject: RE: mysql LOAD DATA INFILE


 Oh and just a note. This solution won't work if you are uploading the file
 to the server through the browser. You will need to put the file on the
 server and adjust the commands PATH accordingly.

 -Original Message-
 From: Donald Tyler [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 3:07 PM
 To: '[EMAIL PROTECTED]'
 Subject: FW: mysql LOAD DATA INFILE

 I see you still have the word LOCAL in there. Did you try and remove it?

 To do that in PHPMyAdmin you will need to run the import so you get the
 error message and then copy and paste it into the SQL section of the
 PHPMyadmin tool. Delete the world LOCAL and then run the query. It should
 work.

 -Original Message-
 From: Mike At Spy [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 2:59 PM
 To: Donald Tyler; [EMAIL PROTECTED]
 Subject: RE: mysql LOAD DATA INFILE


 Sorry, that is the error - my mistake.  I am getting this:

 LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
 TERMINATED BY ';' LINES TERMINATED BY '\r\n'

 I am using phpMyAdmin 2.3.3 - would an upgrade to the latest
 version remedy
 the issue?

 Thanks,

 -Mike



  -Original Message-
  From: Donald Tyler [mailto:[EMAIL PROTECTED]
  Sent: Friday, August 08, 2003 3:42 PM
  To: [EMAIL PROTECTED]
  Subject: RE: mysql LOAD DATA INFILE
 
 
  PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just
 remove the word
  LOCAL and it should work fine.
 
  -Original Message-
  From: Mike At Spy [mailto:[EMAIL PROTECTED]
  Sent: Friday, August 08, 2003 2:35 PM
  To: [EMAIL PROTECTED]
  Subject: mysql LOAD DATA INFILE
 
 
  When I come across this error:
 
  The used command is not allowed with this MySQL version
 
  Does this mean that I need a whole different verison of MySQL, or just a
  different compile?  The command was 'LOAD DATA INFILE' and I
 was doing it
  through phpMyAdmin.
 
  Thanks,
 
  -Mike
 
 
 
  --
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:
 http://lists.mysql.com/[EMAIL PROTECTED]


 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/[EMAIL PROTECTED]



 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysql LOAD DATA INFILE

[Donald Tyler]

PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just remove the word
LOCAL and it should work fine.

-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 08, 2003 2:35 PM
To: [EMAIL PROTECTED]
Subject: mysql LOAD DATA INFILE


When I come across this error:

The used command is not allowed with this MySQL version

Does this mean that I need a whole different verison of MySQL, or just a
different compile?  The command was 'LOAD DATA INFILE' and I was doing it
through phpMyAdmin.

Thanks,

-Mike



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysql LOAD DATA INFILE

[Donald Tyler]

Oh and just a note. This solution won't work if you are uploading the file
to the server through the browser. You will need to put the file on the
server and adjust the commands PATH accordingly. 

-Original Message-
From: Donald Tyler [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 08, 2003 3:07 PM
To: '[EMAIL PROTECTED]'
Subject: FW: mysql LOAD DATA INFILE

I see you still have the word LOCAL in there. Did you try and remove it?

To do that in PHPMyAdmin you will need to run the import so you get the
error message and then copy and paste it into the SQL section of the
PHPMyadmin tool. Delete the world LOCAL and then run the query. It should
work.

-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 08, 2003 2:59 PM
To: Donald Tyler; [EMAIL PROTECTED]
Subject: RE: mysql LOAD DATA INFILE


Sorry, that is the error - my mistake.  I am getting this:

LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
TERMINATED BY ';' LINES TERMINATED BY '\r\n'

I am using phpMyAdmin 2.3.3 - would an upgrade to the latest version remedy
the issue?

Thanks,

-Mike



 -Original Message-
 From: Donald Tyler [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 3:42 PM
 To: [EMAIL PROTECTED]
 Subject: RE: mysql LOAD DATA INFILE


 PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just remove the word
 LOCAL and it should work fine.

 -Original Message-
 From: Mike At Spy [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 2:35 PM
 To: [EMAIL PROTECTED]
 Subject: mysql LOAD DATA INFILE


 When I come across this error:

 The used command is not allowed with this MySQL version

 Does this mean that I need a whole different verison of MySQL, or just a
 different compile?  The command was 'LOAD DATA INFILE' and I was doing it
 through phpMyAdmin.

 Thanks,

 -Mike



 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Advice wanted on Data Structure

[Donald Tyler]

I have a question that I hope I can explain well enough:

I am trying to figure out a data structure for an inventory system. The
system contains:

Items
Kits(Made from a collection of Items and/or other Kits)

Now my question is:

Is there any way to structure this in a database so that I could run a
single query to get the contents of a kit, even though it contains other
kits?

My problems occur when I try to create the tables as so:

ITEMS:  KIT_CONTENTSKITS
KIT_IDKIT_ID
ITEM_ID-ITEM_ID   Description
Description
Price
Etc

The only way I could think of to allow a kit to be contained within a kit:

Add another field to KIT_CONTENTS called Sub_Kit

Which seems like a dumb way of doing it, because first of all, most kits
don't have sub kits, so that would be a wasted field in most cases.
Secondly, as far as I know the application logic would have to do multiple
queries's to get the sub_kits.

I really hope there is a simple and more logical way to do this, preferably
allowing me to run a SINGLE query that will show a kit with all its sub
kits. Otherwise I would need to have repeated queries from the application
logic, and I really want to avoid that.

Please help, thanks.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problems setting up Priveleges

[J.A. Jones Tyler III]

Greetings,

I have installed MySQL 4.0.13 in a Windows 2000
machine. I am new to this and originally did the
install on a box that was secure from the internet and
ran some tests. I ran a forum software program and
also created a few databases on my own, all
successfully (although some troubleshooting was
generally required here and there=)

Now, I am preparing to move this to a production
server and am running into problems. I followed the
instructions on 'securing' the database and now
continually have problems with connecting to the
database.

In general, it does not seem to like
[EMAIL PROTECTED]

I have gone into the user table in mysql db and placed
both 'localhost' and '%' into the host entry. It was
my understanding that '%' would allow access from any
host for that particular username.

Comically enough, most of the time that I go in and do
this editing, I subsequently get out of MySQL, stop
and restart the service and then, of course, it will
not even let me log in.

The error always revolves around the 127.0.0.1.

Here are some of the things which I do to supposedly
secure the MySQL install :

delete from user where User=''; 
update user set User='NewRootName',
Password=password('NewPassword') where User='root'; 
update user set host='%' where user='NewRootName';
flush privileges; 

I have searched the internet for an answer to my problem and seen
where users are pointed to http://www.mysql.com/doc/en/Access_denied.html

But, quite frankly, these instructions must
not be for a Windows OS and simply do not work (or
they assume that the reader has other knowledge that I
do not have.)

Any assistance on this issue will be much appreciated.

Thanks!

JT



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems setting up Priveleges

[J.A. Jones Tyler III]

- Original Message - 
From: J.A. Jones Tyler III [EMAIL PROTECTED]


 I have gone into the user table in mysql db and placed
 both 'localhost' and '%' into the host entry. It was
 my understanding that '%' would allow access from any
 host for that particular username.


Well, I finally specifically granted all priv's to username@127.0.0.1' and
was able to get it to work.

Can someone give me the syntax for giving a user the right to access a dB or
all dB's from any domain? I must be inputing it wrong.

To recap, I was writing this :

grant all privileges to dbname.* to username@% identified by 'password';

It took it and when I looked into the table, it showed it in there. But,
whenever I tried to use php to connect, I'd get the error about access
denied to [EMAIL PROTECTED]

Only when I specifically entered the local host defaul ip as a host that
username could connect from did it work.

Thanks again for any help!

jt


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems setting up Priveleges

[J.A. Jones Tyler III]

- Original Message - 
From: Paul DuBois [EMAIL PROTECTED]

 Where are these instructions found?

Got em here :
http://www.analysisandsolutions.com/code/mybasic.htm#installation

snip


 Yes, unless some other user table matches first, which may be
 what is happening in your case.

Cool. Ok, that's new info for me. What is the table order that MySQL uses to
grant authentication? On that same note, if I understand your response, does
it stop the minute it finds a suitable entry (I guess it matches the user
name) or does it grab info from all tables for that username? If the latter,
does it grant the privileges inclusively (i.e. does it get everything that
they all grant individually (so you get different rights from different
tables) or does it only grant what all of the tables allow (only those
privileges that are granted on each table are granted)?

SNIP


 Stopping and starting the service should be unnecessary.
 The FLUSH PRIVILEGES statement you're using causes the
 server to reload the grant tables.

Excellent. Thanks for the info!

 
 Here are some of the things which I do to supposedly
 secure the MySQL install :
 
 delete from user where User='';
 update user set User='NewRootName',
 Password=password('NewPassword') where User='root';
 update user set host='%' where user='NewRootName';
 flush privileges;

 What is the output of the following statement after you issue the
 preceding statements:

 SELECT Host, User, Password FROM user;

I get two entries, both for the same username (I've actually already
uninstalled MySQL for the umpteenth time, but I did what you asked before to
be sure it was there). The first instance of the username is matched to
'localhost' and the second instance is matched to '%'. In both cases the
password is the same (in this case it was 'lwtest').


Thanks a TON for your assistance...I've spent quite a bit of time working on
this daggone thing (as a side, I am 100% sure that I am doing something
wrong, I just can't figure out what the heck it is!)

JT


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems setting up Priveleges

[J.A. Jones Tyler III]

- Original Message - 
From: Paul DuBois [EMAIL PROTECTED]
 
 I have gone into the user table in mysql db and placed
 both 'localhost' and '%' into the host entry. It was
 my understanding that '%' would allow access from any
 host for that particular username.

 Yes, unless some other user table matches first, which may be
 what is happening in your case.


These comments you made have gotten me to thinking.

When I was having problems, per the original query, I actually had two
incidents of the same username in my user table. They were the only users in
fact. Each was tied to a different domain. I continued to get errors.
Perhaps it was grabbing the first entry (which was simply defined as
'localhost' for the host) and not going further?

The reason I ask is that I had no problems when I put in a NEW username (and
also tied it directly to the local host ip instead of the dns/host name.) I
at first thought it was because I tied it directly to the ip, but it was
also the only incident of that new username, so it could not get busted out
like my original username.

None of the above probably makes much senseand I probably am not using
the right lingo...so, I apologize for that.

But, I am learning slowly=)

JT


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mySQL GUI

[Tyler Longren]

MySQL CC from www.mysql.com is pretty good.

Tyler

- Original Message -
From: Neil Tompkins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 1:49 PM
Subject: mySQL GUI



 I have recently purchased the lease of a dedicated mySQL server running on
 linux.

 I normally use a GUI tool to modify databases etc.  But now I need to
create
 them aswell.  Can anyone recommend a free tool to do this to run on
Windows
 and connection to a mySQL server running on linux.

 Thanks
 Neil

 _
 Overloaded with spam? With MSN 8, you can filter it out

http://join.msn.com/?page=features/junkmailpgmarket=en-gbXAPID=32DI=1059


 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

BUG: NT service account and defaults file

[Simon Tyler]

I've been trying to install MySQL (3.23.55) as a named NT service and using a 
specified defaults file and I can't get it to work.

The source code has the example:

mysqld --install-manual mysqldopt --defaults-file=c:\miguel\my.ini

in it. The results in a service ImagePath of

C:\mysql\bin\mysqld-nt --defaults-file=c:\miguel\my.ini mysqldopt

However with this configuration the service refuses to start.

Looking at the code (3.23, 4.0 and 4.1) it looks as if it is getting confused in the 
main (in mysqld.cpp) and just calls Service.Init without loading the default file.

Doing the above without a service name works OK, doing it without over-riding the 
default-file is OK.

Simon

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Running as a user account on W2K

[Simon Tyler]

I've discovered what causes this issue.

The file nt_serv.cpp has a method called IsService. This requests SERVICE_ALL_ACCESS 
permission from the service control manager.  Changing this to SERVICE_QUERY_STATUS 
fixes the issue whilist achieving the same effect/

Simon

 Message from Simont Tyler [EMAIL PROTECTED] at 12-Mar-2003 12:58:35 --
Hi,

I've installed MySQL 3.23.55 on Windows 2000 and I am trying to run the mysqld 
service as a user account rather than the local system account. This worked fine in 
3.23.43 but has stopped working since the upgrade.

The error I get is 2186, which seems to be service failing to respond to control 
function.

Any ideas?

Simon



-
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

Running as a user account on W2K

[Simont Tyler]

Hi,

I've installed MySQL 3.23.55 on Windows 2000 and I am trying to run the mysqld service 
as a user account rather than the local system account. This worked fine in 3.23.43 
but has stopped working since the upgrade.

The error I get is 2186, which seems to be service failing to respond to control 
function.

Any ideas?

Simon

Due to high demand and an increasing takeup of the Gordano Messaging
Suite as a complete email solution, Gordano are pleased to announce
the availability of a comprehensive Gordano Training Programme. The
Programme offers a logical and structured approach to GMS with an
emphasis on ease of administration and high return on investment.
For further information please see:

http://www.gordano.com/Training/Courses.htm

Alternatively, contact the Gordano Sales department on:
+44 1275 345 100, or, 877 292 1142 (USA)
Email: [EMAIL PROTECTED]


NB: This email and any attachments have been checked for the presence
of computer viruses using Gordano Messaging Suite Anti-Virus technology.
None were found.

-
Gordano Ltd
Tel UK: +44 1275 345100   Fax UK: +44 1275 340056
Tel USA: +1 877 292 1142   http://www.gordano.com
Sales EMail: [EMAIL PROTECTED] Support EMail: [EMAIL PROTECTED]

This message is confidential and intended solely for the use of the
addressee.  Quotations are subject to contract and valid for 28 days.
-

-
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

Code explaination

[Simont Tyler]

Just saw the following code in the MySQL 2.23.55 source code.

The semi-colon after the if renders the if statement useless. Could someone explain if 
it is intentional. The comment indicates that it is.

Simon

   /*
  the following 'if', thought conceptually wrong,
  is a useful optimization nevertheless.
*/
if (file-state != file-s-state.state);
  file-s-state.state = *file-state;

Due to high demand and an increasing takeup of the Gordano Messaging
Suite as a complete email solution, Gordano are pleased to announce
the availability of a comprehensive Gordano Training Programme. The
Programme offers a logical and structured approach to GMS with an
emphasis on ease of administration and high return on investment.
For further information please see:

http://www.gordano.com/Training/Courses.htm

Alternatively, contact the Gordano Sales department on:
+44 1275 345 100, or, 877 292 1142 (USA)
Email: [EMAIL PROTECTED]


NB: This email and any attachments have been checked for the presence
of computer viruses using Gordano Messaging Suite Anti-Virus technology.
None were found.

-
Gordano Ltd
Tel UK: +44 1275 345100   Fax UK: +44 1275 340056
Tel USA: +1 877 292 1142   http://www.gordano.com
Sales EMail: [EMAIL PROTECTED] Support EMail: [EMAIL PROTECTED]

This message is confidential and intended solely for the use of the
addressee.  Quotations are subject to contract and valid for 28 days.
-

-
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

MYSQL 3.23.55 Install Issues

[Simon Tyler]

Hi,

I've been trying to get the 3.23.55 version of mysqld-nt.exe working with our product 
(GMS Mail) and I'm running into install\service related issues. I've read through the 
various threads on this list and nothing seems to solve my problem.

The situation is that we include MySQL with our product and manage the 
starting\stopping of the service ourselves (don't ask why). We currenlly use 3.23.43 
and are looking to upgrade to 3.23.55.

We don't ship the full MySQL install dues to size but just ship those parts we need. 
Using 3.23.43 this is fine and we are able to run mysqld-nt as a service under our own 
service name with no problems.

With 3.23.55 this does not work. It seems that the executable requires itself to be 
installed as the MySQL service. If I do this then all is fine and good. However we 
don't need to install the service as we have it installed ourselves under a different 
name and we don't wish to do this as it may interfer with a customer who potentially 
has a different version of MySQL installed on the same machine. The startup options we 
use are:

mysqld-nt -default-file=file -basedir=dir -datadir=dir --port=non-std port 
-bind-address=127.0.0.1 -socket=

The cnf file is generally empty. 

With these options the service starts but querying it's status fails and the port\ip 
that it is listening on are incorrect - the defaults are used.

Any ideas?

Simon



-
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

Cant change anything via web?

[Tyler]

Hey.. I've got a promblem.  I use PHP, and I cant seem to be able to change
anything in the MySQL db via the webpage.   I know the scripts are correct,
but nothing happens when I change somethign via web.  I've even installed
PhpMyAdmin to moniter the DB via the web, and that doesn't work either.  I
dont knwo whats wrong.. but the only way I can edit my DB is to do it via
mysqladmin ON the linux box

-Thanks oin advance
Tyler

-
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: Compiling error 3.23.54a (src)

[Tyler]

Oh.. I see.  I dont know about Linux, all I knew was that I wanted it so I
burned the necissary CD's and installed linux on my other machine.  So,
you're saying I should use a mandrake-linux forum, instead of mysql?
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Tyler [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, January 14, 2003 10:32 PM
Subject: Re: Compiling error 3.23.54a (src)


 On Tue, Jan 14, 2003 at 08:58:07PM -0700, Tyler wrote:
  what appropriate forums?

 I'm not a Mandrake user, but every Linux distribution I've tried has
 had various e-mail and web-base forums in which you can ask
 questions.  Furthermore, they have official support channels and ways
 of filing bug reports if you've found a but.

 Surely the Madrake documentation mentinons *some* of them.  And odds
 are that Google could find a few more of them.
 --
 Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
 [EMAIL PROTECTED]  |  http://jeremy.zawodny.com/

 MySQL 3.23.51: up 31 days, processed 1,015,781,700 queries (379/sec. avg)


-
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

Uninstall MySQL?

[Tyler]

Can someone please guide me in uninstalling all the failed installs of MySQL
I've got? I've installed like 2 binaries, and 1 source.. none work :(

-
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: Compiling error 3.23.54a (src)

[Tyler]

what appropriate forums?
- Original Message - 
From: Jeremy Zawodny [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, January 14, 2003 7:21 PM
Subject: Re: Compiling error 3.23.54a (src)


 On Tue, Jan 14, 2003 at 05:56:07PM -0700, [EMAIL PROTECTED] wrote:
  Does this mean I wont get a reply? this is the 3rd post regarding this
  matter, and I've been trying to install MySQL for a month :(.
 
 It seems to be Mandrake-specific issue.  Have you asked in the
 appropriate forums for that?  Tried Google?
 -- 
 Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
 [EMAIL PROTECTED]  |  http://jeremy.zawodny.com/
 
 MySQL 3.23.51: up 30 days, processed 1,013,680,258 queries (379/sec. avg)
 

-
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

Compiling MySQL

[Tyler]

This is wierd.  When I run make on mysql 3.23.54 (Source Distro), using
./configure --prefix=/usr/local/mysql, --oh, and I'm running Mandrake Linux
9.0--I always get this:

libmysql.c:1340: warning: passing arg 5 of 'gethostbyname_r' from
incompatible pointer type

libmysql.c:1340: to few arguments to function 'gethostbyname_r'

libmysql.c:1340: warning: assignment makes pointer from integer without a
cast

make[2]: *** [libmysql.lo] Error 1

make[2]: Leaving directory '/usr/local/mysql-3.23.54a/libmysql'

make[1]: *** [all-recursive] Error 1

make[1] Leaving directory '/usr/local/mysql-3.23.54a'

make: *** [all] Error 2

Then the script closes and i get my command prompt.

Thanks in advance,
Tyler

-
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

Unistall Source

[Tyler]

Hi.  How do I unstall a source tarball (tar.gz) of mySQL? (or any prog for
that, I need to uninstall Emacs too) I installed Mysql-3.23.51, but the
install docs dont seem to work for that, and I finally found a working src
for .54, so I wanna take out the old one.

Thanks in advance

Tyler

-
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

MySQL Source tar.gz files

[Tyler]

Ok, I've got gunzip and tar, and every time I try (multiple versions) of
your source .tar.gz file, I get:
(when running 'tar -zxf mysql-3.23.54a.tar.gz')
gzip: stdin: not in gzip format

(when running 'gunzip mysql-3.23.54a.tar.gz')
gunzip: mysql-3.23.54a.tar.gz: not in gzip format

It seems NOTHING has
worked for the last 2 days.  I've tried the binaries, and then I dont have
the top-level installation directory that all the docs refer to, and mysql
isn't in /usr/local/.

I really just want to be able to use MySQL..

-Tyler

-
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

MySQL-PHP-Apache2

[Tyler]

Hey.. I've got a wierd problem.  I'm following the guide as per WebMonkey
which has worked for me before, when I ran my servers on a Win32 box, but
now I've got this problem (running linux)...

I cant seem to do any editing to my DB from the webpage.  I've used a couple
different scripts, confirmed the right user/pass/sock but everytime I try
the script, nothing happens in my DB, I cant delete, add, nor edit via the
page.

p.s. if anyone knows about the 'configure' command to most progs, before you
comple, coudl you email me in private? Im trying to re-configure my PHP to
have mysql support, however I'm not sure how to do it.  I've already built
it.  could this be the problem?

heres a script I used to enter data, to no avail:

?php
if ($submit) {
  // process form
  $db = mysql_connect(localhost, root);
  mysql_select_db(mydb,$db);
  $sql = INSERT INTO employees
(first,last,address,position) VALUES
('$first','$last','$address','$position');
  $result = mysql_query($sql);
  echo Thank you! Information entered.\n;
} else{
  // display form
 ?

-
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

Configure error: no curses/termcap library found

[Tyler Devereaux]

Can anyone help me?
I get this whenever I run ./configure --prefix=/usr/local/mysql

checking for termcap functions library... configure: error: No 
curses/termcap library found

then configure quits.  I'm really new to linux, so please give me the 
lamans version of it ;)


_
MSN 8: advanced junk mail protection and 2 months FREE*. 
http://join.msn.com/?page=features/junkmail


-
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

how I can get a handle for controlling longblob field?

[Tyler Xiang]

hi:
I will use Mysql 4.0 to store RTP data stream.
How I can get a handle for controlling longblob field? I will put the
received real-time data into the longblob field by the handle
continually.Would you like to write a demo for me?
Thanks for you help.



-
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

Fwd: RE: Newbie With a Question

[Jones Tyler]

Well, that's strike one for me! I sent my first post
to the list and accidently ONLY sent it to one member
of the list (who was kind enough to respond anyway!)

My problem is that I am unable to change data in an
existing table. I use the UPDATE function and it
continues to tell me that I am using an Unknown
Column. 

When I do a DESCRIBE on the table, I clearly see the
column.

Since I can see the column in the describe (named
'Field'), I must be doing something else wrong.

Any help would be appreciated. (Thanks to Oscar, but
his link seems to be for actually changing the format
of a table, which is not my goal...yet=)

--- Oscar Rylin [EMAIL PROTECTED] wrote:
 From: Oscar Rylin [EMAIL PROTECTED]
 To: 'Jones Tyler' [EMAIL PROTECTED]
 Subject: RE: Newbie With a Question
 Date: Wed, 14 Aug 2002 22:36:05 +0200
 
 http://www.mysql.com/doc/A/L/ALTER_TABLE.html
 
 -Original Message-
 From: Jones Tyler [mailto:[EMAIL PROTECTED]] 
 Sent: den 14 augusti 2002 22:33
 To: Oscar Rylin
 Subject: Newbie With a Question
 
 Greetings,
 
 To begin with, if this is an inappropriate question
 for this list, let me appologize now. In that case,
 if
 you could direct me to an appropriate venu for my
 question, I would appreciate it.
 
 The question?
 
 I downloaded a free program on the internet to have
 some fun. After the download, I noticed a problem
 that
 I subsequently did a search on and found the answer.
 The problem is that I am having problems
 implementing
 the fix.
 
 The fix is to change the entry in a row of a table
 for
 a particular horizontal entry (or field, if you
 will).
 
 After I select the dB, I then typed SHOW TABLES and
 identified the table in question (HUNT_CONFIG).
 Looking at the Table, I then find the The first
 column
 is FIELD and the table entry I am interested in has
 a
 FIELD value of regtype.
 
 I want to change the entry in the third column for
 regtype, which is titled VAR. The current value is
 enum('0','1','2') and I need this value to be
 enum('0','1','2','3')
 
 So, I typed the following:
 
 UPDATE HUNT_CONFIG SET VAR='enum('0','1','2','3')
 WHERE FIELD='regtype';
 
 But, it keeps giving me an error, acting as if there
 is not such Column by the name of 'FIELD'. I have
 double checked this many times and am certain that
 the
 name fo the column is FIELD.
 
 If you have any suggestions, they would be
 appreciated.
 
 
 
 
 __
 Do You Yahoo!?
 HotJobs - Search Thousands of New Jobs
 http://www.hotjobs.com
 


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

-
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: Bank details

[Tyler Longren]

UmI don't think anyone (or hope noone) on this list is stupid
enough to get sucked in by a piece of spam.

-- 
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com



On Thu, 11 Jul 2002 15:39:33 +0100
Kevin Passey [EMAIL PROTECTED] wrote:

 Do not give your bank details to anyone offering large amounts of
 money for nothing.
 
 What normally happens is that you give your details over - then you
 are sucked dry - watch out.
 
 Regards
 
 Watch out mysql list
 
 -
 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
 

-
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

a very odd benchmark question

[Tyler Spivey]

ok - this might seem unbelieveable but:
why are the benchmarks:
shell cd sql-benchmarks #or whatever it is
shel perl run-all-tests --user=root --password=password
and then on another screen i have mysql up -
and a \s say queries per sond 1.792 or something around there. what is up?

-
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: Does MySQL support subqueries?

[Tyler Longren]

Hi Amaury,

R.B. Roa would be correct in saying that subqueries are in the 4.x branch of
MySQL.  I'm not sure when 4.xx will be the stable branch though.  Instead of
using subqueries, you could try using some JOIN statments.

Tyler Longren
Captain Jack Communications
www.captainjack.com
[EMAIL PROTECTED]

- Original Message -
From: Amaury Cabarcas Alvarez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 12:14 PM
Subject: Does MySQL support subqueries?


 I have mysql 3.23.49a, and i wish know if does version support subqueries?


 -
 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




-
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: Authentication messed up?

[Tyler Longren]

did you FLUSH (reload) your mysql server?

Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com

- Original Message -
From: Dan Egli [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 04, 2002 6:21 PM
Subject: Authentication messed up?


 I tried to add a user to my mysql system for the MTA  (exim) but am having
a
 hard time making it work.

 I used grant to give exim permissions:
 grant ALL PRIVILEGES on exim.* to exim@localhost IDENTIFIED BY PASSWORD
 exim pw;

 and the exim database does exist, BUT.

 [root@shortcircuit root]# mysql exim -u exim -p
 Enter password:  exim pw
 ERROR 1045: Access denied for user: 'exim@localhost' (Using password: YES)
 [root@shortcircuit root]#


 Any ideas? Why can user exim not access the exim database?

 Thanks!


 -
 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


-
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: Subqueries

[Tyler Longren]

It can't, try using JOIN.

Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com

- Original Message -
From: Leo Przybylski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 1:35 PM
Subject: Subqueries


 Hello all,

 Does anyone know if MySQL can do subqueries?

 I am trying to provide a SELECT subquery to an IN clause and I am getting
 errors. Is this possible?

 -Leo

 -
 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



-
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: Beginners Question

[Tyler Longren]

MySQL will be good for this type of stuff.

Tyler

- Original Message -
From: Zhao, Charles [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 01, 2002 3:53 PM
Subject: Beginners Question


 Hello there,

 I am trying to find which database to use.  I will have text and image
data.
 Lots of image data.  Most of the time I am doing data retrieving, but when
 updating, it will be text almost always.  No enterprise use, but very busy
 database hits.  Could any one please educate me if mysql is a good
database
 for this purpose? Or anything else?

 Many thanks.

 -- charles

 -
 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



-
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: LIMIT, ORDER Dilema

[Tyler Longren]

You have to have the LIMIT clause after the ORDER clause.

Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com

- Original Message -
From: destr0 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, March 30, 2002 1:32 PM
Subject: LIMIT, ORDER Dilema


 Can you not have the LIMIT clause before the ORDER Clause in a select
query?

 SELECT * FROM myTable LIMIT 30, 45 ORDER BY someField ASC;

 This query  ^ fails with the error:

 Error 1064: You have an error in your SQL syntax near ' ORDER BY someField
 ASC' at line 1

 I just want to make sure that the case is that you can't have your LIMIT
 clause before your order clause.



 -
 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



-
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: sql

[Tyler Longren]

Visual Basic and Visual C++ are 2 completely different things, so no, visual
basic will not work.

There might be some free C++ compilers for you to use for windows.  You
could always buy a copy of an older version of Visual C++.  Older versions
probably won't be too horribly expensive.

Tyler

- Original Message -
From: Harry Rorarius [EMAIL PROTECTED]
To: Mysql list [EMAIL PROTECTED]
Sent: Friday, March 29, 2002 4:10 PM
Subject: sql


 I am working with the php and when using php.net the documentation
requires
 compileing with Visual C++ I am in win32.  I do not have this program.  I
 have Visual basics 5 will this work?
 If not it there a C++ complier I can download that would get me through
 this?

 for sql


 -
 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




-
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: select a certain num of items in sql query

[Tyler Longren]

This worked for me:
SELECT * FROM table ORDER BY id ASC LIMIT 9,21;

There's probably a better way to do that though.

tyler

- Original Message -
From: Aman Raheja [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 2:04 PM
Subject: select a certain num of items in sql query


 Suppose I want to select items 10 to 30 from a table tab, which has 36
rows.
 What could be the sql query ?
 Thank you.
 Aman

 PS: I am using cgi-perl.


 _
 MSN Photos is the easiest way to share and print your photos:
 http://photos.msn.com/support/worldwide.aspx


 -
 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



-
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: Host permissions

[Tyler Longren]

Do what Paul DuBois just suggested a few minutes ago on this very list:

Delete the records from the user table that have blank User fields:

DELETE FROM mysql.user WHERE User = '';
FLUSH PRIVILEGES;

Then try again.

That might help.  Is your mysql server box behind a firewall? If it is, you
might want to open port 3306 on the firewall.

Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com

- Original Message -
From: Paul Rose [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 27, 2002 11:07 PM
Subject: Host permissions


 I have read the mail archives and am still confuessed.

 mysql version  3.23.49-5  running under debian kernel 2.4.12

 I cannot connect to the mysql server from the outside world.
 I have added a host permission to allow anyone to any database.
 Can someone assist ?

 Regards
 Paul


 -
 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


-
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: NuSphere v. MySQL 4

[Tyler Longren]

I suggest you use MySQL from MySQL AB.  Progress Software (parent of
NuSphere), is having some legal troubles.

http://www.newsforge.com/article.pl?sid=02/02/26/1825200

Tyler

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 26, 2002 1:01 PM
Subject: NuSphere v. MySQL 4


 Hello,

 I'm not sure if this list is appropriate for this issue but I'll go ahead
 ask for your input anyway. We're trying to decide to choose DBMS as a
 backend of our web portal. The portal will take online orders and other
 requests from end users and this is going to be available enterprise wide
 (WAN) for approx. 19,000 employees. As Oracle license cost is getting too
 high for this purpose, I'm thinking of using MySQL instead. However, I saw
 two different versions here (NuSphere vs. MySQL AB) and cannot decide
which
 one is better to use.

 Now, my questions are:

 1. What would be your recommendation for me to use, what are the
advantages
 / disadvantages of using NuSphere's (or MySQL AB's) products other than
the
 different pricing here?

 2. Is it true that Gemini type table from NuSphere is much better than
 other types (e.g. InnoDB). How about the installation and config
 themselves, any issues I should know about from each product? We're going
 to install it on a W2000 server on the same box as the web portal.

 3. Is it safe enough to use MySQL v.4.0.1 instead of 3.23.49. How about
the
 MAX 4.0.1., is this better? Although reliability is important this
 application is not mission critical.

 Sorry for the many questions, but I'm really new to MySQL and I want to
 feel comfortable with it before I decide to use this. I'd greatly
 appreciate any input from all of you.


 Thanks,
 Martin






 **Disclaimer**
 This  Memo and any attachments, may be confidential and legally
privileged.
 If  you  are  not  the  intended recipient and have received this in
error,
 kindly  destroy  this  message  and  notify the sender.  Thank you for
your
 assistance.


 -
 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




-
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: SET field=field+1 no longer works?

[Tyler Longren]

Nope, privs are the same.

Tyler

- Original Message -
From: Daniel Rosher [EMAIL PROTECTED]
To: Tyler Longren [EMAIL PROTECTED]
Cc: MySQL List [EMAIL PROTECTED]; DL Neil
[EMAIL PROTECTED]
Sent: Tuesday, February 26, 2002 5:19 PM
Subject: RE: SET field=field+1 no longer works?


 Have privileges changed?

 Dan

  -Original Message-
  From: Tyler Longren [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, 27 February 2002 11:55 a.m.
  To: DL Neil
  Cc: MySQL List
  Subject: Re: SET field=field+1 no longer works?
 
 
  Well, here's the query that PHP is generating:
  UPDATE users SET board_posts=board_posts+1 WHERE username='tyler' AND
  password='myfakepassword'
 
  If I copy and paste that exactly into the mysql client, it's executed
  correctly.  If I use phpMyAdmin to execute it, it IS NOT executed
  correctly
  (same as in my PHP code).  I really don't think this is a problem with
my
  coding since it worked with previous versions of mysql.  Could PHP just
be
  screwing up while sending the query to MySQL?
 
  Also, if I use MySQL Front (www.mysqlfront.de), the query doesn't get
  executed properly.  It only works correctly when issuing the
  query from the
  mysql command line client.  :)
 
  Tyler
 
  - Original Message -
  From: DL Neil [EMAIL PROTECTED]
  To: Tyler Longren [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]
  Sent: Tuesday, February 26, 2002 8:52 AM
  Subject: Re: SET field=field+1 no longer works?
 
 
   Hi Tyler,
   [back on-list so that others can offer their wisdom!]
  
   OK, so it's not a problem with the MySQL client, then it's
  likely the PHP.
  Most likely that the username and
   password data values are strings and need to be properly contained
with
  single- or double-quotation marks.
  
   If you need further assistance, first try some debug ECHOs on the
three
  fields used in the query, and ECHO the
   query itself immediately prior to the call to MySQL. (is the
  last how you
  posted (copy-pasted) the query into
   the MySQL client, or did you type it into MySQL by hand?)
  
   If lights still don't go off, please post the PHP code snippet.
  
   Regards,
   =dn
  
  
I tried it in PHP first, and it doesn't work in that.  But, when I
use
  the
mysql client, it works as expected.  Any ideas?
  
  
 Hello Tyler,

 Did someone pick up this question - haven't spotted a
  response on the
list?
 I haven't spotted any such mis-behavior under either
  Win2000 or WinNT.

 Are you entering the query at the command line or into some tool?
 Have you tried another client?

 If it is still unresolved, send me (NOT the whole list) the actual
  query,
and a short table with sample data,
 and I'll try it on my two Win boxes here.

 Regards,
 =dn


  I'm running MySQL on a Windows 2000 box.  I was running 3.23.47
  until
  3.23.49 was released.  After upgrading to 3.23.49,
  queries like this
don't
  work:
  UPDATE test_table SET board_posts=board_posts+1 WHERE
  username='blah'
AND
  password='blah';
 
  Normally, that would increment the value in board_posts by 1,
this
  no
longer
  happens.  Is there a different way I should do this now?
 
  Thanks,
  Tyler
 
 

   -
  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
 
 



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


 -
 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: SET field=field+1 no longer works?

[Tyler Longren]

Hi Everyone,

This was my bad.  I forgot that I had encoded all passwords with
base64_encrypt() in PHP.  So, the passwords in the database weren't in their
plaintext forms.  So, my password wasn't matching up with what was in the
database.

Everything works good now.  :)

Thanks for your help!
tyler

- Original Message -
From: Stewart Gateley [EMAIL PROTECTED]
To: Tyler Longren [EMAIL PROTECTED]; DL Neil
[EMAIL PROTECTED]
Cc: MySQL List [EMAIL PROTECTED]
Sent: Tuesday, February 26, 2002 5:56 PM
Subject: Re: SET field=field+1 no longer works?


 Try:

 UPDATE users SET board_posts=(board_posts+1) WHERE username='tyler' AND
 password='myfakepassword';


 I am using ? mysql_query (update $table set hits=(hits+1) where
 id=$id); ? and it works fine.

 -- Stewart

 --- Tyler Longren [EMAIL PROTECTED] wrote:
  Well, here's the query that PHP is generating:
  UPDATE users SET board_posts=board_posts+1 WHERE username='tyler' AND
  password='myfakepassword'
 
  If I copy and paste that exactly into the mysql client, it's executed
  correctly.  If I use phpMyAdmin to execute it, it IS NOT executed
  correctly
  (same as in my PHP code).  I really don't think this is a problem
  with my
  coding since it worked with previous versions of mysql.  Could PHP
  just be
  screwing up while sending the query to MySQL?
 
  Also, if I use MySQL Front (www.mysqlfront.de), the query doesn't get
  executed properly.  It only works correctly when issuing the query
  from the
  mysql command line client.  :)
 
  Tyler
 
  - Original Message -
  From: DL Neil [EMAIL PROTECTED]
  To: Tyler Longren [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]
  Sent: Tuesday, February 26, 2002 8:52 AM
  Subject: Re: SET field=field+1 no longer works?
 
 
   Hi Tyler,
   [back on-list so that others can offer their wisdom!]
  
   OK, so it's not a problem with the MySQL client, then it's likely
  the PHP.
  Most likely that the username and
   password data values are strings and need to be properly contained
  with
  single- or double-quotation marks.
  
   If you need further assistance, first try some debug ECHOs on the
  three
  fields used in the query, and ECHO the
   query itself immediately prior to the call to MySQL. (is the last
  how you
  posted (copy-pasted) the query into
   the MySQL client, or did you type it into MySQL by hand?)
  
   If lights still don't go off, please post the PHP code snippet.
  
   Regards,
   =dn
  
  
I tried it in PHP first, and it doesn't work in that.  But, when
  I use
  the
mysql client, it works as expected.  Any ideas?
  
  
 Hello Tyler,

 Did someone pick up this question - haven't spotted a response
  on the
list?
 I haven't spotted any such mis-behavior under either Win2000 or
  WinNT.

 Are you entering the query at the command line or into some
  tool?
 Have you tried another client?

 If it is still unresolved, send me (NOT the whole list) the
  actual
  query,
and a short table with sample data,
 and I'll try it on my two Win boxes here.

 Regards,
 =dn


  I'm running MySQL on a Windows 2000 box.  I was running
  3.23.47
  until
  3.23.49 was released.  After upgrading to 3.23.49, queries
  like this
don't
  work:
  UPDATE test_table SET board_posts=board_posts+1 WHERE
  username='blah'
AND
  password='blah';
 
  Normally, that would increment the value in board_posts by 1,
  this
  no
longer
  happens.  Is there a different way I should do this now?
 
  Thanks,
  Tyler
 
 

  
  -
  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
 
 



  -
 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

   
   
  
  
  
  -
   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
  
  
 
 
  -
  Before posting, please check

SET field=field+1 no longer works?

[Tyler Longren]

Hello,

I'm running MySQL on a Windows 2000 box.  I was running 3.23.47 until
3.23.49 was released.  After upgrading to 3.23.49, queries like this don't
work:
UPDATE test_table SET board_posts=board_posts+1 WHERE username='blah' AND
password='blah';

Normally, that would increment the value in board_posts by 1, this no longer
happens.  Is there a different way I should do this now?

Thanks,
Tyler


-
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: how to unsubscribe from this list?

[Tyler Longren]

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

It's at the bottom of every message sent to this list.

Tyler

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 18, 2002 9:19 AM
Subject: how to unsubscribe from this list?


 Hello,
 I have found the solution of my sql quueris,
 I want to unsubscribe from this list

 can u help?
 thanx




 -
 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



-
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: Where Did Mysql Go?

[Tyler Longren]

is mysqld running on your box?

Tyler

- Original Message -
From: Rich [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Sent: Monday, February 11, 2002 6:49 AM
Subject: Where Did Mysql Go?


 I was working on updating some databases yesterday and when I booted up
 my computer this morning I couldn't connect to MySQL, the error message
 is can't connect to local MySQL server through socket
/path/mysql.socket.

 It was there yesterday and now it's gone!  Where did it go (a search of
 the HD doesn't show it) and, more important, how do I get it back?

 Rich
 --
 [EMAIL PROTECTED]


 -
 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


 -
 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



-
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: Coldfusion?

[Nally, Tyler G.]

 -Original Message-
 From: Andy Ingham [mailto:[EMAIL PROTECTED]]

 We've been running Cold Fusion with MySQL on the Solaris platform for
 almost two years now and have had such terrible problems with Cold
 Fusion errors that we have begun the process of migrating to 
 PHP.   Our
 average load has been about 30,000 .cfm pages (linked to 
 MySQL backend)
 served per week, which I don't consider to be too heavy a 
 load to expect
 the system to handle successfully.  Unfortunately, our log files are
 riddled with fatal Cold Fusion errors and subsequent restarts.  It got
 so bad that we had to institute a cron job to check for the 
 happiness of
 the CF processes every 3 minutes and restart them if there was a
 problem.

Oh boy... I'll confirm that as well.  I previously worked
at Macmillan Computer Publishing (www.mcp.com) when I wrote
The Personal Bookshelf and migrated that application from
cgi-bin/perl and dbm arrays to Cold Fusion/Oracle all on
Solaris.

It was CF version 4.  And it was really bad.  In a development
environment where there is limited access, and the machine
load is relatively low, it's no problem.  Yet, the webstats
were saying we had approximately 8,000 users using the Personal
Bookshelf at any one time, so it was going to be put under a
heavy load once it is in production.  Such happened and CF
really really choked.  The machine suffered under a really
high *load*.  Typically above 90%.  The sysadmins joked that
the machine was working so hard it was glowing in the corner.
We optimized the code over the course of a couple of weeks
scruitinizing the CF markup for more efficient ways to do things
in order to get it down to a load.  We got the load down to
between 60-70% as I remember, which was still too high.  Not
only was the machine at an unusually high load, but the CF
server would die periodically between every 10-45minutes.  The
sysadmins eventually wrote a script to check the health of the
CF server instance that'd run every 3 minutes to determine 
whether or not it should restart CF automtically.  It was a
really bad situation. 

We talked with Allaire and they couldn't believe the problems 
we had with CF on Solaris.  At the time, Allaire said that we 
had the largest *nix based CF application on the www with a 
Sun Ultra with 4 GB of RAM tied to a pretty heavy amount of 
disk space, etc.  We provided them with database schema's, 
data, and our code ... and let them try it out.  They did.
And they confirmed everything we had said...even in their
environment.  They said the design of the database and the
coding of the pages didn't contribute to the poor performance
of the CF engine.  Ultimately, they said they couldn't help
us because the thing in CF that was causing all of the problems
(they said) was a simulated windows registry that CF requires
in order to operate.  They said that we were also suffering 
from a lot of errors where CF would loose database connections
and not keep threads alive like they would in a non-*nix
environment without a heavy load.  They had no answers for us 
at all.  They suggested that it be monitored constantly so that
the application stays running as much as possible.

When I heard about the simulated registry for *nix servers built
into CF, I nearly hit the roof!  I couldn't hardly believe it.

That was a couple of years ago, and CF has went from 4 -- 4.5 
-- 5.  Under a windows environment, it's probably pretty good.
Under *nix (Solaris in my experience) it really left much to
be desired.  I'd avoid it and stick with php on Solaris any day.

Tyler Nally 
--
__   _Tyler Nally
   / /__   _(_)___       _ _  [EMAIL PROTECTED]
  / / _ \/ __ `/ / __ \/ __ \ / __ \/ ___/ __ `/  317-860-3016
 / /  __/ /_/ / / /_/ / / / // /_/ / /  / /_/ /   American Legion Website
/_/\___/\__, /_/\/_/ /_(_)/_/   \__, /http://www.legion.org
   //  //   



-
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: Disable case sensitivity

[Nally, Tyler G.]

 -Original Message-
 From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
 Subject: Re: Disable case sensitivity

  If is possible, in everything from a Database, but if 
 is not, in columns
  is more important.

 Column names are case insensitive.

Correct...  Database names and Table names don't necessarily share
this (according to the MySQL manual snippet below).

6.1.3 Case Sensitivity in Names

In MySQL, databases and tables correspond to directories and files within
those directories. Consequently, the case sensitivity of the underlying
operating system determines the case sensitivity of database and table
names. This means database and table names are case sensitive in Unix and
case insensitive in Windows. See section 1.7.3 MySQL Extensions to ANSI
SQL92. 

NOTE: Although database and table names are case insensitive for Windows,
you should not refer to a given database or table using different cases
within the same query. The following query would not work because it refers
to a table both as my_table and as MY_TABLE: 

SELECT * FROM my_table WHERE MY_TABLE.col=1;

-
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 vs Interbase

[Nally, Tyler G.]

Yeah, any lookups based on char based columns are slower
than integer queries any day.  I'm assuming it's a char
column because you're searching with apostrophe's '0'.

Would a between statement in the where clause help?

  select * from experian.experian
   where latitude between '038631928' and '038638092'
 and longitude between '096671646' and '096680757'


 -Original Message-
 From: Dan Nelson [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, January 10, 2002 12:09 PM
 To: Mike Grover
 Cc: [EMAIL PROTECTED]
 Subject: Re: mySQL vs Interbase
 
 
 In the last episode (Jan 10), Mike Grover said:
  select * from experian.experian where latitude = '038631928' and
  latitude = '038638092' and longitude = '096671646' and 
 longitude =
  '096680757';
  
  Interbase takes 10 seconds to return 70 records, but mySQL 
 takes 18 seconds 
  to return the same record count.
  
  my Index is:
  ALTER TABLE EXPERIAN.EXPERIAN ADD INDEX latlong 
 (latitude,longitude);
  
  explain says it is using the latlong index with a key 
 length of 20.
  
  Is this the best mySQL will do? Is there a better sql 
 statement I can use?
 
 That's about as efficient as you can get.  You can try raising your
 mysqld key_buffer_size to allow more of the index to be cached, or
 maybe use INTEGER types for lat and long, which will bring your key
 down to 8 bytes total instead of 20 (cutting your index size by more
 than 50%).
 
 -- 
   Dan Nelson
   [EMAIL PROTECTED]
 
 -
 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
 


-
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 with date fcolumn in query

[Nally, Tyler G.]

Hello,

My boss is going through the mysql.com tutorials starting at ...

   http://www.mysql.com/articles/ddws/12.html

... and currently stuck at ...

   http://www.mysql.com/articles/ddws/13.html

The boss is using phpMyAdmin to access the database, and everything
has been working just fine until it gets to a database query
where it's using a date column (JokeDate) in the where clause.

The query is shown below and the phpMyAdmin error is
also shown...

  SELECT COUNT(*) FROM Jokes 
  WHERE JokeDate = 2000-01-01


  MySQL said: 


  Lost connection to MySQL server during query

When I made a php page with the query in it, it's 
dying on the ...

$sql_result = mysql_query($SQL) or die (bad SQL [$SQL]);

... where $SQL is the defined sql statment that's passed to
the mysql_query function.

The database table is defined thusly:

CREATE TABLE Jokes (
   ID int(11) DEFAULT '0' NOT NULL auto_increment,
   JokeText text,
   JokeDate date DEFAULT '-00-00' NOT NULL,
   PRIMARY KEY (ID)
);

With three rows of information in it.

Even if I change the query to :

   select * from Jokes where JokeDate = 2001-01-01
   -or-
   select * from Jokes where JokeDate = '2001-01-01'
   -or even-
   select ID, JokeText, JokeDate from Jokes where JokeDate = '2001-01=01'

... it just doesn't work and it returns the Lost Connection error.
If I select on a different column (like ID or JokeText) it works just
fine.

The MySQL database is 3.22.26a running on a Solaris through iPlanet
webserver on a test machine/database and Apache on production
machine/database.

Any help.  Thanks in advance.

--
__   _Tyler Nally
   / /__   _(_)___       _ _  [EMAIL PROTECTED]
  / / _ \/ __ `/ / __ \/ __ \ / __ \/ ___/ __ `/  317-860-3016
 / /  __/ /_/ / / /_/ / / / // /_/ / /  / /_/ /   American Legion Website
/_/\___/\__, /_/\/_/ /_(_)/_/   \__, /http://www.legion.org
   //  //   

-
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: alter table, remove unique?

[Nally, Tyler G.]

I think it's like this...

  alter table hrcontract drop index login

... assuming the name of the key is login.  You can
have key names (which is what a unique constraint
is) and column names of the same name.

If you do a ...

  show index from hrcontract

... it'll show you all of the key_name values paired
with the column names that are with that table that you 
can drop.

 -Original Message-
 From: dan [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, January 09, 2002 10:13 AM
 To: [EMAIL PROTECTED]
 Subject: alter table, remove unique?
 
 
 Hi,
 
 I'd like to alter a field and change it from being Unique 
 using the alter
 table command but can't seem to get the syntax correct?  Can 
 someone give
 me an example?  IE:
 
 alter table hrcontact modify login varchar(70) not null default'' _NOT
 UNIQUE';
 
 thanks,
 
 Dan
 
 
 
 -
 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
 

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

[Nally, Tyler G.]

Rember that the sum function sums the total of all
of the colum specified.  Is there multiple rows where
the same c.cid_no occurs many times?  If so, then you
need a group by and having clauses.  If not, 
then you don't need the sum function.

With a group by, it'd look like this... I think ...

  select c.cid_no, c.name
from carrier c, loads l
   where c.cid_no = l.cid_no
  group by c.cid_no
  having sum(l.amount)  600

Remember that column and tablenames are *spefic* to the
definition of the table.  So, a columnname of C.CID_NO 
isn't the same as defined as c.cid_no.  And that a 
tablename of CARRIER isn't the same as carrier.  To
see specifically what the columnname case sensitive
spellings are do a show columns on tablename.

Without a group by, because each c.cid_no only appears
once in the carrier table, it'd be a regular query without
any summing being performed on a column.


 -Original Message-
 From: Richard Reina [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, January 09, 2002 1:11 PM
 To: [EMAIL PROTECTED]
 Subject: mysql query
 
 
 I am trying to write a query that gets the name of every 
 carrier who has done more than $600 
 in loads.  Can anyone help?
 
 SELECT c.name
 FROM carrier c, loads l
 WHERE c.CID_NO = l.CID_NO
 AND SUM(l.amount  600);
 
 This, unfortunately does not work.
 
 
 
 
 
 
 
 -
 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
 

-
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: How Query and Fetch work?

[Nally, Tyler G.]

Basically, the mysql_query submits the sql statement
to the database engine, and the mysql_fetch_array 
allows retrieval of selected information returned from
the query into an associative array with each columnname 
of the query an associative key in the array 

Example...

  --login-to-host-and-db-connectors-here--

  $sql  = select name, address, city, state, zip ;
  $sql .= from addressbook ;

  $sql_result = mysql_query($sql) or die (bad SQL [$sql]);

  --print beginning html table tags and first row headers here---

  while($data_row = mysql_fetch_array($sql_result))
{
 $sel_name= $data_row[name];
 $sel_address = $data_row[address];
 $sel_city= $data_row[city];
 $sel_state   = $data_row[state];
 $sel_zip = $data_row[zip];

 // my personal preference is to use simple fields for
 // display purposes.  I could have easily used the 
 // array names as well... such as $data_row[name] for $sel_name

 echo(trtd$sel_name/td);
 echo(td$sel_address/td);
 echo(td$sel_city/td);
 echo(td$sel_state/td);
 echo(td$sel_zip/td/tr);
}

   --print closing html table tags---

  

 -Original Message-
 From: Dibo Chen [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, January 09, 2002 11:45 AM
 To: Alex Shi
 Cc: [EMAIL PROTECTED]
 Subject: Re: How Query and Fetch work?
 
 
 When you are told to fill in fuel and turn the key to drive, I suppose
 you don't care how the fuel runs the car. Do the same things 
 in any lib
 you use, pushing the buttons in told order would  work. 
 Well, you may
 dig deeper if you like since the code is available.
 
 Alex Shi wrote:
  
  Yesterday I posted a question yet got response. The question
  is regarding to how Query works. Now I repost it in a more
  specific way.
  
  I am just wondering how MySQL API functions work. Let's look
  at following two functions:
  
  1. mysql_query(),
  2. mysql_fetch_array()
  
  To my understanding, mysql_query() will definately to its job with
  MySQL server. But how about the latter? Does it just fetch data
  from client/local buffer, which is previously put in by 
 mysql_query(),
  or still has to goto server side to fetch data?
  
  Alex
  
  
 -
  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

-
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

-
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: How Query and Fetch work?

[Nally, Tyler G.]

Not knowing the exact internals of how it works...

Assuming that it works much the same way other RDB's
work in their native GL's (generation languages), the
common practice with a relational database is to define/declare
a cursor with the SQL statement executed against the database.
After the cursor is defined/declared, then the next operation
that is performed is a fetch where information that is available
by the cursor is actually pulled from the database and 
somehow used.  Specifically *how* I don't know.   

I remember years ago when doing COBOL programming, when
dealing with a random access indexed file, what we had to
do to get to the data was to...

   open indexedfile-name
   start indexedfile-name at a particular key value
 if error (the start was bad and you're record pointer was
   now at the end of the indexedfile)
go back and get a new key value or end program
 if good (read operations can be performed to retrieve a
  record)
continue

   looping paragraph
 (
  read recordname next
at end
  close indexfile-name
  
  
  
 )

This is pretty much the same operation as is done with a 
RDB.  The open is the database/host/user connection.  The
start is the definition/declaration of the cursor, and the
read next's are the fetches that return values to be 
processed.

 -Original Message-
 From: Stephen Abshire [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, January 09, 2002 12:41 PM
 To: [EMAIL PROTECTED]
 Subject: Re: How Query and Fetch work?
 
 
 I like the explanation using the automobile and key. Very 
 good :-) Yet at 
 the same time if I understand what effect using the different 
 grades of fuel 
 in my car will have on its performance, I can optimize how 
 the car operates. 
 Much like the original question, if I know when MySQL caches 
 result sets and 
 when it is forced to hit the database again I can optimize 
 the performance 
 of my application.
 
 Personally, I would like to know the answer to this question 
 myself. Anyone 
 know the internals?
 
 
 Original Message Follows
 From: Dibo Chen [EMAIL PROTECTED]
 To: Alex Shi [EMAIL PROTECTED]
 CC: [EMAIL PROTECTED]
 Subject: Re: How Query and Fetch work?
 Date: Wed, 09 Jan 2002 10:45:07 -0600
 
 When you are told to fill in fuel and turn the key to drive, I suppose
 you don't care how the fuel runs the car. Do the same things 
 in any lib
 you use, pushing the buttons in told order would  work. 
 Well, you may
 dig deeper if you like since the code is available.
 
 Alex Shi wrote:
  
   Yesterday I posted a question yet got response. The question
   is regarding to how Query works. Now I repost it in a more
   specific way.
  
   I am just wondering how MySQL API functions work. Let's look
   at following two functions:
  
   1. mysql_query(),
   2. mysql_fetch_array()
  
   To my understanding, mysql_query() will definately to its job with
   MySQL server. But how about the latter? Does it just fetch data
   from client/local buffer, which is previously put in by 
 mysql_query(),
   or still has to goto server side to fetch data?
  
   Alex
  
   
 -
   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

-
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


_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


-
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

-
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 on Linux 2.4 question

[Nally, Tyler G.]

Amazing!  I've not had a chance to upgrade a server to
2.4 yet, though I've long imagined that the results would
be similar.

I imagine the biggest performance boost you received is  
due to the built-in multi-threading that the 2.4 kernel 
enjoys which is currently lacking in the 2.2 kernel.  

Linux is becoming more robust all the time along with a 
pretty hard kernel.  It's come a long way in a 
short time.  Linux is developing along a more solid path
than Windoze.  Even the big boys are turning to open
source to handle the high-traffic/high-availability
jobs.  Yahoo saved somewhere around 17 million dollars
by switching needed infrastructure over to linux/open 
source.  I just read today that MySQL is their big
database that handles 800 transactions a second for their
stock quotes and financial handlings.

In the year that M$ wants to rent the OS to you, linux
will only continue to grow in it's usage as the desktop
gets more friendly and the applications are developed 
to make people want to use linux instead of windoze.

Tyler

 -Original Message-
 From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, January 09, 2002 5:18 PM
 To: [EMAIL PROTECTED]
 Subject: MySQL on Linux 2.4 question
 
 
 Anyone else out there been playing with the new Linux 2.4 kernel? 
 
 I just upgraded a test server from 2.2 to 2.4 and reran some 
 of my InnoDB
 tests. The results were dramatic; updating a 600,000 row 
 table went from 21
 minutes and change to 6 minutes and change.
 
 Haven't tried 2.4 and MyISAM tables yet; on 2.2 the same 
 update ran in about
 8 minutes.
 
 This is obviously a big improvement, if my tests are valid. 
 It's SUCH a big
 improvement that I'm wondering if I messed something up.
 
 Any comments/statement of support/snide remarks will all be 
 appreciated.
 
 Thanks,
 
 --Walt Weaver
   Bozeman, Montana
 
 -
 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
 

-
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: GUI for Windows

[Tyler Longren]

Might wanna try MySQL Front at http://www.mysqlfront.de.
It's pretty good.

Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com


- Original Message -
From: John Mayson [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, December 24, 2001 6:41 PM
Subject: GUI for Windows


 Eventually my databases will be on my Linux system.  In the meantime, is
there a
 Windows program that builds a quick and dirty GUI interface for my SQL
databases?

 Thanks,
 John

 --
 John Mayson   KC4VJO Linux/Perl/HP-UX/ICT
 Austin, Texas 78729 30.4560N 97.7851W
 [EMAIL PROTECTED] http://www.nyx.net/~jmayson



 -
 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



-
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

PASSWORD() question

[Tyler Longren]

Hello,

I have some usernames and passwords.  The passwords have had the PASSWORD()
function used on them.  I need to set up an area of a site to allow users to
have their passwords e-mailed to them.  I can't just say SELECT password
FROM table WHERE email='$email' AND username='$username' because that will
give me a bunch of gibberish.  Is there anyway to get the password back into
plaintext to be emailed to the user?

Thanks,
Tyler Longren



-
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

Error 1045 - Access denied

[Tyler Longren]

Hello,

I keep on getting 1045 - Access denied for user: [EMAIL PROTECTED]
(using password: YES)
errors.  I'm connecting to this MySQL server from a remote site.

I don't see any reason for this.  I KNOW that my password is correct.  In
the user table, the Host is set to % for the mysql user.  There's also
another entry for the mysql user and the host on that is set to
localhost.  Could having 2 of the same usernames have an effect on this?
I really don't see any reason that I can't connect to this MySQL server from
a remote site.

Thanks all,
Tyler


-
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 1045 - Access denied

[Tyler Longren]

Hello,

I created the entries by adding them manually to the table (not using
GRANT).  And yes, I did run FLUSH PRIVILEGES.  Anything else I should try
doing?  The MySQL manual didn't really provide much help.

Thanks!
Tyler

- Original Message -
From: Carsten H. Pedersen [EMAIL PROTECTED]
To: Tyler Longren [EMAIL PROTECTED]; MySQL List
[EMAIL PROTECTED]
Sent: Wednesday, December 05, 2001 3:28 PM
Subject: RE: Error 1045 - Access denied


  Hello,
 
  I keep on getting 1045 - Access denied for user: [EMAIL PROTECTED]
  (using password: YES)
  errors.  I'm connecting to this MySQL server from a remote site.
 
  I don't see any reason for this.  I KNOW that my password is correct.
In
  the user table, the Host is set to % for the mysql user.  There's
also
  another entry for the mysql user and the host on that is set to
  localhost.  Could having 2 of the same usernames have an effect on
this?
  I really don't see any reason that I can't connect to this MySQL
  server from
  a remote site.

 How were the entries created? Using GRANT ... or by editing
 the user table directly? In the latter case, did you remember
 to FLUSH PRIVILEGES?

 / Carsten
 --
 Carsten H. Pedersen
 keeper and maintainer of the bitbybit.dk MySQL FAQ
 http://www.bitbybit.dk/mysqlfaq



 -
 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




-
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; Backups?

[Tyler Longren]

mysqldump -uusername -ppassword -hhostname dbname  dbname.sql

That will dump the database 'dbname' into the file 'dbname.sql'

Tyler Longren

- Original Message -
From: ROGGER ALEXIS VASQUEZ MARTINEZ [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 29, 2001 9:40 AM
Subject: NewBie Question; Backups?


 How do I make a Backup of a MYSQL database ,,,
 It is simple as just copying the files of each table ?
 or exists a command to make backup ( including TEXT Fields ) ?

 Thanks

 -Original Message-
 From: Michael Widenius [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, November 29, 2001 10:51 AM
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Subject: Re: Proposal for two (or more) new time and date functions



 Hi!

  Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes:

 Jeremy On Wed, Nov 28, 2001 at 01:30:42PM -0800,
[EMAIL PROTECTED]
 wrote:
 
  I think while you've got the hood up, a better method of doing the
  difference between two dates should be derived.
 
  Unless I'm going about this all wrong, the only way to get the time
  difference between two values currently is:
 
  UNIX_TIMESTAMP(end_datetime) - UNIX_TIMESTAMP(start_datetime)
 
  Wouldn't something like SECONDS_DIFF(start,end) make more sense?  Or
  perhaps TIME_DIFF(start,end)?

 Jeremy It's not the only way, but none of them are as simple as a

 Jeremy   SELECT date1 - date2

 The problem with implementing the above simple expression is that you
 can easily run into problems because of the automatic convert of
 strings to numbers.  For example: What should we do if one of the
 strings is a date and the other is a number or a string ?

 If we would do the above, then we would also be able to handle:

 SELECT 2001-01-01 - date from table_name;

 SELECT 2001-01-01 - 2000-01-01;

 One simple solution is to to only do this if both columns are of type
 DATE.  You can always 'cast' a column to date with:

 SELECT DATE 2001-01-01 - DATE 2000-01-01;

 How would this sound?

 Regards,
 Monty


 -
 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


 -
 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



-
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: What is errno: 13

[Tyler Longren]

I think that's the error code that's spit out when permissions are wrong on
the DB file.  You might want to check permissions.

Good luck,
Tyler Longren

- Original Message -
From: Venu Allavatam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 28, 2001 4:10 PM
Subject: What is errno: 13


 Hello All:
 I am working on a particular database, which I created
 some days ago in mysql ver. 3.23.36. I am quite sure
 that I have not made any changes to the system (Dell
 WS with Red Hat Linux 7.1) either. What I see is
 this...

 ###
 [Venu@localhost Venu]$ db
 Enter password:
 Reading table information for completion of table and
 column names
 You can turn off this feature to get a quicker startup
 with -A

 Didn't find any fields in table 'ecg_datafile'
 Didn't find any fields in table 'event_info'
 Didn't find any fields in table 'event_lookup'
 Didn't find any fields in table 'lead_lookup'
 Didn't find any fields in table 'properties_info'
 Didn't find any fields in table 'record_info'
 Didn't find any fields in table 'subject_info'
 Welcome to the MySQL monitor.  Commands end with ; or
 \g.
 Your MySQL connection id is 7 to server version:
 3.23.36

 Type 'help;' or '\h' for help. Type '\c' to clear the
 buffer

 mysql use sadms
 Database changed
 mysql
 mysql
 mysql select * from ecg_datafile;
 ERROR 1017: Can't find file:
 './sadms/ecg_datafile.frm' (errno: 13)
 mysql quit
 Bye
 [Venu@localhost Venu]$

 #

 what is this error? I created all these tables a few
 days back and now I am unable to view them. Could
 anyone suggest what is going and what the solution is?

 Thanks
 Venu

 __
 Do You Yahoo!?
 Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
 http://geocities.yahoo.com/ps/info1

 -
 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



-
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

Select in groups of 5

[Tyler Longrne]

Hello everyone,

Is there any way to make selections in groups of 5.  I want to get 5 record
sets at a time until we get to a point that there's 4 or less records.

Thank you everyone,
Tyler

database,sql,query,table


-
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

Error: 6 (Errcode: 13)

[Tyler Longren]

DROP TABLE Track
Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13)

Anyone know what that means?  As you can see, it came from tryign to do a
DROP on a table.

Thanks,
Tyler Longren


-
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: PHP Warning

[Tyler Longren]

Does /var/lib/mysql/mysql.sock exist???

--
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com



On Tue, 21 Aug 2001 10:06:43 -0700 (PDT)
my sql [EMAIL PROTECTED] wrote:

 On a new install of Suse 7.2 I get this message when
 attempting to acces MySQL through a php scrpipt in
 apache 1.30.20 (MySQL 3.23.39 and PHP 4.0.6):
 
 Warning: Can't connect to local MySQL server through
 socket '/var/lib/mysql/mysql.sock' (2) in
 /usr/local/apache_1.3.20/htdocs/dbtest.php on line 16
 
 any ideas?
 
 __
 Do You Yahoo!?
 Make international calls for as low as $.04/minute with Yahoo! Messenger
 http://phonecard.yahoo.com/
 
 -
 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

-
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 only stores one word?

[Tyler Longren]

post some code.  Make sure you're using quotes in the right places.

Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com



On Tue, 14 Aug 2001 13:39:48 -0700
Nate Sanden [EMAIL PROTECTED] wrote:

 Hey im pretty new to mysql, but I made a basic html form and used php to
 post it to my mysql database. It goes in fine, but it only carries the
 first word in each input box. So say for description I put in My
 little white dog it only stores My in the database. Would appreciate
 any insight you may have! Thanks.
 

-
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: Problems compiling mysql on linux 7.0

[Tyler Longren]

Which Linux 7.0 are you using?
I'll assume you're talking about Redhat.  So why don't you just download
the mysql rpm and install it instead of doing it from source?

Good luck,
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com


-
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: Sub select.

[Tyler Longren]

I don't think MySQL supports sub selects.

Tyler


On Tue, 07 Aug 2001 14:57:33 +0200
Anders Alstrin [EMAIL PROTECTED] wrote:

 Does anyone know how to do this sub select in MySQL.
 I know how to do it in Oracle!
 
 table media
 +--+---+--+
 | media_id | price |filename  |
 +--+---+--+
 |3 | 0 | cal.jpg  |
 |   82 | 0 | Soa.jpg  |
 |   13 | 0 | ca.jpg   |
 |   71 | 0 | gt.pdf   |
 |   67 | 0 | low.pdf  |
 |   68 | 0 | 10.pdf   |
 |   83 | 0 | B5.pdf   |
 +--+---+--+
 
 table category_locks
 +--+-+--+
 | category_lock_id | category_id | media_id |
 +--+-+--+
 |   92 |   0 |   68 |
 |   93 |   0 |   67 |
 |   94 |   0 |   13 |
 |   91 |   0 |   71 |
 |   90 |   0 |3 |
 |  118 |  43 |   82 |
 |  121 |  43 |   83 |
 +--+-+--+
 
 table categories
 +-+-++---+--+
 | category_id | category_up | upload | dynamic_media | name |
 +-+-++---+--+
 |  43 |   0 | false  | true  | web  |
 |  0  |   0 | false  | false | trine|
 |  0  |   0 | false  | false | shop |
 +-+-++---+--+
 
 A Oracle way to do it:
 
 SELECT * FROM media
 WHERE media_id = (SELECT media_id FROM category_locks
 WHERE category_id = (SELECT category_id FROM categories
 WHERE dynamic_media = 'true'))
 
 A MySQL way to do it?
 
 
 -
 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
 

-
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 and PHP

[Tyler Longren]

No need to install locally.  You could write everything locally, upload it
to the server, and see if what you wrote works.

Tyler


On Tue, 7 Aug 2001 13:51:01 +0100
Matt Gaskin [EMAIL PROTECTED] wrote:

 Hi All
 
 Currently I have rented space on a Web Server that has MySql installed
 and
 PHP, They have created a database directory for myself. Do I need to
 install
 Mysql and PHP locally to take advantage of this. If so where do I start.
 I
 have had no experience of the above two products, although I have
 written a
 number of websites in HTML and a number of access databases. We have
 just
 started to get a number of enquiries for databases online and would like
 to
 develope in this area.
 
 Thanks
 M
 
 
 -
 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

-
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: Remote MySQL Console?

[Tyler Longren]

Get the mysql client from www.mysql.com.

Tyler

On Sun, 5 Aug 2001 13:38:09 -0400
Chris [EMAIL PROTECTED] wrote:

 Is there a method I can use to log into a remote mysql server through
 something such as telnet to pass queries on my database?
 

-
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: Adding a [mysql] to the subject line

[Tyler Longren]

You could just filter for [EMAIL PROTECTED].  That's what I do.

Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com



On Tue, 7 Aug 2001 17:12:29 -0700, Randy Johnson wrote:
I am not sure if this has been addressed before, I think it would be
neat if
the list admin could put a [mysql] in the subject line for messages.
 I get
a lot of email and it would help having that in the subject line.
it would
also help me in filtering my mail.  Please let me know your
comments.


Randy


-

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-
[EMAIL PROTECTED]
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php





-
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: Can't stop msqld

[Tyler Longren]

$ ps -ax | grep mysqld
get the pid of mysql
$ kill -9 pid_of_mysql

that'll do it.

:)

Tyler

On Thu, 26 Jul 2001 13:24:41 -0500
cjackson [EMAIL PROTECTED] wrote:

 Hello all,
 
  I just installed mysql 3.23.32-1.7 with an rpm on redhat7.0 server
 running apache and php. I could start msqld and shut it down.
 Then I created a password for root. Mysql still starts but I can't stop
 it as root or any other user. It runs as user mysql which also
 requires password.
 
 Thanks,
 Jackson
 
 -
 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

-
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: Problems running ./mysql_install_db

[Tyler Longren]

Try doing it as root if you're not already.

Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com


- Original Message -
From: Michael Nezi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 25, 2001 11:08 AM
Subject: Problems running ./mysql_install_db


 When installing mysql the only problem I receive is the following
 which cannot install the grant tables.  I am unable to view the log
 because my access is denied.

 What to do? Anyone?



 [localhost:/usr/local/bin] nezi% ./mysql_install_db
 mkdir: /usr/local/var/mysql: Permission denied
 chmod: /usr/local/var/mysql: Permission denied
 mkdir: /usr/local/var/test: Permission denied
 chmod: /usr/local/var/test: Permission denied
 Preparing db table
 Preparing host table
 Preparing user table
 Preparing func table
 Preparing tables_priv table
 Preparing columns_priv table
 Installing all prepared tables
 /usr/local/libexec/mysqld: Can't change dir to '/usr/local/var/' (Errcode:
13)
 010725  9:56:55  Aborting

 010725  9:56:55  /usr/local/libexec/mysqld: Shutdown Complete

 Installation of grant tables failed!

 Examine the logs in /usr/local/var for more information.
 You can also try to start the mysqld daemon with:
 /usr/local/libexec/mysqld --skip-grant 
 You can use the command line tool
 /usr/local/bin/mysql to connect to the mysql
 database and look at the grant tables:

 shell /usr/local/bin/mysql -u root mysql
 mysql show tables

 Try 'mysqld --help' if you have problems with paths. Using --log
 gives you a log in /usr/local/var that may be helpful.

 The latest information about MySQL is available on the web at
 http://www.mysql.com
 Please consult the MySQL manual section: 'Problems running
mysql_install_db',
 and the manual section that describes problems on your OS.
 Another information source is the MySQL email archive.
 Please check all of the above before mailing us!
 And if you do mail us, you MUST use the /usr/local/bin/mysqlbug script!

 --

 -
 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


-
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

not selecting last row

[Tyler Longren]

Hi everyone,

Is there a way to NOT select the last row that was inserted into a table?  I
want everything before it.

I know how I could do this using 2+ queries, but can it be done by issuing
just 1 query?

Thanks everyone,
Tyler



-
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: not selecting last row

[Tyler Longren]

That should work just fine.  :)

Thanks!

- Original Message -
From: John Meyer [EMAIL PROTECTED]
To: Tyler Longren [EMAIL PROTECTED]; MySQL List
[EMAIL PROTECTED]
Sent: Friday, July 20, 2001 3:21 PM
Subject: Re: not selecting last row


 At 12:25 PM 7/20/01 -0500, Tyler Longren wrote:
 Hi everyone,
 
 Is there a way to NOT select the last row that was inserted into a table?
I
 want everything before it.
 
 I know how I could do this using 2+ queries, but can it be done by
issuing
 just 1 query?
 
 Thanks everyone,
 Tyler

 Assuming you had a unique ID, couldn't you do it this way:

 SELECT * FROM TABLE WHERE ID=!LAST_INSERT_ID();


 John Meyer
 [EMAIL PROTECTED]
 Programmer


 If we didn't have Microsoft, we'd have to blame ourselves for all of our
 programs crashing


-
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: Easiest way to create a duplicate of a db?

[Tyler Longren]

copy a table:
mysqldump database table_name  table.sql

or to copy the whole db:
mysqldump database  db.sql


- Original Message -
From: Victor Spång Arthursson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 09, 2001 12:51 PM
Subject: Easiest way to create a duplicate of a db?


 For example if I want a copy of products named products1?

 Sincerely Victor

 query


 -
 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



-
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: How do I restore a database backed up using mysqldump?

[Tyler Longren]

do this:
mysql -uusrename -ppassword dbname  brand.txt
mysql -uusrename -ppassword dbname  brand.sql

Tyler

- Original Message -
From: Victor Spång Arthursson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 02, 2001 1:59 PM
Subject: How do I restore a database backed up using mysqldump?


 Hi!

 Mysqldump creates the files brand.txt  brand.sql etc.

 How do i restore the database in a simple way..?

 I've looked in the manual but couldn't find out...

 Sincerely Victor


 -
 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


-
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

system error 1067

[Tyler Longren]

Hello everyone,
I have mysql-3.23.39 installed on a Win2k Pro box (not sure why!).  It had
been running just fine, then all of a sudden stopped working.  When I try a
'NET START mysql', I get the below error:
---Begin Error
The MySql service is starting.
The MySql service could not be start

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.
---End Error

Has this happened to anyone else?  Or am I just the unlucky one?

Tyler


-
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: constraint question

[Tyler Longren]

just do:
mysqldump options db_name  db_name.sql

Your database tables and contents will be dumped into db_name.sql

Tylre

- Original Message -
From: ah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 21, 2001 12:19 PM
Subject: constraint question


 hi

 I am using mysql 3.23.29 under windows 2000.I have a table:

 create table

ies( 
 libID   bigint NOT NULL AUTO_INCREMENT ,
 lib_datsvrID  bigint   null,
 primary key (libID),
 constraint FK_LIBRAR_REF_584_DATASE foreign key  (lib_datsvrID) references 
DataServers (datsvrID))
 
 I want to know how to view the constraints defined for libraries.
 
 I have another question: i want to do a backup of my database using mysqldump.
 what's the syntax of mysqldump database  (under windows)
 
 thanks for help
 cheers
 
 
 -
 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



-
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: Connect mySQL with HTML or something

[Tyler Longren]

You'd probably be interested in PHP:
www.php.net

Tyler
- Original Message -
From: Laura Lía Marcello [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 21, 2001 12:03 PM
Subject: Connect mySQL with HTML or something


I need to know if there is a way to create a searchable database that
returns results as a web page...
As you can see, I'm just begining, so I would really apreciate an answer,
even if it's short.

Thanks!

Laura Lía Marcello
Web Development

www.editorialargenta.com
www.marketaxa.com
www.newsbookonline.com
Avda. Corrientes 1250 Piso 3º oficina F tel. 4382-9085 (rot) 1043 Capital
Casilla Postal 233 suc. 12 (1412) Buenos Aires - Argentina



-
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


-
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: inserting images in mysql tables

[Tyler Longren]

you should probably just store the images on your server, and provide the
location to the image in the table...much quicker.

Tyler

- Original Message -
From: Felicia [EMAIL PROTECTED]
To: mysql post [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 11:03 AM
Subject: inserting images in mysql tables


I am new to mysql.  I am attempting to place images in one of my columns. As
for my table structure, I have gotten as far as:

image blob NOT NULL,

How should I proceed?

Thanks a bunch


Get free email and a permanent address at http://www.netaddress.com/?N=1

-
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


-
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 GUI for windows NT/98 is it available?

[Tyler Longren]

http://mirror.sit.wisc.edu/mysql/downloads/gui-clients.html

Tyler

- Original Message -
From: John Kennedy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 13, 2001 10:31 AM
Subject: mysql GUI for windows NT/98 is it available?


 I am just curious to know whether you have any GUI for mysql for Windows
 NT/98? If so kindly send me the link where I could download it. I am
curios
 to work on MYSQL.

 thanks
 John
 _
 Get your FREE download of MSN Explorer at http://explorer.msn.com


 -
 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


-
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 Port number

[Tyler Longren]

Default mysql port is 3306.

Tyler


 -Original Message-
 From: sanborn [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, June 05, 2001 9:36 PM
 To: MySQL Mailing List
 Subject: MySQL Port number
 
 
 How is MySQL used over a network?  I assume there is a port involved, and
 some kind of transaction server built into mysql?  How do I 
 configure, test
 this?  In the several documents I have read so far, I haven't 
 found much on
 the subject.  Thanks for your input.
 
 Gene Sanborn
 

-
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

update query produces warnings?

[Tyler Longren]

Hello everyone,

I have a database of alumni at school.  Each alumnus that registers gets assigned 
their own id.  Id's are made with mysql's auto_increment.  Everything worked fine 
until a few days ago when everybody that signed up got the id of 127 assigned to them. 
 MySQL will NOT assign them an id higher than 127.  So, now everybody that signs up 
gets the id of 127.  I tried to fix this by using update on the table...here is an 
example of the table:

ID | fname | lname
---
127 | MaryBeth | Elliott
---
127 | Becky | Beving
---
127 | Russell | Oswalt
---
127 | Wanda | Oswalt
---
127 | Brandon | Kohlwes
---
127 | Kenneth | Smith, Jr.
---
127 | Benjamin | Dykstra
---
127 | Laura | Hand
---
126 | Eric | Beal
---
125 | Doug | Franklin
---

Here is what I used to try to UPDATE the id:
UPDATE alumni SET id=128 WHERE fname='Benjamin' AND lname='Dykstra';
That didn't work, it said that 0 lines were changed and there was one warning 
(couldn't figure out how to read the warning).

I also tried this:
UPDATE alumni SET id=id+1 WHERE fname='Benjamin' AND lname='Dykstra';
That also didn't work...same result as above.

I am convinced that my syntax is correct because phpMyAdmin can't even change the id.  
Anybody have any ideas why this happened?  BTW, I'm running mysql-3.23.38 on NT4.

Thanks everyone,
-- 
Tyler Longren
[EMAIL PROTECTED]
Currently Unemployed
www.noworkfortyler.com


-
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: update query produces warnings?(fixed)

[Tyler Longren]

This post can be ignored now.  Turned out the datatype for the id field was set to 
tinyint, changed it to int and everything worked great.

Tyler

On Thu, 31 May 2001 00:26:12 -0500
Tyler Longren [EMAIL PROTECTED] wrote:

 Hello everyone,
 
 I have a database of alumni at school.  Each alumnus that registers gets assigned 
their own id.  Id's are made with mysql's auto_increment.  Everything worked fine 
until a few days ago when everybody that signed up got the id of 127 assigned to 
them.  MySQL will NOT assign them an id higher than 127.  So, now everybody that 
signs up gets the id of 127.  I tried to fix this by using update on the table...here 
is an example of the table:
 
 ID | fname | lname
 ---
 127 | MaryBeth | Elliott
 ---
 127 | Becky | Beving
 ---
 127 | Russell | Oswalt
 ---
 127 | Wanda | Oswalt
 ---
 127 | Brandon | Kohlwes
 ---
 127 | Kenneth | Smith, Jr.
 ---
 127 | Benjamin | Dykstra
 ---
 127 | Laura | Hand
 ---
 126 | Eric | Beal
 ---
 125 | Doug | Franklin
 ---
 
 Here is what I used to try to UPDATE the id:
 UPDATE alumni SET id=128 WHERE fname='Benjamin' AND lname='Dykstra';
 That didn't work, it said that 0 lines were changed and there was one warning 
(couldn't figure out how to read the warning).
 
 I also tried this:
 UPDATE alumni SET id=id+1 WHERE fname='Benjamin' AND lname='Dykstra';
 That also didn't work...same result as above.
 
 I am convinced that my syntax is correct because phpMyAdmin can't even change the 
id.  Anybody have any ideas why this happened?  BTW, I'm running mysql-3.23.38 on NT4.
 
 Thanks everyone,
 -- 
 Tyler Longren
 [EMAIL PROTECTED]
 Currently Unemployed
 www.noworkfortyler.com
 
 
 -
 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


-
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

sql to select 2 entries/name?

[Tyler Longren]

Hello list,

I have a table in a database that has a field named 'artist'.  There are multiple 
entries of the same artist/band.  Example:
deftones
iggy pop
kiss
deftones
glassjaw
deftones
kiss
new found glory
kiss

There's 3 entries for deftones and 4 entries for kiss.  What I need to do is select a 
maximum of 2 entries for each artist.  I've tried a few different things, but nothing 
has given me what I need.  Is there any way to do this?

Thanks everyone,
Tyler Longren

-
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: can't shutdown mysqld (nicely or not) on OS X 10.0.2

[tyler]

Hi Jim,

This is a known problem on OS X 10.0.x.

I keep meaning to take a look at it, but haven't had the time ( I have 
to learn gdb and the mysql source first/at the same time).  If you are 
already a familiar with gdb and can help the mysql programmers by 
finding out more info and/or even a fix, that would help get this fixed.

safe_mysqld has the job of keeping a copy of mysqld running.  If it 
finds mysqld not running (or if one dies?), it will start another.  So 
if you kill -9 on safe_mysqld first and then on mysqld you can get them 
all stopped.

If you just kill -9 mysqld then safe_mysqld is simply starting another 
for you (just doin' it's job don't cha know!).

I'd love to get mysql working on OS X, I'm just really swamped right now 
and behind the learning curve for this unix stuff being a mac hack.


One pointer I received from Sinisa (from the mysql dev team):

 Signal handling is all done in mysqld.cc in sql/ subdir.

which is where we need to start I think since it appears that mysql's 
handling of the shutdown signal is not working.   If you run the 
mysql-test-run script it has trouble and says:

 Warning;  Aborted waiting on pid file: '/usr/local/mysql-
 test/var/run/mysqld-slave.pid' after 10 seconds
 Slave shutdown finished

that's what makes it seem like the signals are not working.  Either that 
or the file locking done on the pid file (what is that done for and who 
does it?  I don't know).


Let me know if you make any progress.

Tyler



On Saturday, May 5, 2001, at 10:58 AM, Jim McCarty wrote:

 From: [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Subject: can't shutdown mysqld (nicely or not) on OS X 10.0.2

 Description:
 After starting mysqld with:

 safe_mysqld --user-mysql 

 I cannot shutdown the daemon. None of the mysqladmin commands work, 
 kill
 -HUP does nothing and after using kill -9, mysqld restarts.
 I've tried with 10.0.1 as well as 10.0.2 and also trashing 
 everything
 and rebuilding from the source again.

 How-To-Repeat:
 On my system (following instructions in INSTALL-SOURCE), DL 3.23.37
 source and extract in /usr/local. From mysql-3.23.37/  run configure 
 with:

 ./configure --with-pthread --with-named-curses-libs=''
 --with-named-thread-libs='' --prefix=/usr/local/mysql

 configure completes without hitch. Next, compile with:

 make -i

 compile completes without hitch. Then I 'make install',
 'scripts/mysql_install_db' and the rest.
 I start testing the installation but I can't stop the daemon! I can 
 only
 kill it with 'kill -9' but then it restarts again immediately.

 Fix:

 Submitter-Id:
 Originator:System Administrator
 Organization:
 MySQL support: none
 Synopsis:  Cannot shutdown daemon on OS X 10.0.2
 Severity:  serious
 Priority:  medium
 Category:  mysql
 Class: sw-bug
 Release:   mysql-3.23.37 (Source distribution)

 Environment:
 System: Darwin localhost 1.3.2 Darwin Kernel Version 1.3.2: Fri Apr 27
 22:50:58 PDT 2001; root:xnu/xnu-124.7.obj~1/RELEASE_PPC  Power Macintosh
 powerpc


 Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/cc

 Compilation info: CC='cc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
 LIBC:


 lrwxr-xr-x  1 root  wheel  15 May  1 23:49 /usr/lib/libc.dylib -
 libSystem.dylib
 Configure command: ./configure  --with-pthread --with-named-curses-libs=
 --with-named-thread-libs= --prefix=/usr/local/mysql

 Thanks, Jim


 -
 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-
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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: What do I do now?

[tyler]

stat error seems like a permissions error.

I'd guess it's a permissions problem.   Perhaps figure out what user the 
process trying to stat the file is running under and then figure out 
what permissions that user has on the file in question.
(Also check the directory chain going up for permissions being 
appropriate?).

luck,
Tyler


On Wednesday, May 2, 2001, at 07:22 PM, Paul DuBois wrote:

 At 11:52 PM -0600 5/1/01, Colin Faber wrote:
 why not just use the LOAD DATA INFILE option?

 That probably won't help much.  All the mysqlimport does is issue
 a LOAD DATA statement for you.

 LOAD DATA LOCAL INFILE might help, though.  Or mysqlimport --local.
 At least, if the file_name.csv file is on the client host.



 Bombardier Systems Consulting wrote:

  HELP!!!

  I sent a message to this forum a couple of days ago about a problem 
 that I
  am having with MySQL 3.23.37 (and now 36) running under RedHat 7.1.

  I am trying to use the mysqlimport utility and continue to get the 
 following
  error:

  mysqlimport: Error: Can't get stat of '/home/yada/yada/file_name.csv'
  (Errcode: 13), when using table: file_name

  This utility was working when I was running 3.23.36 and RedHat 7.0 
 but
  RedHat kept crashing and so I had to upgrade to 7.1.  When I 
 installed MySQL
  I got the 3.23.37 version of MySQL.  I have since re-installed 
 RedHat 7.1
  and the MySQL 3.23.36 version and am getting the same error.  I 
 looked up
  the error in the documentation and tried the UMASK change, rebooted, 
 created
  new directory and moved file into it...still same problem.

  ANY ASSISTANCE WOULD BE APPRECIATED!

  Jim

  -
  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-
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try: 
 http://lists.mysql.com/php/unsubscribe.php

 -
 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-
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


 -- Paul DuBois, [EMAIL PROTECTED]

 -
 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-
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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: What can I do to help the mysql developers to get mysql to work on OS X?

[tyler]

On Tuesday, May 1, 2001, at 04:42 AM, Sinisa Milivojevic wrote:

 [EMAIL PROTECTED] writes:
 So, I'd really like to have mysql working on OS X and while there 
 were a
 few people trying it out and having difficulty, I have yet to see any
 posts of total success.

 I'm an experienced MacOS programmer, but I have little experience on
 Unix --  so I'm way behind the curve on looking at the source and
 figuring it out.  My only thought is to try to dive in and run mysqld
 via gdb and then try to figure out the source tree sufficiently to see
 where the shutdown (HUP?) message is getting handled and then set a
 breakpoint to see if that code is ever getting called and watch where 
 it
 gets stuck by tracing from there.

 Unfortunately, I don't know how to use gdb (yet), and there is a LOT of
 source to slog through to find where the shutdown code is.Perhaps a
 more experienced unix hack could recommend some starting places; 
 perhaps
 someone more experienced with the mysql source could point me to the
 locations of signal handling code (I hope it's not too obvious, since I
 haven't even looked yet... :-(  Got to get gdb working first... ).


 So, if there is something I can do here to help get the issues 
 resolved,
 I'd like to do so.  Please feel free to email me directly with
 suggestions, staring points etc.,  if that helps.

 Thanks,
 Tyler
 [EMAIL PROTECTED]


 P.S.  The problems I have seen posted and experienced myself are:

 1) the small edit to get it to compile (not a big deal, but should get
 fixed)

 2) The mysqld cannot be stopped short of kill -9

 3) trying to use mysqladmin shutdown to stop mysqld (and safe_mysql)
 fails (hangs, requires kill -9 to halt)

 4) the tests do not work.
   4a) make test fails
   4b) mysql-test-run   fails




Thank you Sinisa for responding.   I have made some responses below and 
I have included the logs and errors from the test run.The errors may 
perhaps give you a clue that can direct my further efforts.  Please find 
them below after the screen output of running the tests.

Thanks very much for your assistance!  I'd really like to have Mac OS X 
be a fully supported mysql platform!


 You should first learn to use gdb ... ;o)

 It is truly not so difficult.

I figure, just a matter of TIME :-)

so I'm rebuilding with the -with-debugging=full now and hopefully 
that'll help see stuff.

 Regarding a diff to make it compile, if you have not sent it to us,
 please do.

I have not, but I saw someone else on the list saying they would (or you 
asked them to).

 Regarding second and third problem, you should take a deeper look at
 OS X signals and try to see what goes on. Signal handling is all done
 in mysqld.cc in sql/ subdir.

OK that's what I needed a pointer to where to look in the source.

 Regarding failing tests, you should examine the error log.


Ok.   Here's the output to the screen:

 ./mysql-test-run
 Installing Test Databases
 Removing Stale Files
 Installing Master Databases
 Installing Slave Databases
 Starting MySQL daemon
 Loading Standard Test Databases
 Starting Tests

  TEST USER   SYSTEM  ELAPSEDRESULT
 
 alias 0.03 0.02 0.25   [ pass ]
 alter_table   0.04 0.01 0.29   [ pass ]
 analyse   0.02 0.02 0.12   [ pass ]
 auto_increment0.01 0.02 0.26   [ pass ]
 backup0.01 0.06 0.27   [ pass ]
 bdb-crash 0.02 0.03 0.07   [ pass ]
 bdb        [ fail ]

 /usr/local/bin/mysqltest: Can't get stat of 'r/have_bdb.require' 
 (Errcode: 2) real 0.07 user 0.02 sys  0.02
 Aborting. To continue, re-run with '--force'.

 Ending Tests
 Shutting-down MySQL daemon

 Warning;  Aborted waiting on pid file: '/usr/local/mysql-
 test/var/run/mysqld.pid' after 10 seconds
 Master shutdown finished
 Warning;  Aborted waiting on pid file: '/usr/local/mysql-
 test/var/run/mysqld-slave.pid' after 10 seconds
 Slave shutdown finished

So it looks like we have the shutdown failure problem here also.  Almost 
looks like it's waiting for the 'lock' on the pid file to be removed 
but I don't really know what I'm talking about...


When I look at the logs, the last thing in each log is:

11 Shutdown

or

2 Shutdown

The .err files say the following:

 tyler% more *.err
 ::
 mysqld-slave.err
 ::
 Warning: One can only use the --user switch if running as root
 /usr/local/bin/mysqld: ready for connections
 010501 19:39:06  Slave: connected to master '[EMAIL PROTECTED]:9306',  
 replication started in log '
 FIRST' at position 4
 010501 19:39:31  Aborted connection 2 to db: 'unconnected' user: 'root' 
 host: `localhost' (Got a
 n error writing communication packets

mysql-test does not work from install directory after source dist. install

[tyler]

 Description:
 There are several problems running the mysql-test-run script from
 the installed directory if you are installing from a source 
distribution.

 e.g., if you do as the manual suggests (4.7.1 Quick Installation 
Overview)


shell groupadd mysql
shell useradd -g mysql mysql
shell gunzip  mysql-VERSION.tar.gz | tar -xvf -
shell cd mysql-VERSION
shell ./configure --prefix=/usr/local/mysql
shell make
shell make install
shell scripts/mysql_install_db
shell chown -R root  /usr/local/mysql
shell chown -R mysql /usr/local/mysql/var
shell chgrp -R mysql /usr/local/mysql
shell /usr/local/mysql/bin/safe_mysqld --user=mysql 


 and then do the seeminly logical:
shell cd /usr/local/mysql/mysql-test
shell ./mysql-test-run

 FIX:
  suggest that script be changed to detect when it has been run in 
the install directory and is part
of a source dist.

Note that the permissions on the installed  mysql-test directory after 
make install are also problematic
and will have to be changed (script will fail when trying to make 
mysql-test/var and sub directories).


  How-To-Repeat:
cd mysql-VERSION
 ./configure --prefix=/usr/local/mysql
 make
 su
 make install
 groupadd mysql
 useradd -g mysql mysql
 scripts/mysql-install_db
 chown -R root /usr/local/mysql
 chown -R mysql /usr/local/mysql/var
 chgrp -R mysql /usr/local/mysql
 exit (to stop being root)
 /usr/local/mysql/bin/safe_mysqld --user=mysql
 cd /usr/local/mysql/mysql-test
 ./mysql-test-run


 Synopsis:  mysql-test-run script does not work from install 
directory after source dist. build/install
 Severity:  serious
 Priority:  medium
 Category:  mysql
 Class: sw-bug
 Release:   mysql-3.23.37 (Source distribution)

 Environment:
System: Darwin localhost 1.3.2 Darwin Kernel Version 1.3.2: Fri Apr 27 
22:50:58 PDT 2001\
; root:xnu/xnu-124.7.obj~1/RELEASE_PPC  Power Macintosh powerpc


SAME problem on Yellow Dog Linux 1.2.1 (based on RedHat Linux).

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/cc

Compilation info: CC='cc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
LIBC:

lrwxr-xr-x  1 root  wheel  15 May  1 12:44 /usr/lib/libc.dylib - 
libSystem.dylib
Configure command: ./configure  -prefix=/usr/local/mysql

-
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: Possible bug in 3.23.32 or later

[tyler]

FWIW:

It also appears to me that negative one (-1) plus one (1) is ZERO (0) 
which may be why you are having trouble...?

in ignorance,
haiku

On Wednesday, April 18, 2001, at 01:09 AM, Milo Stefani wrote:

 As Far as I can remember it is explicitly said in the Manual that 
 inserting
 a negative value in an autoincrement field is a Bad Thing

 - Original Message -
 From: [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Wednesday, April 18, 2001 6:14 AM
 Subject: Possible bug in 3.23.32 or later


 Description:
 When i insert into a negative integer into primary key (id int) field, 
 it
 works fine.
 However, the next insert i do without specifing the id explicitly and
 relying on mysql to
 generate the next number in the sequence (should be 1) will use the 
 upper
 bound (2^32 - 1)
 Then every other insert after that will not insert since there are no 
 id's
 available.


 How-To-Repeat:

 CREATE TABLE category
  (
  idINT NOT NULL AUTO_INCRE17;6,
  name  VARCHAR(50) NOT NULL,
  code  VARCHAR(50) NOT NULL,
  description   TEXT,
  picture   VARCHAR(50),
  parentINT NOT NULL DEFAULT 0,
  activeTINYINT,
  members   INT NOT NULL DEFAULT 0,
  storeid   INT,
  feature1  INT NOT NULL DEFAULT 0,
  feature2  INT NOT NULL DEFAULT 0,
  priority  INT,
  KEY (code),
  KEY (name),
  PRIMARY KEY (id)
  )\g


 INSERT INTO category
 (id,name,code,description,picture,parent,active,members,storeid,feature1,
 fea
 ture2) VALUES (-10,'NEW','NEW','All new products','none',-1,0,0,1,0,0);

 Then try:
 INSERT INTO category
 (name,code,description,picture,parent,active,members,storeid,feature1,featur
 e2) VALUES ('test','test','All test products','none',-1,0,0,1,0,0);

 That should make the id 2^32 -1 (or something aroudn there).

 That id should be 1!!!


 Fix:



 Submitter-Id: submitter ID
 Originator: Duane Homick
 Organization:
 Inline Internet Systems, Inc.

 MySQL support: none
 Synopsis: bug in primary key insert with negative integers
 Severity: serious
 Priority: medium
 Category: mysql
 Class: sw-bug
 Release: mysql-3.23.32 (TCX binary)

 Environment:


 -
 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


 -
 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-
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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: problem

[tyler]

On Wednesday, April 18, 2001, at 07:29 AM, B. van Ouwerkerk wrote:


 I'm trying to install mysql onto a uniz environment.
 I've already unzipped and untarred, and I've created
 the mysql - version directory, but when I type
 configure, I get a grant table failed error.  I cant
 find anything on how to fix this.

 Take a look at www.devshed.com they've got a nice tutorial..


more specifically:

mysql basic area:http://www.devshed.com/Server_Side/MySQL/

and grant tables:

http://www.devshed.com/Server_Side/MySQL/Grant_Tables/

luck,
haiku

-
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