Re: alter table example.

2002-01-10 Thread John Barton

Matt,

alter table table_name add column column_name column_decriptions;

alter table table_name drop column column_name;


Try checking documentation for more details:

http://www.mysql.com/doc/A/L/ALTER_TABLE.html

Hope this helps!



 Can anyone give me an example of an alter table syntax that.

 1.) adds a column
 2.) deletes a column.

 I am reading the examples in the oreilly book, and it does not work
  also the Oracle or Infomix syntax doesn't work.

 can someone give me a clue please.

 Thanks,

 Matt.


 -
 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


John Barton
[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




RE: SSH tunnel MySQL traffic: BOTH remote local?

2002-01-03 Thread John Barton

Try mapping your remote mysql to a different local port, then specify that
port number when you connect.

For example:
'ssh -L 3307:hostip:3306 hostname' will map port 3306 on the remote machine
to port 3307 on your local machine. Then, use
'mysql -P 3307 -u x -p etc.' to connect to port 3307 on your local
machine, and you will hit your remote mysql



 Using the -h hostname or IP should do it.
 mysql -h 10.129.0.2 -u user -p password yadayadayada

 -Original Message-
 From: MySQL baby [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, January 03, 2002 10:28 AM
 To: [EMAIL PROTECTED]
 Subject: SSH tunnel MySQL traffic: BOTH remote  local?


 If I've got one computer with MySQL client and server on it, running
 everything localhost,

 but I want to reach out to another MySQL server, through an SSH tunnel,
 for some things,

 does anyone know how to differentiate between the two?


 Usually, for SSH tunnelling, you access a port # at localhost, but if I
 also need that port # at localhost, (3306), what's a guy to do?


 Any advice appreciated.


 -
 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


John Barton
[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




Re: SSL connection question Again!

2002-01-03 Thread John Barton

Mysql gurus:
I have anxiously been watching the list for a response to this question, but
still no joy. Does anyone have information on how to make an ssl connection
with the mysql client? I have support compiled into the server, but
unfortunately I cant find any documentation on the client side. Thanks in
advance for any help..

 Happy New Year!

 I'm Sorry if this question has been posted often.
 but i cannot find answer.

 I have installed openssl and MySQL 4.0.1 with --with-openssl --with-vio

 And...

 mysql SHOW VARIABLES LIKE '%ssl%' ;
 +---+---+
 | Variable_name | Value |
 +---+---+
 | have_openssl  | YES   |
 +---+---+
 1 row in set (0.10 sec)

 and I granted somebody with REQUIRE SSL.

 But He cannot connect to MySQL using mysql .

 mysql client does not support SSL connection?

 How can he/she connect to MySQL with SSL?

 about PHP and MySQL?

 I'm very pleased if give me any Information !

 Thank you for advanced Answer!


Homepage = http://www.nnr.or.kr/inos/
ICQ # = 123534385
Member of DSN(database.sarang.net), NNR(nnr.or.kr)



 --MIME Multi-part separator--


 -
 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


John Barton
[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




Re: ALTER Syntax Question

2001-11-09 Thread John Barton

Sure is:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html

John Barton
[EMAIL PROTECTED]
http://jbarton.technicalworks.net

On Fri, 9 Nov 2001, Brad Harriger wrote:

 Is it legal to change a field name to the same name as in the following?

 ALTER TABLE t1 CHANGE a a INTEGER;

 Thanks,

 Brad



 This e-mail and any files transmitted with it are confidential and are intended 
solely for the use of the individual or entity to whom they are addressed. This 
communication may contain material protected by legal privileges or statutory 
protections.  If you are not the intended recipient or the individual responsible for 
delivering the e-mail to the intended recipient, please be advised that you have 
received this e-mail in error and that any use, dissemination, forwarding, printing, 
or copying of this e-mail is strictly prohibited. If you have received this e-mail in 
error, please immediately notify us and delete the original message. Upon request, we 
will reimburse you for reasonable costs incurred in notifying us.


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

2001-10-30 Thread John Barton

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

check mysql.user, you probably have permission for franck@localhost, which
succeeds when you omit the -h, but no permission for
[EMAIL PROTECTED], so you fail when you specify that is where you
are coming from.

John Barton
[EMAIL PROTECTED]
http://jbarton.technicalworks.net

On Tue, 30 Oct 2001, COLLINEAU Franck FTRD/DMI/TAM wrote:

 Hi!

 When i type: mysql -u franck -p then my password, it's ok.

 My machine's name is r-lx-collineau

 When i type mysql - h r-lx-collineau -u franck -p then my password, i have
 this message:
 ERROR 1130: host 'r-lx-collineau' is not allowed to connect to this MySQL
 server

 Can anybody help me ?


 Franck

 -
 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

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE73u4tFllLbUnOIMARAioTAJoDH4Av4CtM54YAXX/gFlycDi34VgCdHohi
OHy/88V+xUTrBMeJRtLqe5k=
=l46z
-END PGP SIGNATURE-



-
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 4.0 bitkeeper source fails to compile

2001-07-02 Thread John Barton

Description:
Mysql 4.0 bitkeeper fails to compile
How-To-Repeat:
Try to compile
Fix:
Fails with a syntax error

Submitter-Id:  submitter ID
Originator:John
Organization:
 
MySQL support: none
Synopsis:  Mysql 4.0 bitkeeper fails to compile
Severity:  non-critical
Priority:  low
Category:  mysql
Class: sw-bug
Release:   mysql-@VERSION@@MYSQL_SERVER_SUFFIX@ (@COMPILATION_COMMENT@)

Environment:

System: Linux nemesis 2.4.6-pre5 #1 Mon Jun 25 10:14:44 CDT 2001 i686 unknown
Architecture: i686

Some paths:  /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)
Compilation info: CC='@CC@'  CFLAGS='@CFLAGS@'  CXX='@CXX@'  CXXFLAGS='@CXXFLAGS@'  
LDFLAGS='@LDFLAGS@'
LIBC: 
-rwxr-xr-x1 root root  1343073 May 11 09:50 /lib/libc.so.6
-rw-r--r--1 root root 24539184 May 11 09:43 /usr/lib/libc.a
-rw-r--r--1 root root  178 May 11 09:43 /usr/lib/libc.so
Configure command: @CONF_COMMAND@



When trying to compile todays bitkeeper archive of Mysql 4.0, it fails with a syntax 
error.

Making all in sql
gmake[2]: Entering directory `/usr/local/src/mysql-4.0/sql'
gmake[2]: warning: -jN forced in submake: disabling jobserver mode.
yacc  -d sql_yacc.yy  mv y.tab.c sql_yacc.cc
yacc: e - line 72 of sql_yacc.yy, syntax error
%pure_parser/* We have threads */
^
gmake[2]: *** [sql_yacc.cc] Error 1
gmake[2]: Leaving directory `/usr/local/src/mysql-4.0/sql'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/usr/local/src/mysql-4.0'
gmake: *** [all-recursive-am] Error 2

-
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: simultaneous connections

2001-05-11 Thread John Barton

Mysql allows 101 connections by default, 100 client connections plut it
reserves one for administrator access. You can set your own maximum
connection limit in the my.cnf file by using the directive:

[mysqld]
set-variable = max_connections=

where xxx is the amount you want to set as the max. See the documentation
for information and recommendations on what to set the max as for your
particular OS.

John Barton
System Administrator
Mpower Communications
[EMAIL PROTECTED]


- Original Message -
From: Don Pro [EMAIL PROTECTED]
To: msql list [EMAIL PROTECTED]
Sent: Friday, May 11, 2001 2:37 PM
Subject: simultaneous connections


 Hi,

 I'm reading in my documentation (I have a book) that MySQL allows up to
 101 simultaneous connections.  Gadzooks!  How can MySQL claim to be at
 the Enterprise level with this limit?  Is there any way around this?

 Thanks,
 Don


 -
 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 variable for max_connections

2001-05-10 Thread John Barton

Try putting a line like the following in your my.cnf file:
This has always worked for me, including 3.23.37

set-variable = max_connections=

John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]

On Thu, 10 May 2001, Mark Lo (3) wrote:

 Hi,

  I would like to set a higher values in max_connections for mysql.

 I have tried to use the following command mysqld --set-variables
 max_connections=900 -u root -ppassword.  Then, it shows that I have
 successfully changed the variable of max_connections.  But, when I check it
 with the command of mysqladmin variables -u root -ppassword.  The
 max_connections return to 100 which is the default value.  I wonder what is
 wrong with mysql3.23.37.  Is this a bug, or I am using the wrong command.

 In additions, Can I set the max_connections values higher than 5000.

 Thank you

 Mark


 -
 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: Correct syntax?

2001-04-19 Thread John Barton

"select word, count(word) as total from search_words where word IS
NOT NULL group by word order by total desc limit 20"

John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]

On Thu, 19 Apr 2001, Graham Nichols wrote:

 Thanks for help from this group I'm using

 "select word, count(word) as total from search_words group by word order by
 total
 desc limit 20"

 to locate the top 20 words in a database of website search engine words.

 The database had been altered to include an extra column, other than the
 'word' column. This means that 'word' can now have a null entry sometimes.
 How can I modify the sql query above to exclude any row(s) in 'word' with
 'NULL' please?

 regards, Graham
 l


 -
 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: BEGIN, COMMIT, ROLLBACK

2001-04-10 Thread John Barton

You are using MyISAM tables which do not support transactions. You need to
convert your table to either BDB or INNOBASE type in order to use
transactions. All the info is in the manual..

John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]

