Remote FTP backup

"McWebber" <mcwebber.DeleteThis@my-deja.com> wrote in message
news:7BGdnVBuN5hrw5iiXTWJhQ@comcast.com...
 > "elyob" <newsprofile.DeleteThis@hotmail.com> wrote in message
 > news:W6dNa.1048$v26.7238794@news-text.cableinet.net...
  > > I'm looking to backup all my files on a remote server via FTP and wonder
 > if
  > > anyone has any idea what software allows me to backup the entire
 > directory?
 >
 > Depends on the server. Most likely the server has some zip method so you
can
 > have a Cron job zip up the /www directory and either push it to another
 > server or that server can grab the zip file.
 >

Yeah, unfortunately it'd take some time to setup .. and that would cost me.
I don't want certain temp folders, and would prefer control over it (my ISP
don't give telnet access).

Thanks though<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Remote FTP backup 

elyob wrote:

 > I'm looking to backup all my files on a remote server via FTP and wonder
 > if anyone has any idea what software allows me to backup the entire
 > directory?

Most ftp software allows it. I'm fond of ncftp client <http://ncftp.com/>,
which has ncftpget and ncftpput making it easy to write shell scripts to
handle uploading and downloading in the background.

--
David Dorward <a style='text-decoration: underline;' href="http://david.us-lot.org/" target="_blank">http://david.us-lot.org/</a>
Redesign in progress: <a style='text-decoration: underline;' href="http://stone.thecoreworlds.net/" target="_blank">http://stone.thecoreworlds.net/</a>
Microsoft announces IE is dead (so upgrade):
<a style='text-decoration: underline;' href="http://minutillo.com/steve/weblog/2003/5/30/microsoft-announces-ie-is-dead" target="_blank">http://minutillo.com/steve/weblog/2003/5/30/microsoft-announces-ie-is-dead</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Remote FTP backup 

"David Dorward" <dorward.RemoveThis@yahoo.com> wrote in message
news:be3n8r$9ho$2$8300dec7@news.demon.co.uk...
 > elyob wrote:
 >
  > > I'm looking to backup all my files on a remote server via FTP and wonder
  > > if anyone has any idea what software allows me to backup the entire
  > > directory?
 >
 > Most ftp software allows it. I'm fond of ncftp client <http://ncftp.com/>,
 > which has ncftpget and ncftpput making it easy to write shell scripts to
 > handle uploading and downloading in the background.
 >

That is exactly it ... fantastic. I can also write a php script that will do
command line backups .. great. Thanks a lot!

Now, can I do something similar with my MySQL database?! <!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Remote FTP backup 

"elyob" <newsprofile RemoveThis @hotmail.com> wrote in message
news:JxdNa.1071$lh6.7420039@news-text.cableinet.net...
 >
 > "David Dorward" <dorward RemoveThis @yahoo.com> wrote in message
 > news:be3n8r$9ho$2$8300dec7@news.demon.co.uk...
  > > elyob wrote:
  > >
   > > > I'm looking to backup all my files on a remote server via FTP and
wonder
   > > > if anyone has any idea what software allows me to backup the entire
   > > > directory?
  > >
  > > Most ftp software allows it. I'm fond of ncftp client
<http://ncftp.com/>,
  > > which has ncftpget and ncftpput making it easy to write shell scripts to
  > > handle uploading and downloading in the background.
  > >
 >
 > That is exactly it ... fantastic. I can also write a php script that will
do
 > command line backups .. great. Thanks a lot!
 >
 > Now, can I do something similar with my MySQL database?!
 >
 >

I have it working, though wonder if it's easy to save a folder and
sub-folders with a single command, and not knowing all the folder names?
(i.e. I save "/www/" and it will automatically find "/www/folder1/" and
"www/folder2/", without me knowing the folder1 & folder2 names ...)

Thanks<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Remote FTP backup 

