hello there, I am using ftplicity accordingly to an article in a german newsmagazine to do my backup. It works fine except for one thing I do not understand. Its all about the first line of my report file: can anyone help with this? google yields no results for this :-(
What's the output of Code: ls -l /var/lib/named/dev/log ? What's the output of Code: ls -l /dev/log ?
Ah, now I understand. You try to back up /var/lib/named... /var/lib/named/dev/log isn't a regular file, so this cannot be backed up. I think that's why ftplicity is complaining. If ftplicity is working (apart from this error), I'd ignore it.
ahh. thx. here is my exclude list: does that look ok? the only thing I am not sure about is if I should not include /var/spool into the backup, but it was complaining there too. I will add /var/lib/named into the exclude list or should I exclude the whole /var/lib directory?
I'd just add /var/lib/named/dev. If you use mbox and want to back up your mailboxes, it's possible that the mailboxes are in /var/mail (with /var/spool/mail being a symlink to /var/mail), so they should be backed up.
one more question, ftplicity states that it can execute certain commands before backing up and says as an example I could dump all databases before backing up.... in another thread here: http://www.howtoforge.com/forums/showthread.php?t=6237 I asked if I can modify the backup script of ispcfg to only backup dbs so that I would not have to modify ftplicity anymore, or what would be the easieast way to also backup databases using this combination of tools?
wel, the ftplicity way means I would have to write my own sql dump script that dumps the table inside the webdirectory and after ftplicity has done its backup I can delete that backupfile with another script executed after the backup, sounds good but I would have to know more about scripting so that ftplictity woudl execute those scripts for all db's.... I'll give this thing a try
Have a look here: http://www.howtoforge.com/forums/showthread.php?t=5408&highlight=mysqldump http://www.howtoforge.com/forums/showthread.php?t=5191&highlight=mysqldump http://www.howtoforge.com/forums/showthread.php?t=4629&highlight=mysqldump
thx a lot I was not aware I was already backing up the mysql DBs because I do a almost complete file based backup..
well,, now I ran into new problems: these errors are reported during a ftplicity backup. I guess they are related to me trying to get cronjobs running, see this post: http://www.howtoforge.com/forums/showpost.php?p=38604&postcount=10 But still I do not udnerstand why its looking for /var/www/web1/var/spool, what I did was copy the var/spool and var/spool/cron to the users profile, didn't I? ###edit### problem solved: I was copying everything inside /var/spool instead of only copying the content of /var/spool/cron
Concerning my above statement I am just curious if there is a big difference between backing up all files of a certain DB and backing up a dump of it. I mean if a client wants to restore some settings inside a DB, he might open a dump and only import certain parts of it whereas if I just give him all the files his DB consists of he might not be that happy? so would you suggest I stop backing up the files of the DBs and start backing up dumps?
I'd say dumps are more compatible, i.e. you can use a dump from a 3.23 MySQL database and import it into a MySQL 5 database. This could make problems if you use the database files (although i haven't tried yet).