RE: my.cnf file

2010-12-30 Thread andrew.2.moore
Adam, you should look upon this as an opportunity to write a my.cnf that suits your application and hardware. Understanding the options in this configuration can be paramount to a well tuned server. a few resources to kick it all off...

RE: /etc/init.d/mysql start WITHOUT integrity check?

2010-12-30 Thread andrew.2.moore
Daevid, I'm not quite sure I understand why you want to restart your master. Adding a slave shouldn't require any restarts/reloads. What have you changed in the my.cnf to solicit a restart? Andy From: ext Daevid Vincent [dae...@daevid.com] Sent: 29

RE: Does mysql cache strip out /* comments */ first?

2010-11-18 Thread andrew.2.moore
I think you will probably find that the code you write isn't what MySQL executes or stores in the cache. From: vegiv...@gmail.com [vegiv...@gmail.com] On Behalf Of ext Johan De Meersman [vegiv...@tuxera.be] Sent: 18 November 2010 07:48 To: Daevid Vincent

Re: uninstall/reinstall

2010-10-20 Thread andrew.2.moore
You mention the Windows installer has Hung. I have seen this before...try killing the process with task manager and then log into your server via the client. -- Sent from my HTC Desire on 3 -- - Reply message - From: ext Tyler Poland tpol...@engineyard.com Date: Tue, Oct 19, 2010 17:50

RE: my.ini

2010-10-07 Thread andrew.2.moore
Open you're my.ini and correct the values as stated in the event viewer Check the online documentation for the keys and values to set. http://dev.mysql.com/doc/refman/5.1/en/mysqld-option-tables.html Regards -Original Message- From: ext Elim PDT [mailto:e...@pdtnetworks.net] Sent:

Re: hard disk crash: how to discover the db?

2010-09-09 Thread andrew.2.moore
Try using the failed hdd as a slave in a Linux machine. You might find that the hdd won't boot to OS but may have enough in it to access the file system. - Reply message - From: ext Uwe Brauer o...@mat.ucm.es Date: Thu, Sep 9, 2010 21:31 Subject: hard disk crash: how to discover the db?

Re: Replaying the mysqld.log file from production onto QA???

2010-09-08 Thread andrew.2.moore
Try using a mysqldump. - Reply message - From: ext Nunzio Daveri nunziodav...@yahoo.com Date: Wed, Sep 8, 2010 19:25 Subject: Replaying the mysqld.log file from production onto QA??? To: mysql@lists.mysql.com mysql@lists.mysql.com Hello all, I am trying to REPLAY the mysqld.log file from

RE: replication help

2010-08-30 Thread andrew.2.moore
Force all traffic to Node A Break/Stop replication backup Node using mysqldump Restore backup file on Node B Resume replication Install Maatkit Should do the trick... From: ext Norman Khine [nor...@khine.net] Sent: 30 August 2010 15:50 To:

RE: Join Problem

2010-08-16 Thread andrew.2.moore
Review your join type. From: ext Gavin Towey [gto...@ffn.com] Sent: 16 August 2010 19:36 To: Victor Subervi; mysql@lists.mysql.com Subject: RE: Join Problem What do you mean by not working? What results do you get? -Original Message- From: Victor

RE: Disable bin-log without restart

2010-06-11 Thread andrew.2.moore
No George you will need to restart MySQL. From: ext George Chelidze [wr...@geo.net.ge] Sent: 11 June 2010 12:15 To: mysql@lists.mysql.com Subject: Disable bin-log without restart Hello, I have a quite loaded server with bin-log enabled. I'd like to

RE: better way to backup 50 Gig db?

2010-04-20 Thread andrew.2.moore
I would also recommend looking into some 3rd party tools. http://www.percona.com/docs/wiki/percona-xtrabackup:start - Backup Innodb, MyISAM and XtraDB engines. http://www.maatkit.org/ - Packed with useful features inc a parallel dump/import. There's some great features in both products. I will