convertion to utf-8

2008-06-29 Thread Pooly
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%'; +--+--+

Re: convertion to utf-8

2008-06-29 Thread Dan Nelson
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

Wrong PID

2008-06-29 Thread Marcin Polewski
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

Re: Wrong PID

2008-06-29 Thread Moon's Father
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

Re: Slow Query

2008-06-29 Thread Moon's Father
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

How to set the separate connection timeout for a single user?

2008-06-29 Thread Moon's Father
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