> > Also my master.info ends up being wrong whenever the
> server is
> > rebooted. (binlog.100 becomes binlog.100\n).
>
> Can you expand on that problem a bit?
When I do a "show slave status" before a reboot I have this:
+-------------+-------------+-------------+---------------+-------------+----------+---------------+-----------------+---------------------+
| Master_Host | Master_User | Master_Port | Connect_retry |
Log_File | Pos | Slave_Running | Replicate_do_db |
Replicate_ignore_db |
+-------------+-------------+-------------+---------------+-------------+----------+---------------+-----------------+---------------------+
| db_server | repl | 3306 | 0 |
db1-bin.200 | 18378935 | Yes | |
|
+-------------+-------------+-------------+---------------+-------------+----------+---------------+-----------------+---------------------+
After a reboot I will have something like this:
+-------------+-------------+-------------+---------------+-------------+----------+---------------+-----------------+---------------------+
| Master_Host | Master_User | Master_Port | Connect_retry |
Log_File | Pos | Slave_Running | Replicate_do_db |
Replicate_ignore_db |
+-------------+-------------+-------------+---------------+-------------+----------+---------------+-----------------+---------------------+
| db_server | repl | 3306 | 0 |
db1-bin.200
| 18378935 | Yes | |
|
+-------------+-------------+-------------+---------------+-------------+----------+---------------+-----------------+---------------------+
And it will not replicate because it has a carriage return
after the file name, and says it cannot find the file.
Mike
sql,mysql
---------------------------------------------------------------------
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