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

What PHP-function/command are you using to invoke the mysqldump command?

Try including a flush() statement right before you start dumping. I don't 
know why it works, but it's solved some of my problems in the past. Must be 
something with buffer management.

hth,

Yves

----- Original Message ----- 
From: "Ken Kixmoeller.com" <[email protected]>
To: <[email protected]>
Sent: Wednesday, December 10, 2008 11:38 AM
Subject: Re: [PHP-DB] MySQLDump through PHP/HTML UI


> Merci, Yves - --
>
> It takes the blink of an eye. It seems like none of the string is  running 
> at all.
>
> Also, yeah, the slashes thing used to trip me up, too, when I first 
> started working around Linux boxes. However, the file *is* being  created 
> and it is in the right place, just nothing in it.
>
> Ken
>
> On Dec 10, 2008, at 9:43 AM, Yves Sucaet wrote:
>
>> Hi Ken,
>>
>> How long does the mysqldump operation last? Maybe it's a script  timeout 
>> problem? And maybe you have different settings on both  machines?
>>
>> Other idea: what about pathnames? Linux uses "/" to separate paths, 
>> Windows uses "\".
>>
>> That's all I have for now,
>>
>> Yves
>>
>>
>> ----- Original Message ----- From: "phphelp -- kbk" 
>> <[email protected]>
>> To: <[email protected]>
>> Sent: Wednesday, December 10, 2008 9:32 AM
>> Subject: [PHP-DB] MySQLDump through PHP/HTML UI
>>
>>
>>> 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:
>>>
>>> The file is created (the directory is one for which the  application 
>>> has r/w rights). In Windoze, the file is complete and  perfect. On the 
>>> Linux box, only the header information of the  dump file is written, 
>>> nothing about any database or table.
>>>
>>> Any ideas?
>>>
>>> Thank you,
>>>
>>> Ken
>>>
>>> -- 
>>> PHP Database Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>
>>
>>
>> -- 
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
>
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>