Wyatt James wrote:
I am getting a misleading error message saying "duplicate key 127 at key 1" when
trying to add an item to a table. There is no duplicate (I downloaded then uploaded
to a new table and get the same error). The unique key is a smallint(4) with
auto-increment. Is there some
David Vender wrote:
Hi
I am running RedHat 6.2 and notice that there
are serious problems running MySQL on it. There
are lots of posts on the email lists about the
the installation hanging at 'Installing all prepared tables'. Users
normally manage to do one install,
the db runs for a
"Bass, Benjamin" wrote:
Hi all.
I have a problem with one of my tables. I can get a count of records, or
simple selects, but if I go any more complex, I get an error "ERROR 1030:
Got error 127 from table handler". I can't seem to find any documentation
that further explains these types
Leonardo Dias wrote:
"Mayville, Jeffrey" wrote:
I keep seeing users asking about a problem they are having with replication
(I ran into the bug myself). I saw a message a week or so ago acknowledging
the bug and noting that it was self-inflicted (while cleaning up code) and
has been
clay bond wrote:
I just installed mysql 3.23.32 on my server and it
went without a hitch. I ran mysql_install_db, changed
the root password, started the server. I used GRANT
statements to create another user, then connected
as that user to the mysql client--no problem at all,
ran queries,
You should have run install_db --user=mysql
Is the mysql directory in /dbshare owned by mysql ?
Are the permissions 775 ?
Does mysql own the files in /dbshare/mysql ?
kentj wrote:
dbshare is owned by mysql with group deamon
and I have run install_db
"Gerald L. Clark" wrote:
You state that the temporary files are on a separate partition.
Does the filesystem on this partition support large files?
Chris Black wrote:
I am running MySQL 3.23.32 on Linux 2.2.16 with large file support. Large
tables (tens of GB) work fine. mysqladmin variables shows large file
If you are installing from a binary release that you created, and need
to fix
save_mysqld after each installation, then you should complain to the
person that
created the binary release.
Or did I miss something?
Quentin Bennett wrote:
Hi,
Each time I install mysql from a binary release
1. Start the mysqld.
2. Make sure it is opening the socket in /var/lin/mysql
3. Make sure /var/lin/mysql is set mode 775
Balaji Nallathambi wrote:
Iam Getting the error
"Unable to Connect to Local MySql Server through socket 'var/lin/mysql/
mysql.sock"
my Version For MySql is 3.22.32.
It is in the manual.
Approximately ( Don;t have manual in front of me ):
insert into deleted_users select from active_users where user_name =
"joe_smith";
delete from active_users where user_name = "joe_smith";
Aaron Williams wrote:
Hello list,
After searching the documentation on the
Remco van den Berg wrote:
On Wed, Jan 31, 2001 at 08:00:23AM -0600, The Tilghman wrote:
Try sorting in DESCending order.
SELECT * FROM item ORDER BY id DESC LIMIT 10;
-Tilghman
People,
Thanks for all the answers, but the question was:
"How to get the last 10 items in
"Jesse E. Stay II" wrote:
I seem to have run into a problem lately where all of the sudden my
server keeps giving me "too many connections" errors, locking anyone out
of the site. I have set max_connections to 210, which shouldn't matter
anyway because we haven't had any more users than
Marcelo wrote:
Can someone tell me how i can get(or
can someone send me) the strip command
for SCO Open Server 5.0.5?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
"Guridi, Tomas" wrote:
Hi , im having a strange problem with the update in mysql
i have a table named "notices" with the following fields:
id :prymary, int, auto_increment.
title :varchar (255).
priority:int.
inside this table i have 5 registers like this :
id
Do it the other way around.
If insert fails, do the update.
Udate may fail, and before you insert, another tread could do the
insert.
Now your insert would fail, and your data would be lost.
Pl Wester wrote:
Why not do an update regardless if the record exist or not,
then insert it if you
[EMAIL PROTECTED] wrote:
Hi,
Sorry for the possible offtopic question I'm going to ask.
I have got something similar (this is very simplicated situation of
my problem but this is the core of my headache):
CREATE TABLE cityname (
id BIGINT NOT NULL AUTO_INCREMENT,
lkeeton wrote:
I am very frusturated as of right now. I have a mysql database that doesn't
work on Cobalt Raq3. I installed the RPM version and guess what the mysql.sock
file isn't there and ther server gives me this error when starting:
Starting mysqld daemon with databases from
Christian Przybilla wrote:
Dear Ladys and Gentleman,
i do install packages MySQL-client-3.23.32-1.i386.rpm,
MySQL-3.23.32-1.i386.rpm and MySQL-devel-3.23.32-1.i386.rpm with yast on
Linux 6.3 - OS.
When i started mysql with "save_mysqld i receved follow messages:
mysql started
Can't
Andrei Zmievski wrote:
On Tue, 23 Jan 2001, Gerald L. Clark wrote:
Why isn't it using index on the last query?
Because there isn't an index that contains both fields.
So it can't use separate indexes?
I guess the obvious solution would be to create an index on both of
those
Amiph wrote:
Hi !
Ok. I've made correctly replication with two servers in a two-way replication. Both
servers are master/slave. But I would like to know if is it possible to make three
servers to replicate and receive the updates from each others like this:
a sends updates to b and c
Laurie Savage wrote:
I am unable to connect to MySQL either as root or user unless I issue a
"mysqld --socket=/var/lib/mysql/mysql.sock - u root" command. This is good
for all users as long as the machine is booted.
I have checked Ksysv and mysql is enabled at startup.
I have
Don wrote:
Hi,
I'm using Perl to maintain a database. I'd like to search for a record
in a database and if it does not exist, add it. Otherwise, just update
the fields. In my script, I have:
$sqlCmd = $dbh-prepare("SELECT PortName FROM Ports where PortName =
'$port' ");
[EMAIL PROTECTED] wrote:
The grant was done by:
# echo "grant INSERT,SELECT on snort.* to
snortdb@'XXX.XXX.0.0/255.255.0.0';" | mysql -u root -p
The system has TCP wrappers setup and the hosts.allow file is empty and
hosts.deny is set to ALL:ALL. next time I'm at work I'll try putting
Stuart Fox wrote:
Hi
Can anybody tell me what this error means
user@server#isamckh -av {database}/*.ISM
isamchk: error: 22 when opening ISAM-table '{database}/tax.ISM'(all
tables)
If this was part of a script, then database was a variable that
contained the full
path to the
Do you hae the line
127.0.0.1 localhost.mydomain localhost
in your /etc/hosts file?
It sounds like your resolver is not working.
[EMAIL PROTECTED] wrote:
Doing that was just a test, and I didn't think it would work since Inetd is
not running on the box at all. In fact the only way
Don wrote:
Prior to updating, I want to search the table to see if my Key exists.
That way, I can add it or just update the associated fields. How do I
tell my script which Index file to use? I can't seem to find the
equivalent of the dBase style "Set Order to".
Errr... If I
Lonnie Cumberland wrote:
Hello All,
I have noticed that the Encrypt() is a oneway function that will also give
different resulting messages for the same message being encrypted multiple
times.
I have also noticed that the Encode() will result in a message that is a binary
type.
Michael Griffith wrote:
Earlier I posted a message about SHOW PROCESSLIST reporting queries "locked"
whenever another thread is "Copying to tmp table"
After many more hours of diagnosis, the actual problem is somewhat different:
MySQL does report other processes as locked. But they do
Valgard Blondal wrote:
Hi,
I was wandering if someone could help on this.
I am using mysql with php3 on a shared server, version 3.22.32
I had been running this for few days without any problems, but
when about 100 users were in to the database, the sign up form
at
Fai wrote:
According to MySQL rule, the column matching order in mysql database should be as
following:
++-+-
| Host | user|
++ +-
|localhost| |root ||localhost| | ||pit.sample.com |root
Oliver Hinds wrote:
Has anyone experienced problems using DBI and perl with update statements
not updating tables when the equivalent statement at the command line
works, and all other operations work perfectly?
Oliver Hinds
Only when I make the wrong assumption about what perl is
Oliver Hinds wrote:
On Thu, 18 Jan 2001, Gerald L. Clark wrote:
Oliver Hinds wrote:
Has anyone experienced problems using DBI and perl with update statements
not updating tables when the equivalent statement at the command line
works, and all other operations work perfectly
Luke Andrew Cassady-Dorion wrote:
i've been running mysql on a redhat linux machine for about two months w/o
need for a restart. unfortunately this morning, the machine started acting
really odd and i decided to perform a restart. when restarting, the system
actually froze and i was forced
[EMAIL PROTECTED] wrote:
Hi all,
I tried to unzip and untar the MySQL source file mysql-3.23.30-gamma.tar.gz with the
following command
gunzip -dc mysql-3.23.30-gamma.tar.gz | gtar vxf -
But I got the following erroe message, what i can do to solve it? Thanks
choi
Error
Rick Pasotto wrote:
On Mon, Jan 15, 2001 at 10:39:15AM -0600, Gerald L. Clark wrote:
Rick Pasotto wrote:
SELECT concat(last_name,", ",first_name) as name from members
results in a column that is much wider than necessary. Adding trim() to
the concat() nor to the
201 - 235 of 235 matches
Mail list logo