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

I am a professional mobile and web developer.


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
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
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
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.
Apr
19
comment Backup from remote server
Quick question with rsync obvs I can create an ssh key and share it with the web server to get password-less entry to ssh right? Well, is this insecure? Is it bad if I use it for the root user? Or should I create a new user? If I create a new user for ssh will they have access to the /home dir (for rsync) or will I have to add them to a group which will have access? :p Sorry for all the questions! :) This kinda stuff isn't answered in all certainty on the net.
Apr
19
comment Backup from remote server
This is a brilliant answer, thank you! :) And well done for reading questions into my long post! haha.
Dec
9
comment Adding rules to my mail server
Ah genius! Thank you very much for the help and the info (and for googling for me!)
Dec
9
comment Adding rules to my mail server
haha... well thanks for the insight anyway. :) And thanks for all the tips and help.
Dec
9
comment Adding rules to my mail server
Yeah... I knew that... shifty eyes :p. I added the output to the question. Thanks :)
Dec
9
comment Adding rules to my mail server
502 unimplemented (#5.5.1)... not looking good I guess? :p haha
Dec
9
comment Adding rules to my mail server
Hey sachin, thanks for this, I've done that and posted the output above.
Dec
9
comment Adding rules to my mail server
Hey steve, I telnet'd and have posted the output above. Would this imply ESMTP? Thanks
Dec
9
comment Creating a local in-house testing web server
Thanks for this, this has been working for us. It doesn't feel "right", but it serves the purpose.