Re: mysqldump

Hi buttoz Here's how I did it ... function get_script($dbname) { $cmd = "/usr/bin/mysqldump -u"._DBUSER." -p"._DBPASS." "._MDFLAGS." ".$dbname; $script = $cmd; return $script; } _MDFLAGS is a constant which holds the flags you want to pass to mysqldump ... I commonly use -c and -add-drop-table. _DBUSER and _DBPASS are also constants containing the username and password mysqldump needs to connect to mysql with (funnily enough!!). Note there is NO space between the -p flag and the password. HTH Ronan e: ronan@thelittledot.com t: 01903 739 997 w: www.thelittledot.com The Little Dot is a partnership of Ronan Chilvers and Giles Webberley On 31 May,2003 at 12:51 buttoz buttoz wrote: > hi, > > i want to backup mysql database. > i use mysqldump command . > when i use this command from server (win2000) , command promt its work fine. > but when run this command (mysqldump) from php file, it creat backup file > but > with zero size. > > what can i do , help me? > > thanks, > zuhear > > >