Software needed for pushing files to ftp servers.

Napper · 11-27-2004, 11:35 AM

Hi everybody,

before I go to reinvent the wheel again, let me ask on _the_ forum

I wrote a need little PHP application that I have a small custumer base for. Since I keep developing that software I need to keep updating each customer installation (let us assume that I have their ftp access data). Now I could write a script that loads each the ftp access for each customer and sends all the (modified) files over to his/her server. However, maybe something like that (or even a nifty GUI app) already exists. Is anybody aware of such a program?

In hope for reply,

Napper.

sigsegv · 11-27-2004, 12:17 PM

This isn't really a direct answer but more a "this is how I mould do it" kind of thing.

Put each server's connect string in a file, one per line (like so)

Code:

ftp://username:password@host.com/path/to/your/file
ftp://username:password@host.com/path/to/your/file
...

then have a script that reads the file. Something like this

[code]
#!/bin/sh

for HOST in `cat /file/from/above`; do
ftp ${HOST} << !EOF!
bin
put yourPhpScript.php
bye
!EOF!
done

You could expand this to check the php script's mtime and run any time the file's been updated, then tie that into a cronjob. That way, you just edit the php script and cron merrily takes care of the work and sends you an email when it's done.

BTW -- GUIs suck for things like this. Like I always say "X is for browsing and a ton of (a|e|x)terms" ;)

Napper · 11-27-2004, 12:22 PM

Yeah what I thought. It's scripting time after all... Thanks for the start!!!

Napper

Napper · 04-02-2005, 06:57 AM

Hello again,
I am slowely progressing in the art of bash programming and wrote some simple backup scripts (inspired by your previous input). As I have to manage quite a few web sites that are located on remote hosts I was wondering if there was a way initiate a mysql backup of these remote databases. Essentially what the script should do is:

1) Log into the hosts MySql server
2) Dump the specified database
3) Write the file into a local (on my home computer, so to speak) folder

Is this possible with Bash?

Kind regards,

Napper

sigsegv · 04-02-2005, 07:42 AM

I'd do this in 2 scripts; one on the servers and one on your box.

The script on the server(s) should dump the databases and whatever else you want into a tarball (server1.mydomain.com-backup-20050402.tar.gz) on a disk with plenty of space to hold it.

The script on your box would just SCP the tarballs to your local HDD.

One of the two scripts should take care of cleaning out the old tarballs on both ends, otherwise you'll have to manually delete the old tarballs manually.

Napper · 04-02-2005, 07:47 AM

Makes sense. And the server side script would be in php right?

sigsegv · 04-02-2005, 02:20 PM

No. I'd jush use a shell script triggered by cron.

Code:

#!/bin/sh

# Get the date
# DATE=`date +"%Y%m%d"

# Dump the databases
# mysqldump <options> database | gzip - > /tmp/database_dump_$DATE.gz

You'll have to change it up for your situation of course.