On Tue, 10 Apr 2001, Bruno Roselli wrote:

 Hi. How to use Begin, Commit and Rollback in my tables type MyISAM ?

 mysql BEGIN;
 Query OK, 0 rows affected (0.00 sec)

 mysql UPDATE tabgral set codigo=2 where codigo=1 and nrotab=99;
 Query OK, 1 row affected (0.00 sec)
 Rows matched: 1  Changed: 1  Warnings: 0

 mysql ROLLBACK;
 ERROR 1196: Warning:  Some non-transactional changed tables couldn't be
 rolled back

 show table status like 'tabgral';
 +-+++--++-+-
 
 +--+---++-+-
 
 +++-+
 | Name| Type   | Row_format | Rows | Avg_row_length | Data_length |
 Max_data
 _length | Index_length | Data_free | Auto_increment | Create_time |
 Upda
 te_time | Check_time | Create_options | Comment |
 +-+++--++-+-
 
 +--+---++-+-
 
 +++-+
 | tabgral | MyISAM | Dynamic|  280 | 45 |   12872 |
 429
 4967295 | 7168 | 0 |   NULL | 2001-04-10 09:17:45 |
 2001
 -04-10 12:58:11 | NULL   || |
 +-+++--++-+-
 
 +--+---++-+-
 
 +++-+




 -
 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: show databases forbidden or limited to the owner database

