Remote tar.gz with sql run local server

Question

Hi:

I have a tar.gz with a full mysql database update that I can access via ftp.

This tar.gz updates daily and I would like to create a php and/or mysql connection to that ftp account that would allow me to run that large sql query on my local mysql server.

Any thoughts?

Answer 1

First of all PHP supports reading from FTP out of the box, just use fopen with specified ftp protocol like so

<?php
$handle = fopen("ftp://user:[email protected]/somefile.txt", "w");
?>

then you will need to unzip the archive. Here File_Archive from Pear repository will come very handy

Answer 2

(I'm going to go out on a limb and assume you want to do this from a unix box of some kind...)

Throw this:

#!/bin/bash

wget                        \
    -O -                    \
    --ftp-user=username     \
    --ftp-password=password \
    "ftp://wherever/whatever.tar.gz" | tar xzOf - | mysql --user=whoever --password=secret dbname

in a file (update-db.sh for example) then chmod it:

chmod 755 update-db.sh

then you can just:

./update-db.sh

whenever you want to download the update. Or you can throw it into a cron job (man crontab).

Edit: Added the O flag to tar so that it extracts to stdout.