Re: MySQLDump through PHP/HTML UI

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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" <ken@xxxxxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Sent: Wednesday, December 10, 2008 11:38 AM
Subject: Re:  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" <phphelp@xxxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Sent: Wednesday, December 10, 2008 9:32 AM
Subject:  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





--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux