one more thing, I tried the same thing on command promt & it works fine. FYI I m using IIS server on winXP. On Wed, May 28, 2008 at 10:31 AM, aslam doctor <aslam.doctor@xxxxxxxxx> wrote: > Hey thanks for your response, I tried it but still not working, even I > tried echoing the exec statement as Robert said but it generates blank > Backup.sql file :( > > > > > > On Tue, May 27, 2008 at 10:49 PM, José Miguel Santibáñez A. <jms@xxxxxxxxx> > wrote: > >> >> > I tried it, but it is just generating a blank .sql file see this code I >> > used >> > >> > exec("mysqldump -h localhost -u root -p testdatabase > Backup.sql"); >> >> you need put the pass for root user of mysql. >> you need give permissions to apache (user for php) can write on "." >> folder. >> >> look at your apache error log to identify another messages, but i sugggest >> to use full options >> > > >> >> >> mysqldump --host=localhost --user=root --password=passforroot \ >> --lock-tables --quick --extended-insert --complete-inserts \ >> --database=testdatabase --result-file=Backup.sql >> >> regards, >> >> -- >> José Miguel Santibáñez >> jms@xxxxxxxxx >> >> ------------------------------------ >> >> Are you looking for a PHP job? Join the PHP Professionals directory Now! >> http://www.phpclasses.org/professionals/Yahoo! Groups Links >> >> >> >> > > > -- > A.M.Doctor -- A.M.Doctor [Non-text portions of this message have been removed]