Hi, Rick - - -
Well, there really is not a lot to tell. Yes, it is being prompted by
a HTML page. I show the table names with checkboxes or an "all."
As a result, I build the simplest 'dump" statement;
mysqldump databasename>path/outfilename,sql --tables --
user=dunknob --password=doorknob
Anyway, it did turn out to be a permissions problem, so marked this
one with a big SOLVED. it didn't smell like one, however, as the file
was being written, the "dump' heading lines were there, just the
parameters were ignored.
Ah, well ----
Thanks for your suggestions.
Ken
On Dec 10, 2008, at 9:42 PM, lists-php wrote:
you don't give a lot of information of how you are running your
utility, but you're likely to run into file permission issues in a
linux context that you won't have in a windoz one.
if you're running it through a web page you'll be trying to write
the dump file as the user that your web server runs under (by
default "apache"). generally (and in a secure setup) that user will
not have the ability to write to files under the documentroot.
- Rick
------------ Original Message ------------
Date: Wednesday, December 10, 2008 09:25:37 PM -0600
From: phphelp -- kbk <phphelp@xxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: Re: MySQLDump through PHP/HTML UI
Hi, Chris -- -- -- --
Yes, thanks for the suggestion: it runs from the command line just
fine. I run them often, and it works in Windows.
However, I just was able to gain access again to the error log
(long story), and I see that the page is throwing an unrelated
error that it does not throw in Windows. I will run down that road
and see if that error is somehow getting in the way.
Thank you for your ideas.
Ken
On Dec 10, 2008, at 3:50 PM, Chris wrote:
phphelp -- kbk wrote:
Hello - - -- -
I have a utility which creates a MySQLDump of selected tables or
the whole database. This works fine on my development machine,
a W2K box. It does not work on the testing server, a linux box.
I'll post code if you want, but it is very simple:
1. I create the "dump" language, including the file into which
the data is dumped into a variable.
2. I perform system($dump_language). I also tried it exec
($dump_language). Both produce the same result:
What cmd are you putting together (I assume something for
mysqldump)? If you run it manually from the cmd line, does it
work? Does it give an error?
--
Postgresql & php tutorials
http://www.designmagick.com/
------------ End Original Message ------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
