in reply to Re: Re: Using mysql with perl
in thread Using mysql with perl

Another way is to write a small DBI script that connects to both DB's: your local one, and the internet one. The script then reads from your own local, and inserts everything into the other one.

The advantage is that you can use it anytime once you've written it once, and adjust it to work for any table you like.

Replies are listed 'Best First'.
Re: Re: Re: Re: Using mysql with perl
by Trimbach (Curate) on Jun 07, 2003 at 20:48 UTC
    Yes, but remember:
    1. If your local machine is behind a firewall (and, really, whose isn't?) then you have to punch a hole through your local firewall to allow the remote script to connect to your database.
    2. Unless you're using an SSL flavor of MySQL (4.x) or tunneling through SSH, you're transmitting your id, password, and data across an unsecure, unencrypted internet connection. Even if your data is uninteresting, it's not a good idea to let the World know the id and password to your exposed MySQL database.

    Other than that it's a great idea. :-) When dealing with an ISP it's much better just to SCP the data to your ISP, and load it that way.

    Gary Blackburn
    Trained Killer

[reply]

In Section Seekers of Perl Wisdom