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

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 D

RE: my.cnf file

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... http://dev.mysql.com/doc/refman/5.1/en/mysqld-option-tabl

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

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

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" Date: Tue, Oct 19, 2010 17:50 Subject: uninstall/r

RE: my.ini

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

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

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" Date: Thu, Sep 9, 2010 21:31 Subject: hard disk crash: how to discover the db? To: "mysql@lis

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

Try using a mysqldump. - Reply message - From: "ext Nunzio Daveri" Date: Wed, Sep 8, 2010 19:25 Subject: Replaying the mysqld.log file from production onto QA??? To: "mysql@lists.mysql.com" Hello all, I am trying to "REPLAY" the mysqld.log file from a production 5.1.4 server onto a QA s

RE: replication help

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: mysql@lists.mysql

RE: Join Problem

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

RE: Disable bin-log without restart

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 disabl

RE: better way to backup 50 Gig db?

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