Walter
|
| Posted: 07/17/2002, 1:30 PM |
|
Hi all,
I wonder if anyone can help me with this:
I am using mySQL and PHP w/templates on the host. I am using CCS to creat the php interface and am looking for a way that a visitor to the site can click a button that will do a data dump to his machine (from the host to the client) in a delimited format. I think mySQL dump will only dump to the host. Is that true? If anyone can help me with how I can do this I would appriciate it.
Thanks again,
Walter
|
|
|
 |
Rogers
|
| Posted: 07/17/2002, 3:39 PM |
|
One solution....the button clicked by the user could invoke a JSP page (or PHP, etc.) that calls mysqldump. Given I'm more familiar with JSP..in JSP, you'd invoke the Java method Runtime.exec to run mysqldump but there's likely a way to do the same with PHP. You'd want to invoke mysqldump in such a manner as to pipe the output to a file on your server. After invoking mysqldump, the JSP (PHP, etc.) page would return a link to the file to the user that they could click to download the mysqldump output.
Just a suggestion...might not be optimal depending on what you're looking for.
|
|
|
|
Ken
|
| Posted: 07/17/2002, 3:48 PM |
|
There is a perl script in Public Domain called Dump Manager. Look for it on Hotscripts or some other script collection site. This script is very nice and dumps to your local hard disk.
|
|
|
|
Walter
|
| Posted: 07/18/2002, 2:26 PM |
|
Thanks for the sugestions, I'll give them both a try.
Thanks again.
|
|
|
|
|
