Simon Windsor wrote:
Hi
The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36,
the standard RedHat version.
The machine is running two databases, one is a full archive while the other
ones holds current data. The same five records are unavailable using SQL in
the
(Sorry for the double email Simon, forgot to
switch the email to text...)
Simon Windsor wrote:
Hi
The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36,
the standard RedHat version.
The machine is running two databases, one is a full archive while the other
ones
[EMAIL PROTECTED] wrote:
I changed the script and now all is well. However I have two concerns:
1) Paranoid about the password being in this script. Is there a way around this.
chown root:root /etc/rc.d/init.d/mysqld
chmod go-rx /etc/rc.d/init.d/mysqld
Just to be clear, if the
Peter Lovatt [mailto:[EMAIL PROTECTED]] wrote:
This is not really a problem for me now, because I have my own server,
and control who has access. This is a problem on virtual hosting,
because anybody could be on there.
You are exactly correct. This problem is huge on virtual hosting
accounts,
[EMAIL PROTECTED] wrote:
I'm switching over to a bigger better faster server. My old server is running
version 3.23.22-6 mysql on RH and I need to move all the db's to my new box
using 3.23.41 installed on RH7.2. So do I just simply move all of the db
directories from /var/lib/mysql from one
Hi
The safest way to do this is to use mysqldump utility.
mysqldump -u [username] -p dbname /path/to/dumpfile
and then
mysql -u [username] -p dbname /path/to/dumpfile
Regards
Daniel £a
e-direct Polska sp. z o.o.
WWW: http://www.e-direct.pl
E-mail:
Wells, Kenneth L wrote:
Please help
I'm at the end of my rope...
I just ran a script to create databases in my SQl server, it runs fine
When it completes it says remember to set a password for the mysql root
user!
I entered this?
/usr/local/mysql/bin/mysqladmin -u root -p
In the last episode (Nov 12), Michael Kedl said:
Dan Nelson wrote:
In the last episode (Nov 12), Michael Kedl said:
Looking thru the MYSQL archives I see a few people had interest
in a natural sort method to sort text fields containing
numbers. I to would like this feature. Has
Sorry, for some reason, the select statement was cut off. Here is the
complete statement (below):
Thanks,
Brad
I'm trying to write a select statement that produces a SUB COUNT of column
PORT_STATUS where (A) PORT_STATUS = 'up' and (B) PORT_STATUS = 'down'. I'd
like to do this in one statment
Christopher Book wrote:
No, I'm not using mysql_pconnect, and my apache configuration seems fine. I
don't have very many users at the moment so there is no reason for the
connections filling up.
This can be due to your apache configuration. do you use mysql_pconnect
function in php.
I asked before, but got no answer, so I ask again, but refrase myself a
little
Is it possible in myslq to do an order by before an group by?
as far as I know, the order by will happen after the group by, and sort all
the grouped rows(I assume that when grouping it just takes the first found
On Mon, Nov 12, 2001 at 07:18:53AM -0600, Rick Emery wrote:
Jeremy,
I was just cruising amazon.com for MYSQL books and I noted you have
a MYSQL book due-out in January. Will it cover version 4.0? Since
mySQL vers 4.1 is due out soon, do you intend to await the book's
release to cover the
You mentioned this solved the problem when using pconnect. I'm using
connect, not pconnect so will this still work?
Will using pconnect instead of connect do anything for me? Basically
everything runs properly but then every once and a while I get a ton of
processes that get stuck and send the
Hello All,
I recently installed MySQL 3.23.44 from source with no problems and all seems to
be working fine. From the docs, it recommends gcc 2.95, and our server has gcc
2.91, server specs:
Red Hat Linux release 6.2 (Zoot)
Kernel 2.4.10 on an i686
gcc version egcs-2.91.66 19990314/Linux
Dear Sirs,
My MySQL is not configured properly...
I can connect using localhost with -h flag , but when I'm using IP
instead of hostname it doesn't connects at all...
What'd I do?
Thank you.
-
Before posting, please check:
Hello,
I have some fulltext search queries that seem to be hanging my database.
They're supposed to search a large text database, but every once and a while
one doesn't come back and it brings the whole system down with it. My CPU
load isn't very high, but my processlist is full (300) and mysql
The MySQL manual
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#MySQL_indexes
states All MySQL indexes (PRIMARY, UNIQUE, and
INDEX) are stored in B-trees. Strings are
automatically prefix- and end-space compressed..
Other RDBMSes out there state in the their
I have a linux redhat 7.2 system. I am trying to install bugzilla which
uses mysql. I have installed apache and have completed mysql
installation post tests successfully using the -p form of the commands.
However, I never succeeded in getting
mysql -u root -h 192.168.1.15 -p password
Hi,
I just updated a new database with the update log from another server, and
the script failed on the LOAD DATA INFILE commands that I have to import
data overnight from other sources, because, of course, those files didn't
exist.
Now, I know I can use --force to allow the script to complete,
Hi Tim,
- Original Message -
From: Tim Hewitt [EMAIL PROTECTED]
It would be nice if mySQL supported some form of encrypted
login where the username and password could be decrypted
internally somehow.
Security through obscurity isn't REALLY safe. It just hides it a bit.
Anyone could
Check your users and db table at mysql database
probably the problem comes from there
On Tuesday 13 November 2001 02:47 pm, Alex wrote:
Dear Sirs,
My MySQL is not configured properly...
I can connect using localhost with -h flag , but when I'm using IP
instead of hostname it doesn't
Hello,
Despite hours plumbing the MySQL documentation and Paul DuBois' book
MySQL (New Riders), I can't figure out what exactly creates the Unix
socket for local connections. For some reason no socket was created
during my setup, and I'm not sure how to go about making one.
I compiled 3.23.44
Erik Price wrote:
Hello,
Despite hours plumbing the MySQL documentation and Paul DuBois' book
MySQL (New Riders), I can't figure out what exactly creates the Unix
socket for local connections. For some reason no socket was created
during my setup, and I'm not sure how to go about making
Hello
I forward this bug report to this list as it seems to be not
Debian specific. MySQL crashes with several kinds of
/etc/nsswitch.conf configurations.
bye,
-christian-
On Tue, Nov 13, 2001 at 11:45:27AM +1100, Brian May wrote:
Christian == Christian Hammers [EMAIL PROTECTED] writes:
I've been a fool. I didn't realize that I had to use the following
option when starting up the mysql daemon:
--socket=/usr/local/mysql/run/mysql_socket
I suppose that my instructions might have left this out. Normally the
socket is created in /tmp (absolute pathname) right? But when I
Tim Hewitt wrote:
Arjen G. Lentz [mailto:[EMAIL PROTECTED]] wrote:
Hi Tim,
- Original Message -
From: Tim Hewitt [EMAIL PROTECTED]
It would be nice if mySQL supported some form of encrypted login
where
the username and password could be decrypted internally somehow.
I couldn't find an explanation of this behavior in the docs. When I
use the following CREATE command:
CREATE TABLE D6 (id int(10) not null unique);
it appears to automatically create an index for me:
mysql SHOW INDEX FROM D6;
+---++--+--+-+...
|
Quoting Steve Fink ([EMAIL PROTECTED]):
I couldn't find an explanation of this behavior in the docs. When I
use the following CREATE command:
CREATE TABLE D6 (id int(10) not null unique);
it appears to automatically create an index for me:
Argh! Never mind. Learn something new every day
Hi Steve,
- Original Message -
From: Steve Fink [EMAIL PROTECTED]
I couldn't find an explanation of this behavior in the docs. When I
use the following CREATE command:
CREATE TABLE D6 (id int(10) not null unique);
it appears to automatically create an index for me:
Argh!
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Please read mysql manual, your question covered by manual.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Ady Wicaksono([EMAIL
you can also use
mysqladmin shutdown
Deepanshu
- Nguyen Trong Phuc [EMAIL PROTECTED] wrote:
i don't use linuxconf.
if u want to stop mysql, execute :
/ect/init.d/mysql stop
easiest :)
Trong Phuc
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Hi Phuc,
I work around the problem and I fix the problem without the submit()
function.
It will dynamic update content in room by sending the sql_query to
server and get
info back.
thank for your response.
Nguyen Trong Phuc wrote:
i think that u can't, b/c php is server side while JS is
On Thu, Nov 08, 2001 at 05:27:41PM +0200, indrek siitan wrote:
Hi,
I just noticed that at least 2 pages in the online MySQL docs
definitely have the associated user comments a little askew.
I thought I'd mention it here while I was thinking of it.
Apologies if not the correct
Hi there. Can anyone offer a solution to this problem.
CREATE TABLE `raw` (
`cid` int(11) default NULL,
`agent` char(255) default NULL,
`referer` char(255) default NULL,
`addr` char(15) default NULL,
`via` char(255) default NULL,
`forward` char(15) default NULL,
`ctime` datetime
Say I have two running programs and both of them periodically want to
increment a value in a database. How can I do this so that the increments
will be performed correctly even if the two programs try to do them at the
same time?
If I have code like this:
$x =
On Mon, Nov 12, 2001 at 10:52:39PM -0800, Bennett Haselton wrote:
Say I have two running programs and both of them periodically want to
increment a value in a database. How can I do this so that the increments
will be performed correctly even if the two programs try to do them at the
same
Hi there,
I made a mySQL database with uppercase table names on a linux platform. I
migrated it, for maintenance reasons, on a win2000 platform. Now when I try
to put everything back I discovered that mySQL on win2000 changed my table
names to lowercase.
For java this is not a problem on the
I hit a situation just now where a select using the 'regexp' operator
would have been a tidy solution if mysql used indexes. I wasn't sure if
this optimisation had been implemented, so I investigated and found that
indexes are not used. The case where this is possible is relatively
simple to
Hello,
I need to create a search engine out of a few MySQL tables I should
say: I need to search MySQL records like a search engin might. However, my
first go ended up as a complete failure because it is highly un-optimized to
search for (as an example) %apple% in all of the available
Hello,
Can someone explain hash tables or hash indexes and if we can take advantage
of them in MySQL?
Thanks!
Karl
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
101 - 141 of 141 matches
Mail list logo