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 databasenamepath/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 phph...@comcast.net
To: php-db@lists.php.net
Subject: Re: [PHP-DB] 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