Re: Backing up server?

2009-10-06 Thread Don Robertson
Solor Vox wrote: I would also like to point out you should *never* backup SQL databases via file method while running. You either have to shut down the SQL server and backup the files, or use another tool such as mysqldump/pg_dump/etc. to dump the live data. Nice MySQL Backup script. http://

Backing up server?

2009-10-06 Thread Bryce Stenberg
Hi all, I've been playing with our Ubuntu server this afternoon, checking out how to back up the system to a windows share. I've got that going using tar and smbmount. First question - is it right that 'tar' does not need to run using 'sudo', as in it can still access all the files? Secondl

Re: Backing up server?

2009-10-06 Thread Craig Falconer
Bryce Stenberg wrote, On 02/10/09 16:53: First question – is it right that ‘tar’ does not need to run using ‘sudo’, as in it can still access all the files? Wrong - tar is a running process that has the same file access as the user it runs as. If you run it as root, you can read all files. I

Re: Backing up server?

2009-10-06 Thread Solor Vox
I would also like to point out you should *never* backup SQL databases via file method while running. You either have to shut down the SQL server and backup the files, or use another tool such as mysqldump/pg_dump/etc. to dump the live data. You should know that tar will not get other important t