MYSQL 5.1.35 Segmentation fault

2009-07-16 Thread TianJing
Hi all, i am trying to install mysql 5.1.35 in my linux platform, i do it from source distribution, but there is a serious problem when i login it, the error message is bellow: *shell mysql -p -u root Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection

Re: MYSQL 5.1.35 Segmentation fault

2009-07-16 Thread fire9
jing, Please modify your my.cnf file. 在 2009-7-16,下午2:56, TianJing 写道: Hi all, i am trying to install mysql 5.1.35 in my linux platform, i do it from source distribution, but there is a serious problem when i login it, the error message is bellow: *shell mysql -p -u root Enter password:

Re: MYSQL 5.1.35 Segmentation fault

2009-07-16 Thread TianJing
thanks, my.cnf file is as follow: [client] #password = your_password port= 3306 socket = /export/data1/apps/local/mysql/mysql.sock # The MySQL server [mysqld] datadir=/export/data1/apps/local/mysql/data socket = /export/data1/apps/local/mysql/mysql.sock

Hi query with more relation

2009-07-16 Thread bharani kumar
Hi all *country* IDhttp://localhost/phpmyadmin/sql.php?db=totallyairportstable=countrysql_query=SELECT+%2A+FROM+%60country%60+ORDER+BY+%60country%60.%60ID%60+ASCtoken=48055f87d08d88620138b58feb711be2

Re: MYSQL 5.1.35 Segmentation fault

2009-07-16 Thread Joerg Bruehe
Hi TianJing, all! TianJing wrote: Hi all, i am trying to install mysql 5.1.35 in my linux platform, i do it from source distribution, but there is a serious problem when i login it, the error message is bellow: *shell mysql -p -u root Enter password: Welcome to the MySQL monitor.

what outputs/illustrates a table's structure? - WAS: Re: Hard? query to with group order by group head's name

2009-07-16 Thread Govinda
My table group_member looks like this: +---+---+-+ | member_id | name | head_id | +---+---+-+ | 1 | Elim |NULL | | 2 | Ann | 1 | | 3 | David |NULL | | 4 | John | 3 | | 5 | Jane | 3 |

Re: Slow query Performance

2009-07-16 Thread Don Read
On Wed, 15 Jul 2009 23:53:05 -0400 Darryle Steplight said: Can you show us the output of DESCRIBE score and SHOW INDEX FROM score? On Wed, Jul 15, 2009 at 6:44 PM, Tachu®tachu1+my...@gmail.com wrote: I'm having random query slowness that i can only reproduce once. My main question is that

Re: what outputs/illustrates a table's structure? - WAS: Re: Hard? query to with group order by group head's name

2009-07-16 Thread Govinda
I see such nice formated text output serving to illustrate people's tables and I think it must be due to some code which is spitting that out, rather than people typing so painstakingly. What is that function/MySQL/code? It's the default output format of the mysql command line client,

Re: what outputs/illustrates a table's structure? - WAS: Re: Hard? query to with group order by group head's name

2009-07-16 Thread Marcus Bointon
On 16 Jul 2009, at 15:02, Govinda wrote: I see such nice formated text output serving to illustrate people's tables and I think it must be due to some code which is spitting that out, rather than people typing so painstakingly. What is that function/MySQL/code? It's the default output

RE: Slow query Performance

2009-07-16 Thread Martin Gainty
when my.ini has query-cache-type = 1 setting the query results are placed in cache on first read second and consequent reads reference resultset from cache http://www.databasejournal.com/features/mysql/article.php/3110171/MySQLs-Query-Cache.htm Martin Gainty Confucius say Big Dog in door

Re: what outputs/illustrates a table's structure? - WAS: Re: Hard? query to with group order by group head's name

2009-07-16 Thread Marcus Bointon
On 16 Jul 2009, at 15:26, Govinda wrote: Meaning that on a shared hosting situation, without ssh, then I cannot do that, right? Not necessarily - you can run the client locally and connect to the remote DB. It depends if your host allows remote access to mysql (they might do on

Re: Client deleted database, semi high priority master slave question

2009-07-16 Thread russbucket
Scott Haneda wrote: On Jul 8, 2009, at 12:49 PM, Daevid Vincent wrote: I know it comes a little too late, but as a preventive measure going forward, I offer up my daily crontab backup script: http://www.daevid.com/content/examples/daily_backup.php FYI, this link does not work in

Re: MySQL Windows version

2009-07-16 Thread russbucket
russbucket wrote: I have been using the Linux version of MySQL for five years, also used it on a Windows ME system even though documents said you couldn't. Recent a friend asked me to help him get it up and running on a Windows Vista system. I was looking for the system configuration

Porting MySQL database across international sites

2009-07-16 Thread Daniele Development-ML
Hello everybody, the MySQL application I'm building needs to be ported from my current site to the hosting site - which is based on another nation. The problem I'm having is that the login doesn't work as the password doesn't match in the charset of the new hosting site. To address this problem,

Re: Slow query Performance

2009-07-16 Thread Dan Nelson
In the last episode (Jul 15), Tachu(R) said: I'm having random query slowness that i can only reproduce once. My main question is that the query runs faster the second time around but i dont have query cache enabled here is some info from mysql profiler; The time is spent mostly on the

Re: error logging from fulltext plugin

2009-07-16 Thread Tom Kleinpeter
As a followup, simply logging to stderr prints to the $host.err in the mysql data directory, which is good enough for my purposes. In case anyone else is curious, when experimenting I found I could use my_printf_error to return errors to the console where I inserted the bad data. But, that

Slave log files going nuts...

2009-07-16 Thread Gary Smith
I have a new slave I setup against a new master server. The master server has 4 log files in it, the most current being updated on the 16th. The slave server on the other hand has several files, many which seem to be blank. This slave is set to slave the master and act as a master for

Re: Slave log files going nuts...

2009-07-16 Thread Todd Lyons
On Thu, Jul 16, 2009 at 1:18 PM, Gary Smithg...@primeexalia.com wrote: I have a new slave I setup against a new master server.  The master server has 4 log files in it, the most current being updated on the 16th.  The slave server on the other hand has several files, many which seem to be

RE: Slave log files going nuts...

2009-07-16 Thread Gary Smith
I'll have to look into that. We have a single cronjob that just does a mysqldump daily but not during the time of the log file generation, but that's all I can think of off the top of my head. Gary From: tly...@sitehelp.org [tly...@sitehelp.org] On

Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline

2009-07-16 Thread Todd Lyons
On Wed, Jul 15, 2009 at 11:58 AM, mosmo...@fastmail.fm wrote: I have backup all the database files(innodb engine). Now I want to recover it as myisam engine offline. Any suggestions? Why can't you copy the InnoDb files to another machine and open the database with another MySQL server? (You