2001-04-09 Thread John Barton

Try putting a line in your my.cnf that contains:
safe-show-database
This will only allow the user to see databases that they have permissions
for
You can optionally use skip-show-database, which will not allow the
command at all.

John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]

On Mon, 9 Apr 2001, Fabien Salvi wrote:

 Hello, is it possible to prevent users from seing other databases than
 the one there are using ?

 I thought it was possible using priveleges and "Select_priv", but It
 doesn't work...
 I am using 3.23.33

 Thanks in advance for your help...

 -
 Fabien SALVI  Centre de Ressources Informatiques
   Archamps, France -- http://www.cri74.org
   PingOO GNU/linux distribution : http://www.pingoo.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



-
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: Moving Data

2001-04-09 Thread John Barton

It depends on what version of MySQL you are running. MyISAM tables will
move across platforms fine, but ISAM tables will not. You could always
choose the failsafe and use mysqldump to dump the contents of your
database into a file, and then use that to reload the contents on the new
machine.

John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]

On Mon, 9 Apr 2001, Mat Murdock wrote:

 We will be moving our MySql databases from a Winnt server to a linux server.  Can I 
just copy the data files from one machine to the other?  If not then how should I do 
it?

 Mat Murdock

 
 Your mouse has moved. Windows must be restarted for the change to take
 effect. Reboot now? [ OK ]



-
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: backup mysql using crontab

2001-04-02 Thread John Barton

mysqldump --flush-logs -u root -pmarkloky --add-drop-table shuncheong 
/backup/shuncheong.sql

You have to put username and password as an argument to mysqldump, before
your redirection

John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]

On Tue, 3 Apr 2001, Mark Lo (3) wrote:

 Hi,

I would like to know how to backup mysql using crontab or cron jog.

 I have add a line in my crontab file :
 mysqldump --flush-logs --add-drop-table shuncheong 
 /backup/shuncheong.sql -u root -pmarkloky;

 but I got nothing in  shuncheong.sql file.

 Thank you for your help

 Mark Lo


 -
 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: Password option

2001-03-21 Thread John Barton

Restart mysqld with the --skip-grant-tables option, this will allow you to
bypass mysql's authentication. You can log in as root and then change the
password to something else.

John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]

On Wed, 21 Mar 2001, Jared Rogge wrote:

 I have recently tried to install a new Trouble Ticket application on a Unix
 machine that was previously administered by somebody else. They have set a
 password to MySQL and I cannot into it of course. Does anybody know how to
 reset or disable this feature if you have root access to the machine?

 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: MySql backup and restore.

2001-03-20 Thread John Barton

You dont need a script or command to restore the database, mysqlhotcopy
just creates a copy of your database files (.MYI, etc.) in the
/pathToTheBackupDirectory/. It basicaly performs the same function as the
unix command cp, only it does the necessary locking, etc.

John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]

On Tue, 20 Mar 2001, Zhu George-CZZ010 wrote:

 Hi,

 If I use "mysqlhotcopy   database/pathToTheBackupDirectory/" to backup the 
whole database, what's the script/command to restore it?
 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: What is best way to check mysql status?

2001-03-20 Thread John Barton

You should look up mysqladmin in the manual. It depends on what you want
to know. mysqladmin ping will tell you if the server is alive or not, or
you can use mysqladmin status to get a brief stat report about the server.

John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]

On 21 Mar 2001, Jose de Leon wrote:

 I have found at least three ways to check up/down status of MySQL.  I am
 wondering what is considered the most reliable method, please comment
 and add if you have another method.

 1. Check for existence of PID file created by MySQL
 2. Check for existence of mysql.sock
 3. Verify connection via telnet to port 3306.

 Thank you,
 Jose de Leon



 -
 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: Weird select with php

2001-03-07 Thread John Barton


SELECT * FROM members where name like 'A%' ORDER BY RAND();

John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]

On Tue, 6 Mar 2001, Matt "TrollBoy" Wiseman wrote:

 I'm attempting to do a select from my table, but the only odd thing is the
 customer wants the results to be completely random every time...
 
 is there anything like this??
   $query = "SELECT * FROM members where Name like 'A%' ORDER BY random";
 
 
 
 Matt "Trollboy" Wiseman
 www.shoggoth.net/trollboy/trollboy.jpg
 [EMAIL PROTECTED]
 "I wish the world had one throat!!"
 -Al Bundy
 
 
 -
 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