"elyob" <newsprofile.DeleteThis@hotmail.com> wrote in message
news:_GdNa.1076$gd6.7365868@news-text.cableinet.net...
 >
 > "elyob" <newsprofile.DeleteThis@hotmail.com> wrote in message
 > news:JxdNa.1071$lh6.7420039@news-text.cableinet.net...
  > >
  > > "David Dorward" <dorward.DeleteThis@yahoo.com> wrote in message
  > > news:be3n8r$9ho$2$8300dec7@news.demon.co.uk...
   > > > elyob wrote:
   > > >
   > > > > I'm looking to backup all my files on a remote server via FTP and
 > wonder
   > > > > if anyone has any idea what software allows me to backup the entire
   > > > > directory?
   > > >
   > > > Most ftp software allows it. I'm fond of ncftp client
 > <http://ncftp.com/>,
   > > > which has ncftpget and ncftpput making it easy to write shell scripts
to
   > > > handle uploading and downloading in the background.
   > > >
  > >
  > > That is exactly it ... fantastic. I can also write a php script that
will
 > do
  > > command line backups .. great. Thanks a lot!
  > >
  > > Now, can I do something similar with my MySQL database?!
  > >
  > >
 >
 > I have it working, though wonder if it's easy to save a folder and
 > sub-folders with a single command, and not knowing all the folder names?
 > (i.e. I save "/www/" and it will automatically find "/www/folder1/" and
 > "www/folder2/", without me knowing the folder1 & folder2 names ...)
 >

Actually just figured it ... -r

I was downloading a directory with no sub-directories! Doh!<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Remote FTP backup 

elyob wrote:

 > That is exactly it ... fantastic. I can also write a php script that will
 > do command line backups .. great. Thanks a lot!

 > Now, can I do something similar with my MySQL database?!

mysqldump + cron can create a plain text file each day. Then you can
download it as per normal.

--
David Dorward <a style='text-decoration: underline;' href="http://david.us-lot.org/" target="_blank">http://david.us-lot.org/</a>
Redesign in progress: <a style='text-decoration: underline;' href="http://stone.thecoreworlds.net/" target="_blank">http://stone.thecoreworlds.net/</a>
Microsoft announces IE is dead (so upgrade):
<a style='text-decoration: underline;' href="http://minutillo.com/steve/weblog/2003/5/30/microsoft-announces-ie-is-dead" target="_blank">http://minutillo.com/steve/weblog/2003/5/30/microsoft-announces-ie-is-dead</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Remote FTP backup 

"elyob" <newsprofile DeleteThis @hotmail.com> wrote in message
news:JxdNa.1071$lh6.7420039@news-text.cableinet.net...
 >
 > "David Dorward" <dorward DeleteThis @yahoo.com> wrote in message
 > news:be3n8r$9ho$2$8300dec7@news.demon.co.uk...
  > > elyob wrote:
  > >
   > > > I'm looking to backup all my files on a remote server via FTP and
wonder
   > > > if anyone has any idea what software allows me to backup the entire
   > > > directory?
  > >
  > > Most ftp software allows it. I'm fond of ncftp client
<http://ncftp.com/>,
  > > which has ncftpget and ncftpput making it easy to write shell scripts to
  > > handle uploading and downloading in the background.
  > >
 >
 > That is exactly it ... fantastic. I can also write a php script that will
do
 > command line backups .. great. Thanks a lot!
 >
 > Now, can I do something similar with my MySQL database?!

I have a cron job (every night, 1 am) run a shell script "backup.sh" which
does something like this.... saves everything into a nicely packed .tgz
file

watch out for line wrapping in the dump command. it should all be on one
line

#!/bin/sh
mysqldump -uMYSQLUSERNAME -pPASSWORD --opt DATABASE >
/home/delaware/public_html/backups/BACKUPFILE.SQL

cd /home/delaware/public_html/backups
tar -czf data.tgz *.sql
rm *.sql


--
Jerry
<a style='text-decoration: underline;' href="http://www.whatevah.com" target="_blank">www.whatevah.com</a> / jerry at whatevah dot com
(spambait uce DeleteThis @ftc.gov )<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Remote FTP backup