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

On Wed, Jul 15, 2009 at 11:58 AM, mos 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 could do

RE: Slave log files going nuts...

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 Beha

Re: Slave log files going nuts...

On Thu, Jul 16, 2009 at 1:18 PM, Gary Smith 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 blank.   > This slave

Slave log files going nuts...

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 downstr

Re: error logging from fulltext plugin

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 didn't

Re: Slow query Performance

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 s

Porting MySQL database across international sites

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, I

Re: MySQL Windows version

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

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

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 w

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

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 request).

RE: Slow query Performance

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 preve

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

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 f

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

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, no

Re: Slow query Performance

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® wrote: > > I'm having random query slowness that i can only reproduce once. My main > > question is that the query runs

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

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: MYSQL 5.1.35 Segmentation fault

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 monito

Hi query with more relation

Hi all *country* ID Name

Re: MYSQL 5.1.35 Segmentation fault

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 user=

Re: MYSQL 5.1.35 Segmentation fault

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: We