try to optimize the table and see if the error goes away
On 7/1/08, Moon's Father <[EMAIL PROTECTED]> wrote:
>
>
> Yeah,they came from .net application and not using load data infile
> statement.
>
> The character set of my db and columns is both utf8;
>
> Some wield thing is that the data is norm
Yeah,they came from .net application and not using load data infile
statement.
The character set of my db and columns is both utf8;
Some wield thing is that the data is normal yesterday ,but they displayed
today after the error happened.
On Mon, Jun 30, 2008 at 7:01 PM, Ananda Kumar <[EMAIL
In the last episode (Jun 30), Pooly said:
> 2008/6/30 Dan Nelson <[EMAIL PROTECTED]>:
> > In the last episode (Jun 29), Pooly said:
> >> Hi,
> >>
> >> I'm trying to convert my tables to UTF8 but I'm getting the
> >> following error: ERROR 1062 (23000): Duplicate entry 'Zorglüb' for
> >> key 1
> >>
Thanks for the suggestion--is that essentially using
http://www.php.net/posix_mkfifo within PHP?
On Mon, Jun 30, 2008 at 7:11 AM, Jerry Schwartz
<[EMAIL PROTECTED]> wrote:
>>-Original Message-
>>From: Waynn Lue [mailto:[EMAIL PROTECTED]
>>Sent: Monday, June 30, 2008 6:04 AM
>>To: MySQL Lis
Ananda, I tried your suggestion of adding "ORDER BY NULL" to the end of my
query, but if anything it took up more disk space. I can see this becoming a
critical problem for me. I just don't understand why this query, which is
really not that crazy, is taking up 800mb of temporary space.
>-Orig
Hi,
2008/6/30 Dan Nelson <[EMAIL PROTECTED]>:
> In the last episode (Jun 29), Pooly said:
>> Hi,
>>
>> I'm trying to convert my tables to UTF8 but I'm getting the following error:
>> ERROR 1062 (23000): Duplicate entry 'Zorglüb' for key 1
>>
>> Not too sure why I'm getting this error since the cur
Hi all,
I am just getting started with replicating my servers and noticed that
queries executed by procedures on the master are not replicated to my
slaves. I need to know if this can be changed or if I have to get rid of my
procedures?
Thanks
Olaf
- Confi
Hi,
this Thursday, Giuseppe Maxia will give a MySQL University session:
http://forge.mysql.com/wiki/Advanced_LUA_Scripting
(topic: Advanced LUA Scripting)
Please register for this session by filling in your name on the session
Wiki page. Registering is not required but appreciated. That Wiki pa
>-Original Message-
>From: Waynn Lue [mailto:[EMAIL PROTECTED]
>Sent: Monday, June 30, 2008 6:04 AM
>To: MySQL List
>Subject: Queues on MySQL?
>
>Hey,
>
>I'm looking to write a queue backed by MySQL to enable batch updates
>of a system I'm writing. Essentially what I wanted to do was every
>-Original Message-
>From: Pooly [mailto:[EMAIL PROTECTED]
>Sent: Sunday, June 29, 2008 5:52 PM
>To: mysql@lists.mysql.com
>Subject: convertion to utf-8
>
>Hi,
>
>I'm trying to convert my tables to UTF8 but I'm getting the following
>error:
>ERROR 1062 (23000): Duplicate entry 'Zorglüb' fo
Eben, all,
I'm very sorry this got out of sight for so long :-(
When I first read your mail, I had no idea, and then it was hidden.
Just now, I check it again and detect what may explain this.
I quote nearly the full mail leading to this, so that you readers need
not scan your archives.
Ebe
Is this data comming from application or loaded using LOAD DATA command. Can
u please check the character set of the db and columns.
On 6/30/08, Moon's Father <[EMAIL PROTECTED]> wrote:
>
> When the memory can not load our application,the error occurs.
> 080630 17:32:38 [ERROR] /usr/local/mysql/bi
When the memory can not load our application,the error occurs.
080630 17:32:38 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed
1651540 bytes)
And there are some data displayed ? in my database.
For example.
mysql> select * from passport where name like '%??%' limit 1\G
**
Hey,
I'm looking to write a queue backed by MySQL to enable batch updates
of a system I'm writing. Essentially what I wanted to do was every
time I want to enqueue, I just INSERT a new row into a table. Then I
have a cron job that runs every X minutes, selects all the existing
rows and does the
Marcin Polewski wrote:
On my machine, I start the following command:
/bin/sh /usr/local/bin/mysqld_safe
--defaults-extra-file=/var/db/mysql/my.cnf --user=mysql
--datadir=/var/db/mysql --pid-file=/var/db/mysql/zigzu.bixbots.com.pid
For some reason my PID file does not contain the parent PID, inst
15 matches
Mail list logo