other than what Gleb says,
you can avoid the error using 'insert ignore into' or better yet
'replace into'
for every insert statement
AESYS S.p.A. [Enzo Arlati] wrote:
I'm trying to use teh parameter sql_slave_skip_counter at run-time to
restore slave replication.
When a slave replication bro
Is there a simple way of checking whether all the columns in a SELECT
are NULL? I know I can do the following:
SELECT c1, c2, c3 FROM t WHERE COALESCE(c1, c2, c3) IS NOT NULL
but this relies on specifying every column I've selected (which in my
actual code is a lot of columns that may change d
At 11:50 +0800 12/30/05, wangxu wrote:
AS 1.7.3. Running MySQL in ANSI Mode explain:
--
Running the server in ANSI mode is the same as starting it with
these options (specify the --sql_mode value on a single line):
--transacti
[in reply to [EMAIL PROTECTED], 28-12-2005]
Hi,
>> MySQL 4.1.10a on FreeBSD 5.4-RELEASE-p6
>> ERROR 1030 (HY000): Got error 12 from storage engine
>> Strangely, this problem does not appear when mysqld is restarted and I
>> retry the query. When I wait a day, the error starts to appear again.
>
>
AS 1.7.3. Running MySQL in ANSI Mode explain:
--
Running the server in ANSI mode is the same as starting it with these options
(specify the --sql_mode value on a single line):
--transaction-isolation=SERIALIZABLE
--sql-mode=REAL_AS_
I forgot to mention - I'm running MySQL 4.0.14 on Linux. And I'm not very
knowledgeable on databases. I just use MySQL with Knoda to get the job done.
==
I've got a MySQL table that I'd like to have the current date,
CURDATE(), as the default in a column. I'm using knoda t
Yes,I already read this section.
But, maybe there are haven't relation to my question.
Are the effect of setting IGNORE_SPACE in sql mode allowing add space between
function name and "("?
If my attitude is right,then if i haven't setting IGNORE_SPACE in sql mode,I
shouldn't add space between f
On 12/28/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
> > #1054 - Unknown column 'CommentsIDX' in 'where clause'
> > My table structure contains:FULLTEXT KEY `CommentsIDX` >(`Comments`)
>
> You should use column names not index names in your queries. Please,
> provide CREATE stateme
thanks
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
Sent: Thursday, December 29, 2005 10:38 PM
Subject: (ÈðÐÇÌáʾ-´ËÓʼþ¿ÉÄÜÊÇÀ¬»øÓʼþ)RE: set sql mode
An error is only thown during an INSERT or UPDATE statement, otherwise
you just get a warning.
- ERROR_FOR_
Hello.
>From the manual:
ANSI
Equivalent to REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE.
Before MySQL 5.0.3, ANSI also includes ONLY_FULL_GROUP_BY. See Section
1.8.3, âRunning MySQL in ANSI Modeâ.
wangxu wrote:
>I set my sql_mode =
>'STRICT_TRANS_TABLES,ANSI_QUOTES
Hello.
>Is there any good idea to load balance for our mysql servers?
I'm not sure, but have a look at "High Performance MySQL" by
Jeremy D. Zawodny. This is a snip from it's publically available
chapter.
###
Real-time data
Hello.
For auto_increment columns MySQL sets in the binary logs INSERT_ID
variable, research binary and relay logs and check if it is set to
the same value. Is it possible that you forgot to change the
master_log_pos and master_log_file after copying the data to the slave?
PaginaDeSpud
Hello.
>there, in fact, anything important in that ibdata1 file, or can I just
>shut down mySQL, move that file somewhere else, and then re-start mySQL?
Yes, this file contains important information.
>Is this possible, or am I stuck having my database server off-line for
>hours while the
Hello.
> but the problem is the same and the command 'show slave status' report
>a skip_counter filed equals 0.
> Where I am wrong , some can help me ?
This variable is the number of events from the master that a slave
server should skip. sql_slave_skip_counter decrements each time the
s
I've got a MySQL table that I'd like to have the current date,
CURDATE(), as the default in a column. I'm using knoda to worj with this
table. How do I use knoda to get this done? I can enter CURDATE() in the
default using the GridColumns button, but all that does is insert the
phrase "CURDATE()".
Hi James,
Check the whole /mnt filesystem hasn't been mounted read-only.
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Pa
Trying to help you with your replication problems is pretty much
impossible without more information, such as: mysql versions and a more
detailed explanation of your replication setup.
I manage setups ranging from 1-14 replication slaves transmitting up to 2
gigabytes of data per day, and none of
Less optimal solution:
Create a DNS round-robin alias, say
mydatabase.myinternaldomain.com, that point to S2-4.
"Optimal" solution:
Set up a real load balancer, hardware based or software based
(http://www.linuxvirtualserver.org/), and have it configured to distribute
your connecti
Hi Dan, all!
Dan Rossi wrote:
Hi, im having some issues with a sub query in mysql5 , i have a field
which is storing a static comma seperate list of primary keys ie 1,2,3,4
Call me pedantic, but I get suspicious:
Is that a list of the four values "1", "2", "3", "4", or is it rather a
single
Mr Ikar of Core Team Lam give me a different answer ( see belowe ):
This is MySQL server bug - it specifies wrong length for fields from SHOW
statements. We avoided this bug in MyDAC 4 code.
Can someone confirm me such bug with mysql, and when it sould be solved ?
Mr Paharenko, I route your answe
Hi James, all!
James Brown wrote:
Thanks for the advice David. I opted for your method 2 and symlinked to
my database files which now reside on a FAT32 partition.
Unfortunately, I've hit a slight issue which I'd like to run past you,
but I do think this could turn out to be a FAT32 problem r
Thanks for the advice David. I opted for your method 2 and symlinked to
my database files which now reside on a FAT32 partition.
Unfortunately, I've hit a slight issue which I'd like to run past you,
but I do think this could turn out to be a FAT32 problem rather than a
MySQL one.
Basically,
Dan Rossi <[EMAIL PROTECTED]> wrote on 12/29/2005 07:19:13 AM:
> Thanks for your kind words of opinion, if you feel you have a better
> way please do go ahead , i am going to show you the sql i ended up
> using which was a union to append the current summary at the end, i
> then had to use php
An error is only thown during an INSERT or UPDATE statement, otherwise
you just get a warning.
- ERROR_FOR_DIVISION_BY_ZERO
Produce an error in strict mode (otherwise a warning) when we encounter
a division by zero (or MOD(X,0)) during an INSERT or UPDATE. If this
mode is not given, MySQL instea
On 28/12/2005, [EMAIL PROTECTED] wrote:
> I don't think there is any way with plain-old SQL (extended or
> otherwise) to do it in a single statement (unless you are doing it
> iteratively - that is: in a stored procedure and row-by-row).
USE test;
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (
Thanks for your kind words of opinion, if you feel you have a better
way please do go ahead , i am going to show you the sql i ended up
using which was a union to append the current summary at the end, i
then had to use php afterwards to add up the totals as i was getting
unexpected results whe
Hi,
Did you check your error log file?
Is there allready a pid file in the directory? You have to delete this
one first.
Hope this helps :-)
Danny
ali asghar torabi parizy wrote:
hi to all
i have mysql5.1 installed on fedoracore3
it was worked sucsessfully since yesterday.
but when i ru
hi to all
i have mysql5.1 installed on fedoracore3
it was worked sucsessfully since yesterday.
but when i run mysql_safe script today, it prompt following error:
STOPPING server from pid file /usr/local/mysql/var/localhost.localdomain.pid
***
Sorry, I didn't understand your replay.
Is not clear to me if you are talking about a mysql bug and there is some
solution available.
Please, Can you expand more on your answer.
Regards, Enzo
-Messaggio originale-
Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Inviato: giovedì 29 dicembr
Hi,
I have had same issue for very long time - but managed.
I see this as a "bug / issue" to be handled by MySQL - because the
logfile/replicationfile should not add more data then the orig SQL from program
- in this case is added the auto-increment, which is dealt with internal by
MySQL.
Bes
30 matches
Mail list logo
