You can override MySQL behaviour of generating a new value if you insert a 0
into an auton_increment field.
Quoting from the manual:
> NO_AUTO_VALUE_ON_ZERO affects handling of AUTO_INCREMENT columns.
> Normally, you generate the next sequence number for the column by inserting
> either NULL or
Hi,
Iam running a mysql server 5.0.15 over Redhat linux es4. My disk space
has exhausted. so i need to add a new ibdata file to my /etc/my.cnf
configuration. I followed the following procedure to do so.
1. I checked the ibdata1 file size.
when i do a du -sh ibdata1 , i get the size to be 443M
That is, in fact, the exact correct syntax. What error are you
getting when you try to run that on the commandline? What version of
MySQL are you using?
-Sheeri
On 3/29/06, Rich <[EMAIL PROTECTED]> wrote:
> Hi folks. I come to the list with another compound question.
>
> My middleware allows m
Hi folks. I come to the list with another compound question.
My middleware allows me to build any syntax for the actual sql
statement, so I'm trying to minimize the work done to insert several
records at one try. I currently have multiple insert statements, but
can't find any reference to mu
mysql> desc MSGDB_20060330;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| CREATETIME| char(14)| NO | |
Thanks a lot. I'll try.
- Original Message -
From: "Kishore Jalleda" <[EMAIL PROTECTED]>
To: "古雷" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, March 29, 2006 11:53 PM
Subject: Re: Multiple-Master Replication recovery
> any one of the servers could go down in many ways like
> 1) disk crash
>
On 30/03/2006 12:31 p.m., Daniel Kasak wrote:
[EMAIL PROTECTED] wrote:
I suppose that would be alot easier than trying to bump the PK and
related FK values of the whole table by 1, just to give the first row
in the table the auto_increment value of 1?
Yes. That sounds messy.
What about be
[EMAIL PROTECTED] wrote:
Are you saying just change the row with the 0 value as the
PK, and change the FK's in the related tables to point to
the new value instaed of 0?
Yes.
If so, would this move the row logically to the end of the
table, if the 0 PK was replaced with the next auto_incr
Are you saying just change the row with the 0 value as the
PK, and change the FK's in the related tables to point to
the new value instaed of 0?
If so, would this move the row logically to the end of the
table, if the 0 PK was replaced with the next auto_increment
value?
I suppose that would
Stanton, Brian wrote:
I'm migrating a database from 4.0.12 on Solaris to 4.0.18-0 on Red Hat
Linux. A few of the tables have a 0 (zero) in the auto_increment primary
key column. However, when importing, the 0 in the insert is translated to
the next available auto_increment value thus causing a
Vinny <[EMAIL PROTECTED]> wrote on 03/29/2006 03:52:33 PM:
> Hello All,
> I am running across a very weird problem.
> Sometimes when a person paste text from a Worddoc
> into the text field of our webapp, the insert fails. Unfortunately
> I am not seeing the failure in the logs. There are a lot of
I'm migrating a database from 4.0.12 on Solaris to 4.0.18-0 on Red Hat
Linux. A few of the tables have a 0 (zero) in the auto_increment primary
key column. However, when importing, the 0 in the insert is translated to
the next available auto_increment value thus causing a duplicate key
situation
If they are pasting from Word, there is a lot of Word-proprietary XML and
formatting that is being pasted as well.
Your insert statement may be failing because:
1) Because of the XML and formatting, the statement is going beyond
the TEXT fields limit;
2) There are ' (single quotes)
Marten,
- Original Message -
From: "Marten Lehmann" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, March 29, 2006 7:52 PM
Subject: Re: innodb errors on startup
Well,
ok, we need to stress this more in the manual. A few users have
misunderstood that ibdata
Hello All,
I am running across a very weird problem.
Sometimes when a person paste text from a Worddoc
into the text field of our webapp, the insert fails. Unfortunately
I am not seeing the failure in the logs. There are a lot of factors
to consider. The path to mysql looks like this.
Firefox (OSX
Jacob, Raymond A Jr wrote:
After a 23days of running mysql, I have a 3GB database. When I use an
application
called base(v.1.2.2) a web based intrusion detection analysis console, the
mysqld utilization
shoots up to over 90% and stays there until the application times out or is
terminated.
Q
Quoting sheeri kritzer ([EMAIL PROTECTED]):
> According to the manual, 64 to 32 bit shouldn't matter, it should work
> fine as long as they're both little endian, or they're both big
> endian.
This friend of mine said he also had major problems moving 32->64.
Crashing mysql's, but not corrupt tab
According to the manual, 64 to 32 bit shouldn't matter, it should work
fine as long as they're both little endian, or they're both big
endian.
I've copied MyISAM tables from 64 to 32 bit without a problem.
BTW, I suggested that because in the error it said:
"myisamchk: error: Key in wrong positi
Quoting sheeri kritzer ([EMAIL PROTECTED]):
> what's the result of
> SHOW CREATE TABLE games
It gives me the create statement for that table.
All perfectly normal. MyISAM table, latin1 charset.
> I'd drop the indexes on the games table, and then run repair tables,
> and then put the indexes back
what's the result of
SHOW CREATE TABLE games
??
I'd drop the indexes on the games table, and then run repair tables,
and then put the indexes back in. Worth a shot.
-Sheeri
On 3/29/06, Sander Smeenk <[EMAIL PROTECTED]> wrote:
> Quoting [EMAIL PROTECTED] ([EMAIL PROTECTED]):
>
> > Have you tri
Quoting [EMAIL PROTECTED] ([EMAIL PROTECTED]):
> Have you tried the following myisamchk option:
> --extend-check, -e
Yup. But that won't even work at ALL:
# myisamchk -e games.MYI
Checking MyISAM file: games.MYI
Data records: 10644 Deleted blocks: 0
- check file-size
- check record de
Have you tried the following myisamchk option:
--extend-check, -e
Check the table very thoroughly. This is quite slow if the
table has many indexes. This option should only be used in
extreme cases. Normally, myisamchk or myisamchk
--medium-check should be able to determine whether there are
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
> That usually means the table is corrupt beyond repair and nothing is really
> fixing it or there is something one cannot easily comprehend ( this usually
> happens with inconsistency among deleted records and some kind of mismatch
> that occurs) -
After a 23days of running mysql, I have a 3GB database. When I use an
application
called base(v.1.2.2) a web based intrusion detection analysis console, the
mysqld utilization
shoots up to over 90% and stays there until the application times out or is
terminated.
Question: Have I made some err
Thanks Shawn,
Believe you me, I share your reaction to this architecture...I had to spend
2 hours coding a ruby script to get the data into the kludgy form needed for
the data import (though I do find that thing kind of fun...but it's not the
best use of my time on the job). Fortunately the data
Well, I'm doing something stupid because that is what the bosses want. I
appreciate the suggestions, I think the CSV string format is the way to
go.
David Godsey
> David Godsey wrote:
>
>>>
>>> I know, I know, sounds like something that should be done in the
>>> presentation layer, howerver if
I am using freeradius with MySql and what I would like to do is create
in my radius table an user with attributes stating a start and stop
date.
I would like to be able to do a bulk entry (more than 1 at a time) or
would love for this to be web based.
Is this process out there?
Thanks
Dw
Are there any documents, help files, tutorials, or anything on the MySQL
Workbench program? I've played with it, and just can't figure out how to
use some of it's features.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
Well,
ok, we need to stress this more in the manual. A few users have
misunderstood that ibdata files would no longer be needed if one uses
innodb_file_per_table.
ib_logfiles are always needed. How else can InnoDB recover after a crash.
but how can I repair my existing ib-files so that the
That usually means the table is corrupt beyond repair and nothing is really
fixing it or there is something one cannot easily comprehend ( this usually
happens with inconsistency among deleted records and some kind of mismatch
that occurs) -anyway what I would really advice in this case is to
r
any one of the servers could go down in many ways like
1) disk crash
2) replication failure
3) power failure
4) any hardware component failure
5) OS hang
6) Network failure
7) MYSQL bug
8) table corruption etc ...
9) or just scheduled donwtime
in any case what really matters is the difference
Hello!
I'm having a weird problem i'd like to hear your opinions about:
| [18:44] [EMAIL PROTECTED]:~] # mysqlcheck v games
| v.games
| error: Table './v/games' is marked as crashed and should be repaired
| [18:44] [EMAIL PROTECTED]:~] # mysqlcheck -r v games
| v.games
I have found the answer
select max(greatest(f1,f2,f3 .)) from table
"Sandy" <[EMAIL PROTECTED]> a écrit dans le message de news:
[EMAIL PROTECTED]
> Hi
>
>
> select max(f1) as nf1 , max(f2) as nf2, max(f3) as nf3, max(f4) as nf4
> from table
>
>
> How can I extract a max value from t
Mark Leith wrote:
Hi Jorrit,
Jorrit Kronjee wrote:
[EMAIL PROTECTED] wrote:
is this relevant ?
We've been looking at connection graphs, but MySQL doesn't seem to
reach that limit. However, these are timely based measurements, so it
could've peaked in between, although highly unlikely.
I'
Marten,
Marten Lehmann wrote:
Hello Heikki,
can you email the complete .err log from the server to
[EMAIL PROTECTED]
the complete log is about 50 mb, since a lot of errors occur.
I am interested in what caused the very first crash in the server. Now
your
database seems to be seriously corr
Hi Jorrit,
Jorrit Kronjee wrote:
[EMAIL PROTECTED] wrote:
is this relevant ?
We've been looking at connection graphs, but MySQL doesn't seem to
reach that limit. However, these are timely based measurements, so it
could've peaked in between, although highly unlikely.
I'm not very comforta
Hello Heikki,
can you email the complete .err log from the server to
[EMAIL PROTECTED]
the complete log is about 50 mb, since a lot of errors occur.
I am interested in what caused the very first crash in the server. Now your
database seems to be seriously corrupt, since the log sequence numb
Quoting Pete Harlan ([EMAIL PROTECTED]):
> > MySQL version 5.0.18
> > | Mar 14 00:32:59 zwart mysqld[29820]: *** glibc detected *** double
> > | free or corruption (!prev): 0x012b1ab0 ***
> You don't say which versions of glibc or the kernel you're running,
> but if you're r
古雷 wrote:
> Hello:
> If I use Multiple-Master Replication with two mysql server, when one of them
> goes down(disk crashed) must I shutdown the good one to recover the
> Multiple-Master Replication ?
I think yes.
Depends on what you mean with "recover the Multiple-Master Replication"
Do you want
Sandy wrote:
Hi
select max(f1) as nf1 , max(f2) as nf2, max(f3) as nf3, max(f4) as nf4 from
table
How can I extract a max value from the 4 columns of the result ?
ex: greatest(nf1,nf2,nf3,nf4)
Thanks
SELECT MAX (max(f1) as nf1 , max(f2) as nf2, max(f3) as nf3, max(f4) as
nf4) AS max
Song Ken Vern-E11804 wrote:
It seems like different version are doing things differently.
This is the most normal thing in the world!
Looking through the newsgroups & forums, I understand that that mysql5.0
will
prepend the tablename to each column.
But I don't understand what does 'test
zhengjc wrote:
> I am very sorry for ask the question.
>
> I want to know mysql support ipv6 or not
> if support, which is the version from
>
> best regards!
>
>
Here, this might help:
http://www.ngn.euro6ix.org/IPv6/mysql/
Regards
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me
I am very sorry for ask the question.
I want to know mysql support ipv6 or not
if support, which is the version from
best regards!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You haven't told how many members are there.
Anyway... i've worked out something with a colleague at work...
Given your tables:
*CREATE TABLE `list_problem_members` ( `id` int(11) NOT NULL
auto_increment, `member` varchar(11) NOT NULL default '', PRIMARY KEY
(`id`) );*
**
*CREATE TABLE `list_prob
[EMAIL PROTECTED] wrote:
is this relevant ?
We've been looking at connection graphs, but MySQL doesn't seem to reach
that limit. However, these are timely based measurements, so it could've
peaked in between, although highly unlikely.
I'm not very comfortable tweaking these values in a prod
45 matches
Mail list logo