Re: 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 <phphelp@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 ------------