o
> 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
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 B
; 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]
---
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;
>
> T
-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
>Description:
Mysql 4.0 bitkeeper fails to compile
>How-To-Repeat:
Try to compile
>Fix:
Fails with a syntax error
>Submitter-Id:
>Originator:John
>Organization:
>MySQL support: none
>Synopsis: Mysql 4.0 bitkeeper fails to compile
>Severity: non-critical
>
trying to do, and it takes care of the necessary locking, flushing, etc.
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]
On Tue, 19 Jun 2001, Tom Lin, Sr. Programmer, Ameriserv.net wrote:
> I copy the 3 MYD MYI frm of a database to another directory as a way of bac
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
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 w
"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 gr
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
.
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 d
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
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
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
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
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
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
I have also encountered this problem when upgrading master and slave from
3.23.31 to 32.23.32. The upgrade of the master went fine, and both servers
remained in sync throughout the process. However, when I upgraded the
slave and restarted, it gave the same error that it could not find first
log. T
19 matches
Mail list logo
