230 reputation
210
bio website tclayson.com
location Cambridgeshire, United Kingdom
age 24
visits member for 3 years, 10 months
seen Jul 11 '13 at 15:36

I am a professional mobile and web developer.


Jul
2
awarded  Curious
May
9
awarded  Popular Question
Apr
8
awarded  Popular Question
Mar
21
awarded  Notable Question
Sep
25
awarded  Popular Question
May
11
accepted Back up mysql server
May
11
comment Back up mysql server
Thanks for this. I reckon I could do it on the server and rsync it to the local machine. :) I need to find a way to retrieve a list of all the databases though and do one at a time. :) I'll look into that. Thanks mate. :)
May
10
awarded  Yearling
May
10
comment Back up mysql server
Ah, brilliant, thanks for the answer. :) Is there an easy way of looping through all the databases and backing up each one separately? Given that we may add new databases at any time (and take them away just as easily).
May
10
asked Back up mysql server
May
8
comment Give user permissions to all files and folders
Ok, I'm following I think. Adding that directive to the authorized_keys file will allow you to run a remote command with superuser permissions right? How would I change the command rsync -e ssh -az backups@domain.com:/home /location/of/local/folder in order to instruct it to run as superuser on the remote machine? Or will it do it automatically? Thanks for your time and help. :)
May
8
comment Give user permissions to all files and folders
Thanks for the edit dude. The only problem with that is that we cannot guarantee a static IP address where we are, and we want to do this via cron so that it just happens all the time. If we "push" it could stop working if our IP address changes. :/
May
8
comment Give user permissions to all files and folders
That looks pretty good thanks. Will that then rsync everything from the /backup/lc folder on the remote server? Do I change the path bit to be /home to get that to work?
May
8
comment Give user permissions to all files and folders
Yes we are thanks.
May
8
comment Give user permissions to all files and folders
This is basically the rsync command we are running: rsync -e ssh -az backups@domain.com:/home /location/of/local/folder
May
8
comment Give user permissions to all files and folders
That doesn't seem to have any effect. I assume because sudo on the local machine has no effect on the remote machine.
May
8
comment Give user permissions to all files and folders
@favadi I've already done that... still not working.
May
8
comment Give user permissions to all files and folders
@Phil I am trying to back up the whole /home directory. Files/directories that are failing are ones such as /home/a/c/account/users/mail:username which have permissions like drwx------ and owned by mail:4096. I assume that because user backups is in the group sudo or admin it doesn't have access because there are no access permissions for groups? I dunno, but its erroring on folders/files like that.
May
8
asked Give user permissions to all files and folders
May
8
comment Trying to create a cron to Rsync then tar the folder
This is a brilliant and insightful answer. Thank you very much for taking the time. :) You've really helped me. Thank you.