Here's a good one:
http://www.xmbforum.com/
-Original Message-
From: Javier Gloria [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 11:27 AM
To: mysql
Subject: mysql forum
Hi everybody:
where i can find a forum than works with php,mysql. for my site. or the
source code for
Try:
mysql -e SELECT user FROM mysql.user
You may need to add the following as well
mysql -h hostname -uyouruserid -pyourpassword -e SELECT user FROM
mysql.user
-Original Message-
From: Mike Yrabedra [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 6:55 AM
To: [EMAIL
I've tried the select round(1.5) on:
Linux RH7 w/3.23.47
Answer: 2
Solaris 7 w/3.23.38
Answer: 2
Linux Debian w/3.23.38
Answer: 2
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
If you need to, use the kill -9 pid
-9 is a definite kill and it will work
-Original Message-
From: JP Audette [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 2:52 PM
To: [EMAIL PROTECTED]
Subject: having trouble killing mysqld to restart and change root
password
Howdy,
I read an article from the developers of amihotornot.com that states that
MySql on Linux (single processor 700Mhz PIII) outperforms Solaris (quad
processors)
Is this because it was developed on Linux? Is it true?
http://www.webtechniques.com/archives/2001/05/hong/
Gary Every
UNIX
It looks like you may need to run the mysql_install_db if you haven't done
so.
-Original Message-
From: Shinta H Leagazpi [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 7:03 AM
To: [EMAIL PROTECTED]
Subject: help in running mysql on slak8...
Goodday, I have been able to
You can set your max_connections variable thusly:
mysqld -O max_connections=1000
(That's an upper-case letter O and the above needs to be appended to the
other options that start mysqld
-Original Message-
From: Mitch Fournier [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002
The file in the /etc/rc.d/init.d is likely called S95mysql, and you CAN add
that parameter to that file. You'll need to edit the file, and add something
like this:
/opt/mysql/bin/mysqld \
--basedir=opt/mysql \
...
--skip-grant-tables \
...
/var/log/mysql/mysql.err 21
The ...'s above are other
What operating system are you using?
The path vars etc are found in your mysqld_safe or safe_mysqld script, at
least in *NIX systems
-Original Message-
From: Roman Eisner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 6:06 PM
To: [EMAIL PROTECTED]
Subject: Path Variables
You might want to increase your max_connections using :
-O max_connections=1000
as an option in mysqld_safe. See
http://www.mysql.com/doc/S/e/Server_parameters.html
for more information.
-Original Message-
From: Müller, Markus [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002
You need to take a look at the database called mysql.
In it you have:
culumns_priv
db
func
host
tables_priv
user
as tables.
Use the GRANT command to set the USERS, or you can also do an insert
statement like so:
insert into mysql.tables_priv VALUES
In your select statement, use the LIMIT option
SELECT * FROM table limit 10;
will return the first ten rows, or
SELECT * FROM table limit 100,10
will return rows 101-110
-Original Message-
From: Bret Ewin [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 4:47 PM
To: [EMAIL
show processlist;
-Original Message-
From: Satish Santhakumar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 3:46 PM
To: [EMAIL PROTECTED]
Subject: Process List
Guys,
I am new to MySQL. How do I list the running
processes?? Help!!
=
The only person in the world who
database,sql,query,table
I noticed that one of my servers had the wrong time set. It's a debian box
using 3.23.37. I changed the system time successfully, but the NOW()
function is still showing the old time. Looking through the docs, I found
the
SET TIMESTAMP= function and it said that I
from your bindir type:
./mysql
-Original Message-
From: Cindy Yu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 12:07 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: RE: RE: Mysql connection problem
Hi Simon,
I appreicate
I use a simple script that does the following:
--- snip ---
mysql -e SELECT * from table_name limit 1 db 2/tmp/filename
x=`cat /tmp/filename`
if [ $x = ]
then
do_nothing=1
else
## There's an issue!
echo ERROR!
fi
--- end snip ---
Using the re-direct of stderr is the key. the 2/tmp/filename
You can use count(*) as only one of the selects
SELECT count(*), usernames.user, usernames.pass FROM usernames where
condition=TRUE
-Original Message-
From: Boex,Matthew W. [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 3:35 PM
To: 'Rick Emery'; [EMAIL PROTECTED]
Subject: RE:
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
Try this:
echo REPLACE INTO table_name (dr) VALUES ('0'); |
/usr/local/mysql/bin/mysql -u user -p password activity
or mysql -e REPLACE INTO table_name (dr) VALUES ('0'); activity
-Original Message-
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 10:57 AM
Unless he's got a recent backup he's USCWAP
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 1:04 PM
To: [EMAIL PROTECTED]
Subject: Big Problem...Need Help Quick
I apologize for cross post; however this poster is not on MYSQL list and he
20 matches
Mail list logo