Chris Hoogendyk wrote: > > Frank Smith wrote: >> fedora wrote: >> >>> Hi huys.. >>> >>> I have 2 situations: >>> >>> 1) default directory for MySQL is /var/lib/mysql. If this directory is link >>> to /var2/db/mysql and if I put /var/lib/mysql in disklist, can amanda do >>> backup? I think this should be can backup. May I know which directory is the >>> best to put in disklist for this case? >>> >> Amanda will back up the link, but you probably want it to back up the data, >> so you should use /var2/db/mysql as your disklist entry. Or you may want >> both, so if you are rebuilding the entire server you would get the link >> as well, but in that case you might want most or all of /var and not just >> the database link. >> >>> 2) how about this one. In /var/lib/mysql has databases but certain databases >>> in linking to /var3/mysql like: >>> >>> lrwxrwxrwx 1 root root 42 May 16 2007 AngelClub -> >>> /var3/mysql/AngelClub >>> drwx------ 2 mysql mysql 4096 Nov 13 11:55 BabyMobile >>> drwx------ 2 mysql mysql 4096 Nov 13 11:55 BestClub >>> >>> If I put only /var/lib/mysql in disklist, can amanda backup for /var3/mysql? >>> Or should add both /var/lib/mysql and /var3/mysql in disklist? Please >>> advise. >>> >> You would need both. /var/lib/mysql would pick up the BabyMobile and >> BestClub databases, but would only record the link to AngelClub and not >> the database itself, so you would have to add /var3/mysql/AngelClub to >> get that database. > > > This requires just a bit of clarification. > > Amanda calls on native tools to do the backups. On Solaris, people > typically choose to use ufsdump. On Linux, people typically choose to > use gnutar. So the question depends on the behavior of those tools and > possibly the parameters Amanda calls them with, though I doubt Amanda > would call gnutar with --dereference and --create. > > ufsdump will faithfully backup a partition. That is, it backs up links > as links and restores them as links. It backs up mount points as mount > points and doesn't follow them into other mounted partitions. It deals > properly with weird things such as doors. So, to paraphrase, when you > ask ufsdump to do a partition, you get the partition, the whole > partition, and nothing but the partition. > > I'm less familiar with all the gnuances of gnutar, and some people will > substitute star or a wrapper of their own. But gnutar will typically > backup a symlink as a symlink, though it has parameters that can be > tweaked to do otherwise. Gnutar also typically follows mount points into > other mounted partitions, though I'm going to take a guess that Amanda > passes it the parameter that tells it not to do that. It would seem > contrary to the concept of the way DLE's are configured to have gnutar > expanding mount points.
Yes, tar can follow links, but Amanda calls it with the --one-file-system option so it won't cross filesystem boundariea. Frank > > Aside from the above, I go along with Frank's response. > > In addition, you should read the backup reports. Check the sizes of your > partitions with `df -k` and then compare those with what the Amanda > reports as the amount of data having been backed up. See if they make > sense. And do trial recoveries to confirm that what you think got backed > up really did get backed up and that you can recover it. > > Also, since you are doing mySQL, be sure you are taking into account the > peculiarities of backing up databases. > > > --------------- > > Chris Hoogendyk > > - > O__ ---- Systems Administrator > c/ /'_ --- Biology & Geology Departments > (*) \(*) -- 140 Morrill Science Center > ~~~~~~~~~~ - University of Massachusetts, Amherst > > <[EMAIL PROTECTED]> > > --------------- > > Erdös 4 > > -- Frank Smith [EMAIL PROTECTED] Sr. Systems Administrator Voice: 512-374-4673 Hoover's Online Fax: 512-374-4501