Re: [PHP-DB] MySQLDump through PHP/HTML UI

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 <[email protected]>
>> To: [email protected]
>> 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 ------------
>
>