14 Mar
2010
14 Mar
'10
1:43 p.m.
On Sun, March 14, 2010 10:37 am, Duane at e164 dot org wrote:
Doing semi-complete/complete backups via
rsync/rsnapshot is difficult
using a non-SU account.
Although if that's all you need root SSH access for you can always use the
'PermitRootLogin forced-commands-only' SSHD option.
Mathew
14 Mar
14 Mar
1:46 p.m.
New subject: The perils of opening tcp/22 to the Internet
On 14 March 2010 13:43, Mathew Newton <bitfolklist(a)newtonnet.co.uk> wrote:
On Sun, March 14, 2010 10:37 am, Duane at e164 dot org
wrote:
I'd have thought perhaps a better way of doing backups would be to
make the backup run locally then pull/push it to the destination
server. You can't easily do MySQL dump backups over SSH for example!
James
Doing semi-complete/complete backups via
rsync/rsnapshot is difficult
using a non-SU account.
Although if that's all you need root SSH access for you can always use the
'PermitRootLogin forced-commands-only' SSHD option. 
2:13 p.m.
New subject: mysqldump over SSH (Was: Re: The perils of opening tcp/22 to the Internet)
Hello,
On Sun, Mar 14, 2010 at 01:46:40PM +0000, James Gregory wrote:
You can't easily do MySQL dump backups over SSH
for example!
Well, mysqldump typically outputs to stdout so you can just pipe that
through SSH without issue. gzip it as well if you like:
mysqldump -u dbuser dbname | gzip -c --best --rsyncable | ssh dbbackup(a)example.com
'cat > /data/backup/dbbackup.sql.gz'
The usual problem with backing up a database *from* outside the box
it's on is that just copying the files on disk won't usually provide
a consistent (or in some cases, an at all usable) backup. But
mysqldump from the db host itself through SSH doesn't suffer from
that problem.
(it has some other problems)
Cheers,
Andy
--
http://bitfolk.com/ -- No-nonsense VPS hosting
2:21 p.m.
New subject: mysqldump over SSH (Was: Re: The perils of opening tcp/22 to the Internet)
Hi Andy,
mysqldump -u dbuser dbname | gzip -c --best
--rsyncable | ssh dbbackup(a)example.com 'cat > /data/backup/dbbackup.sql.gz'
Perhaps mysqldump wasn't the best example to use! Anyway, in your
example, you've show mysqldump on the local machine going to a remote
machine - not a problem. I thought the case being explained (when you
might have issue not being SU) was related to a remote machine SSHing
then doing the backup - that is where doing a local 'to disk' backup
then remote copy would be best I think.
James
2:28 p.m.
New subject: mysqldump over SSH (Was: Re: The perils of opening tcp/22 to the Internet)
Hello,
On Sun, Mar 14, 2010 at 02:21:41PM +0000, James Gregory wrote:
ssh dbbackup@dbhost 'mysqldump -u dbuser dbname | gzip -c --best --rsyncable'
> /data/backup/dbbackup.sql.gz
Sorry!
Cheers,
Andy
mysqldump -u
dbuser dbname | gzip -c --best --rsyncable | ssh dbbackup(a)example.com 'cat >
/data/backup/dbbackup.sql.gz'
Perhaps mysqldump wasn't the best example to use! Anyway, in your
example, you've show mysqldump on the local machine going to a remote
machine - not a problem. I thought the case being explained (when you
might have issue not being SU) was related to a remote machine SSHing
then doing the backup - that is where doing a local 'to disk' backup
then remote copy would be best I think.
5164
days inactive
5164
days old
4 comments
3 participants
participants (3)
-
Andy Smith -
James Gregory -
Mathew Newton