[thelist] MySQL export for non-technical client

Frank framar at interlog.com
Sat Oct 19 16:54:01 CDT 2002


At 01:37 PM 10/19/2002 -0700, you wrote:

 > What's the simplest way for a non-technical client to
 > obtain the contents of a MySQL database? The only option I
 > can see is screen scraping, since they can display the
 > entire contents on a web page.

If this is something that the client will do on a regular basis, that it
might be simplest to write up a script in the language of your choice to
export the documents in either CSV format (that they can import into
Excel), plain old text files, or HTML files. The user only need access a
web document.

Ah! but wait! "Only accessed via SSH". Write  a shell script for them.
Perhaps write a shell script that will write a file, place it in a text
document (format of your choice), and email it to them. This should be doable.

I'm not sure if "simplest" is primarily for you, or for the client.



--
Frank Marion <frank at frankmarion.com>      Tel: 416 825 7488




More information about the thelist mailing list