Re: alter table example.

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

RE: SSH tunnel MySQL traffic: BOTH remote local?

/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

Re: SSL connection question Again!

: 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

Re: ALTER Syntax Question

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

Re: Connection problem

-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

Mysql 4.0 bitkeeper source fails to compile

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:

Re: simultaneous connections

. 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

Re: set variable for max_connections

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

Re: Correct syntax?

"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

Re: BEGIN, COMMIT, ROLLBACK

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

Re: show databases forbidden or limited to the owner database

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

Re: Moving Data

. 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

Re: backup mysql using crontab

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

Re: Password option

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

Re: MySql backup and restore.

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

Re: What is best way to check mysql status?

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

Re: Weird select with php

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 cust