I'm rebuilding a server that is a slave to our primary. At this
point in the game, I can no longer access anything on the slave server
(its main drive is being rebuild). However, I do have a full rsync of
the /var/lib/mysql folder that was on it (this rsync was done AFTER
MySql was properly shutdown on this server.) And I have all the info
from the master server as well.
So the question is, once I finish rebuilding this machine and I
install MySQL back on it, what's the proper or safest way to rebuild the
slave setup and get it going again (and pick up where it left off before
the machine went down)? Can I simply rsync all the files back and start
MySQL?
Looking at the rsynced data, I can see the -relay-bin files, all the
mysql-bin files, and all the individual databases in their respective
folders:
drwx------ 2 mysql mysql 12288 Sep 11 2007 lif1/
drwx------ 2 mysql mysql 4096 Apr 3 10:00 lif2/
drwx------ 2 mysql mysql 16384 Mar 4 19:00 lotro/
drwx--x--x 2 mysql mysql 4096 Apr 14 2007 mysql/
drwxr-xr-x 2 mysql mysql 4096 Apr 13 11:59 test/
drwx------ 2 mysql mysql 4096 Jan 28 10:54 wonderland/
-rw-rw---- 1 mysql mysql 10485760 Apr 22 10:30 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Apr 22 10:30 ib_logfile0
-rw-rw---- 14 mysql mysql 5242880 May 11 2007 ib_logfile1
-rw-rw---- 1 mysql root 25480 Apr 22 10:30 lilpusher.err
-rw-rw---- 1 mysql mysql 4607313 Apr 22 10:30 lilpusher-relay-bin.005216
-rw-rw---- 3 mysql mysql 29 Apr 20 05:42 lilpusher-relay-bin.index
-rw-rw---- 1 mysql mysql 23176 Apr 22 10:30 log.0000000001
-rw-rw---- 1 mysql mysql 84 Apr 22 10:28 master.info
-rw-rw---- 14 mysql mysql 117 May 11 2007 mysql-bin.000001
-rw-rw---- 14 mysql mysql 117 May 11 2007 mysql-bin.000002
-rw-rw---- 14 mysql mysql 117 May 21 2007 mysql-bin.000003
-rw-rw---- 14 mysql mysql 98 May 21 2007 mysql-bin.000004
-rw-rw---- 14 mysql mysql 117 Jun 15 2007 mysql-bin.000005
-rw-rw---- 14 mysql mysql 117 Aug 11 2007 mysql-bin.000006
-rw-rw---- 14 mysql mysql 117 Sep 25 2007 mysql-bin.000007
-rw-rw---- 14 mysql mysql 117 Oct 24 10:06 mysql-bin.000008
-rw-rw---- 14 mysql mysql 117 Oct 28 09:50 mysql-bin.000009
-rw-rw---- 14 mysql mysql 117 Nov 6 12:26 mysql-bin.000010
-rw-rw---- 14 mysql mysql 117 Dec 23 03:15 mysql-bin.000011
-rw-rw---- 1 mysql mysql 117 Apr 22 10:30 mysql-bin.000012
-rw-rw---- 14 mysql mysql 228 Dec 23 03:18 mysql-bin.index
-rw-rw---- 1 mysql mysql 66 Apr 22 10:28 relay-log.info
--
W | It's not a bug - it's an undocumented feature.
+--------------------------------------------------------------------
Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130
IT Director / SysAdmin / Websmith . 800.441.3873 x130
Photo Craft Imaging . 3550 Arapahoe Ave. #6
http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]