Hi Jake, all,
please note that the following remarks are about communicating via named
pipes in general, not specific for MySQL.
I do _not_ comment whether the idea is good or bad, will work,
alternatives, ...
Jake Peavy wrote:
Hey, I sent this a while ago, but never received a response.
Hi all, Peter!
Sujay Koduri wrote:
You havent specified the datatype for the column 'id'.
Right, this should be fatal.
But I also take issue with other parts:
[[...]]
-Original Message-
From: Peter Matulis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 15, 2005 10:57 AM
I used snort and acid but that go me nowhere
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Monday, November 14, 2005 11:18 PM
To: mysql@lists.mysql.com; Ed Kasky
Subject: Re: Anyone use Snort and Acid?
. . . . . . . . . . . . . . . . . .
Randomly Generated Quote (125
In article [EMAIL PROTECTED],
Joerg Bruehe [EMAIL PROTECTED] writes:
CREATE TABLE users (
id PRIMARY KEY,
priority integer NOT NULL DEFAULT '7',
policy_id integer unsigned NOT NULL DEFAULT '1',
Even though this may work, it is wrong IMNSHO:
You set character strings as default values for
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
Joerg Bruehe [EMAIL PROTECTED] writes:
CREATE TABLE users (
id PRIMARY KEY,
priority integer NOT NULL DEFAULT '7',
policy_id integer unsigned NOT NULL DEFAULT '1',
Even though this may work, it is wrong IMNSHO:
You set character strings as
Ok, I found this one too. It was my own client, and of course, the
problem was on my side of things. I want to thank everyone who replied.
What was happening was I was trying to free the mysql structure and it
was already freed.
On Nov 14, 2005, at 6:50 PM, Gleb Paharenko wrote:
Hello.
We are making whole database sql dump every night.
Now I have a bunch of sql dumps, that covers much space.
Is there opensource tools with whom I could make one
smaller differencial backup file with possibility to
get dump from every signle day?
Any ideas?:)
Thankyou!
Aktvists
Hi.
We have a MySQLd with both MyISAM and InnoDB tables that at uneven
intervals stops responding correctly to connections.
At all times, about one connection per minut fails, regardless of
which database and/or user and/or remote host is connecting. The same
connection parameters (and
hi all..
i have created a table (INNODB) with a primary key column.
And all the queries i am running are of the following type only.
select col1,col2... from table where primary_key_col = value
My question here is will mysql automatically create an index on this column
which is having the
Hello!
I run a picture-database (http://gissmoh.kicks-ass.net) on Ubuntu
Breezy on an old machine:
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 7
model name : Pentium III (Katmai)
stepping: 3
cpu MHz : 501.226
cache size :
Am Dienstag, 15. November 2005 13:29 schrieb Jochen Kächelin:
Ups!!
Wrong link!
The right one: http://gissmoh.kicks-ass.net:81
--
Jochen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2005/11/14, [EMAIL PROTECTED] [EMAIL PROTECTED]:
We are making whole database sql dump every night.
Now I have a bunch of sql dumps, that covers much space.
Is there opensource tools with whom I could make one
smaller differencial backup file with possibility to
get dump from every signle
Yes, MySQL will create an index on the field you specify as the
primary key. Instead of using show table status, use desc
tablename. That will show you which fields have indexes on them. The
field with the primary key index will have a PRI in the key column.
Indexes will always increase
Sujay Koduri [EMAIL PROTECTED] wrote on 11/15/2005 06:47:43 AM:
hi all..
i have created a table (INNODB) with a primary key column.
And all the queries i am running are of the following type only.
select col1,col2... from table where primary_key_col = value
My question here is will
On Mon, 14 Nov 2005, [EMAIL PROTECTED] wrote:
We are making whole database sql dump every night.
Now I have a bunch of sql dumps, that covers much space.
Is there opensource tools with whom I could make one
smaller differencial backup file with possibility to
get dump from every signle
Jochen Kächelin [EMAIL PROTECTED] wrote on 11/15/2005 07:46:13 AM:
Am Dienstag, 15. November 2005 13:29 schrieb Jochen Kächelin:
Ups!!
Wrong link!
The right one: http://gissmoh.kicks-ass.net:81
--
Jochen
Hardware recommendations:
Add as much RAM as possible and if you can, swap
I would like to change one of my tables so that future inserts use a
higher range of numbers for the primary key values.
I have a table 'event' with column:
id int unsigned not null auto_increment primary key
Currently new records are going into the table with id column values
in the
I think you want that:
When you add an AUTO_INCREMENT column, column values are filled in with
sequence numbers for you automatically. For MyISAM tables, you can set the
first sequence number by executing SET INSERT_ID=value before ALTER TABLE or
by using the AUTO_INCREMENT=value table
Björn Persson wrote:
Noel Stratton:
As you can see the summary total in the 'Total' column is incorrect. The
summary total should be 36 but is spitting out 40. I am not even sure
where it is getting 40. The only way to get 40 is if it is multiplying
5X8.
Isn't that what you told it to do?
I would expect this to finally be something on the client end,
rather than the server end... is there a search index that gets
rebuilt periodically? Maybe some reports that get generated against
the data? The last example that comes to my mind is if you use a
client that caches data, does
--- Joerg Bruehe [EMAIL PROTECTED] wrote:
Sujay Koduri wrote:
You havent specified the datatype for the column 'id'.
Right, this should be fatal.
But I also take issue with other parts:
CREATE TABLE users (
id PRIMARY KEY,
priority integer NOT NULL DEFAULT '7',
mel list_php wrote:
From: Dan Buettner [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Changing range of identity column for future inserts
Date: Tue, 15 Nov 2005 08:50:03 -0600
I would like to change one of my tables so that future inserts use a
higher range of numbers for the primary
Hello everyone,
I have changed a value of max_allowed_packet in my.cnf.
Do I need to restart MySQL itself for the change to take place or is
there a way to refresh this variable (parameter) without restart of
MySQL?
I have looked through documentation and www.mysql.com and could not find
Yes, I saw that tried it, but turned out I was just doing it wrong.
I had an errant SET in my statement. What works is:
ALTER TABLE event AUTO_INCREMENT = 1300
Thanks
Dan
At 2:59 PM + 11/15/05, mel list_php wrote:
I think you want that:
When you add an AUTO_INCREMENT column,
Hi Peter, all!
Peter Matulis wrote:
--- Joerg Bruehe [EMAIL PROTECTED] wrote:
[[...]]
CREATE TABLE users (
id PRIMARY KEY,
priority integer NOT NULL DEFAULT '7',
policy_id integer unsigned NOT NULL DEFAULT '1',
Even though this may work, it is wrong IMNSHO:
You set character strings
Yes, you can change it at runtime by doing the following
SET GLOBAL max_allowed_packet = 1024 (or whatever size);
Not only this varaible, whatever variables are listed here
http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html ,you
can change them at runtime without restarting
Hello List-people ,
I am looking to remove all non-alphanumeric characters from a column:
UPDATE
mytable
SET
mycolumn = REMOVE_NON_ALPHAS(mycolumn)
WHERE
mycolumn REGEXP '[^[:alpha:]]'
where REMOVE_NON_ALPHAS() is a fictional function.
How can I achieve this result?
Thank you Sujay and everyone else for your help
Mikhail Berman
-Original Message-
From: Sujay Koduri [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 15, 2005 11:03 AM
To: Mikhail Berman; mysql@lists.mysql.com
Subject: RE: How do I?
Yes, you can change it at runtime by doing the
Simple question:
I'd like to create a user that has all privileges for
just one database on the server.
When I try the following:
grant all privileges on my_db.* to
'myuser'@'%.mydomain.com'
identified by 'foobar';
the statement runs fine.
If I think try to connect to the server through the
question
Chris Guo wrote:
question
answer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
We are using mysql as backend database for one of the application in our
company server, and there are too many data in the Mysql database. So I
wonder how I create a database on different location.
Any help would be highly appreciated.
Chris
Tripp Bishop wrote:
Simple question:
I'd like to create a user that has all privileges for
just one database on the server.
When I try the following:
grant all privileges on my_db.* to
'myuser'@'%.mydomain.com'
identified by 'foobar';
the statement runs fine.
You can verify it worked with
Hello.
I suppose I should file a bug report then?
Could you provide a repeatable test case for you problem?
If you're using LAST_INSERT_ID() in a wrong way, that doesn't
mean that there is something wrong with MySQL.
Björn Persson wrote:
Gleb Paharenko:
So in you query both
Hey all,
I need to do some repairs on a replication master/slave and can't
remember the command to turn off bin logging on the master for a single
session.
Set session log_bin = off;
Just returns an error: ERROR 1193: Unknown system variable 'LOG_BIN'
MySQL ver 4.1.13
Thanks,
Jeff
--
I have a very simple database I am trying to backup.
I run myslqdump and it gives me the code below.
Which does nothing but cause errors when I try to run it.
Thank you in advance for your help
-Aaron
-- MySQL Administrator dump 1.4
--
--
I thought I'd found a mistake...
$sql = (select date(date) as date,
time_format(time(date),'%H:%i') as time,
units, # I forgot to include this
round(sum(item1 * units),2),
but all the numbers are correct. Does mysql know to multiply
Aaron Morris wrote:
I have a very simple database I am trying to backup.
I run myslqdump and it gives me the code below.
That is not code. It is a file of sql statements.
Which does nothing but cause errors when I try to run it.
You can't run it.
It is input for the 'mysql' client
Right, that is what I am doing, but it does not work.
Have you used mysqldump successfully?
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Aaron Morris [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, November 15, 2005 1:40 PM
Subject: Re: mysqldump
Aaron
I am still trying to create a schema. I do not get errors when I do
so but in phpmyadmin I get these types of warning for five tables:
table 1:
UNIQUE and INDEX keys should not both be set for column `email`
table 2:
More than one INDEX key was created for column `mail_id`
More than one INDEX
Peter Matulis [EMAIL PROTECTED] wrote on 11/15/2005 02:47:56 PM:
I am still trying to create a schema. I do not get errors when I do
so but in phpmyadmin I get these types of warning for five tables:
table 1:
UNIQUE and INDEX keys should not both be set for column `email`
table 2:
More
Aaron Morris wrote:
Right, that is what I am doing, but it does not work.
Since you don't tell us what you did, what error messages you got,
or what 'does not work' means, little can be done to assist you.
Have you used mysqldump successfully?
- Original Message -
From:
Stupid question. units is no different from item1 at this point.
- Original Message -
From: Jonathan Mangin [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, November 15, 2005 2:36 PM
Subject: Missing column in select??
I thought I'd found a mistake...
$sql =
At 14:07 -0500 11/15/05, Jeff wrote:
Hey all,
I need to do some repairs on a replication master/slave and can't
remember the command to turn off bin logging on the master for a single
session.
Set session log_bin = off;
Just returns an error: ERROR 1193: Unknown system variable 'LOG_BIN'
Hello.
You should think about using REPLACE function. See:
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
BTW, 3.23 is a very old version. If you switch to 5.0 you'll be able to
use all power of stored functions. Think about UDFs as well (but it
could be a very heavy
Hello.
SQL_LOG_BIN session variable is what you want. Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/set-option.html
Jeff wrote:
Hey all,
I need to do some repairs on a replication master/slave and can't
remember the command to turn off bin logging on the master for a
Hello.
Most of MySQL users use successfully mysqldump. What error is mysql
command line client reporting during the import?
Aaron Morris wrote:
Right, that is what I am doing, but it does not work.
Have you used mysqldump successfully?
- Original Message ---
--
Hi Gleb,
Thanks for your reply.
I am using MySQL 3.23.33.
The ones that I will need to add in my.cnf are the syncronisation parameters as
follow:
binlog-do-db=XYZ
replicate-do-db=XYZ
replicate-ignore-table=XYZ.table1
replicate-ignore-table=XYZ.table2
replicate-ignore-table=XYZ.table3
Gleb Paharenko:
Could you provide a repeatable test case for you problem?
I don't know how repeatable this is. As I said I have one computer where it
seems to work sometimes, as if there's a race condition. Right now it seems
repeatable on the computer I'm using at the moment:
mysql select
Hi!
Also look at
SHOW INNODB STATUS\G
during the slow phase.
What does it say about the 'Main thread ... state'?
What does it say about transactions?
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a
Hi Bjorn,
It looks like the LAST_INSERT_ID() is returning the id of the last
auto_increment INSERT, this seems to be in line with the documentation.
quote
The ID that was generated is maintained in the server on a per-connection
basis. This means that the value which the function returns
Dear all,
I am new to Mysql, and we are using Mysql as the backend database in out
data server, and I wonder if how I create a symbol link under the Mysql data
directory to link to a database under another directory so that we can save
disk space.
Any help will be highly appreciated.
At 08:22 PM Monday, 11/14/2005, Jason Martin wrote -=
On Sun, Nov 13, 2005 at 08:56:12PM -0800, Ed Kasky wrote:
Snort v2.4.3
ACID v0.9.6b23
I seem to recall hearing that ACID is deprecated; you might want
to look around if there is a newer equivalent. SQUIL
(http://sguil.sourceforge.net/) is
--- [EMAIL PROTECTED] wrote:
Peter Matulis [EMAIL PROTECTED] wrote on 11/15/2005 02:47:56
PM:
but in phpmyadmin I get these types of warning for five
tables:
table 1:
UNIQUE and INDEX keys should not both be set for column `email`
table 2:
More than one INDEX key was created
Peter Matulis wrote:
--- [EMAIL PROTECTED] wrote:
Peter Matulis [EMAIL PROTECTED] wrote on 11/15/2005 02:47:56
PM:
but in phpmyadmin I get these types of warning for five
tables:
table 1:
UNIQUE and INDEX keys should not both be set for column `email`
table 2:
More than one INDEX key was
Hi all
First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2
with MySQL 4.1.12, rpm install.
Changed the data directory.
My /etc/my.conf
[mysqld]
datadir=/home.dbdata/mysql
socket=/home.dbdata/mysql/mysql.sock
# Default to using old password format for compatibility with
Running /etc/rc.d/init.d/mysqld start says that mysql start failed BUT
This doesn't nesessarily mean that mysql hasn't started. This script waits
only for certain time to check if mysql has started or not. If it is not
started in that time, it simply says 'mysql start failed'. But mysql may
57 matches
Mail list logo