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 current (latin1) data are:
mysql> select * from topics_lookup where label like 'Zor%';
+--+--+
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 current (latin1) data are:
> mysql> select * from topics
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, instead it
contains one the c
You can write a shell script to kill these threads one by one.
On Mon, Jun 30, 2008 at 9:43 AM, Marcin Polewski <[EMAIL PROTECTED]>
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=/va
I advise you should add a new column to save this information
date_format(cache.server.tstamp,"%Y %M %d %H %i")) and add a new index on
it.
On Sat, Jun 28, 2008 at 8:55 PM, Darryl Steyn <[EMAIL PROTECTED]>
wrote:
> Hi Ananda,
>
> At the moment the explain for the entire month will look the same
For example,the user is [EMAIL PROTECTED]
I want to adjust timeout value for him ,which is different from the global
parameter named interactive_timeout or wait_timeout?
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn