If you can provide a DSN suitable to open the connection from your local machine, you could use that database. If you have shell access at your provider then you may be able to use the DBD::Proxy modules to open a connection locally there and proxy it out so you can see if from your local machine. I would be sure to do this over a secure channel ie. ssh or the encrypting variations of the proxy and make sure that no one else can use the proxy otherwise you open up a connection for anyone to query your data. I believe the proxy modules can be set up to allow read only access which would mitigate the risk to a large degree on the remote end

<remote-db> - <DBD::(rem db)> - <DBD::Proxy> #remote -> #local <DBD::Proxy> - <DBD::Access> - <Access>

The connection between the Proxy modules being read only from external. The Proxy's can have an encryption set up between them etc.

In reply to Re: Re: Re: Data export into text file by dga
in thread Data export into text file by b310

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.