Re: A FAQ type question, but not in the FAQ - How to change my hostname, but not make replication puke
Hi, The mysql master wasn't restricting the slave by ip. But thanks, Eric At 10:28 AM 9/30/02 -0500, gerald_clark wrote: You need to grant privileges on the master to the new slave machine. http://www.kwinternet.com/eric (250) 655 - 9513 (PST Time Zone) Inquiry is fatal to certainty. -- Will Durant - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: A FAQ type question, but not in the FAQ - How to change my hostname,but not make replication puke
Did you make the changes to master.onfo to point to the new master? Did mysql own master.info when you were through? Eric Frazier wrote: Hi, I changed my hostname(The DNS change was taken care of elseware) in FreeBSD 4.6 in the rc.conf file, rebooted. Mysql had no problems starting, but it failed to start the slave. In the new error log I saw: 020927 10:15:58 mysqld started 020927 10:15:59 InnoDB: Started 020927 10:15:59 Could not find target log during relay log initialization 020927 10:15:59 Warning: Can't create threads to handle slave /usr/local/mysql/libexec/mysqld: ready for connections 020927 10:16:15 Could not find target log during relay log initialization and I got a 'check permissions on master.info' sort of error when I tried to run 'slave start' I see that error was related to a bug from a long time ago, but I am running 4.0.2 so I doubt that it is a bug issue. Thanks, Eric Leading Edge Marketing Inc. 250-360-2992 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: A FAQ type question, but not in the FAQ - How to change my hostname, but not make replication puke
Hi, I didn't have a new mysql master, just the slave name was changed. Yes on the second question too. Thanks, Eric At 09:09 AM 9/30/02 -0500, gerald_clark wrote: Did you make the changes to master.onfo to point to the new master? Did mysql own master.info when you were through? Eric Frazier wrote: Hi, I changed my hostname(The DNS change was taken care of elseware) in FreeBSD 4.6 in the rc.conf file, rebooted. Mysql had no problems starting, but it failed to start the slave. In the new error log I saw: 020927 10:15:58 mysqld started 020927 10:15:59 InnoDB: Started 020927 10:15:59 Could not find target log during relay log initialization 020927 10:15:59 Warning: Can't create threads to handle slave /usr/local/mysql/libexec/mysqld: ready for connections 020927 10:16:15 Could not find target log during relay log initialization and I got a 'check permissions on master.info' sort of error when I tried to run 'slave start' I see that error was related to a bug from a long time ago, but I am running 4.0.2 so I doubt that it is a bug issue. Thanks, Eric Leading Edge Marketing Inc. 250-360-2992 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php http://www.kwinternet.com/eric (250) 655 - 9513 (PST Time Zone) Inquiry is fatal to certainty. -- Will Durant - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: A FAQ type question, but not in the FAQ - How to change my hostname, but not make replication puke
You need to grant privileges on the master to the new slave machine. Eric Frazier wrote: Hi, I didn't have a new mysql master, just the slave name was changed. Yes on the second question too. Thanks, Eric At 09:09 AM 9/30/02 -0500, gerald_clark wrote: Did you make the changes to master.onfo to point to the new master? Did mysql own master.info when you were through? Eric Frazier wrote: Hi, I changed my hostname(The DNS change was taken care of elseware) in FreeBSD 4.6 in the rc.conf file, rebooted. Mysql had no problems starting, but it failed to start the slave. In the new error log I saw: 020927 10:15:58 mysqld started 020927 10:15:59 InnoDB: Started 020927 10:15:59 Could not find target log during relay log initialization 020927 10:15:59 Warning: Can't create threads to handle slave /usr/local/mysql/libexec/mysqld: ready for connections 020927 10:16:15 Could not find target log during relay log initialization and I got a 'check permissions on master.info' sort of error when I tried to run 'slave start' I see that error was related to a bug from a long time ago, but I am running 4.0.2 so I doubt that it is a bug issue. Thanks, Eric Leading Edge Marketing Inc. 250-360-2992 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php http://www.kwinternet.com/eric (250) 655 - 9513 (PST Time Zone) Inquiry is fatal to certainty. -- Will Durant - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php