[Leaplist] database backup tips?

[tom foster]

Hey Guys,

I want to backup some remote mysql databases on a
regular basis. I have dynamic dns set up (but no ssh
keys just yet).  How does this sound?

* dump the database to sql on the remote server.

* scp the sql to my computer.

* inject the sql into an empty database on my computer
  to make a local mirror of the site.

* wget (forcing an html extension) the site from the
  local version to a static local version so I can archive
  it on a cd or dvd sans database.

this is already what I've done in the past, but I'd
like to script it and let cron do the work.  The
problems I don't know how to solve:

* I don't know how to give mysql its password unless
  I'm typing it in by hand.

* I'm not sure on which machine to run the
  cronjob--remote, or local, or both?  one on the
  remote to dump and compress, one on the local to
  slurp and decompress and wget?

What's a better way, or how should I fix my way up so
that it can be done without my interaction?

Thanks!

--

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.