Hi Dr.Aslam,
Try the following:
system("mysqldump --user=root --password=pwd db_name > backup.sql");
Thanks & Regards
Udayakumar Sarangapani
Sr. PHP Developer
CompIndia Infotech Pvt. Ltd.
Chennai.
"Science is nothing but logic..."
----- Original Message ----
From: aslam doctor <aslam.doctor@xxxxxxxxx>
To: php-objects@xxxxxxxxxxxxxxx
Sent: Tuesday, 27 May, 2008 4:37:34 PM
Subject: Re: PHP DATABASE BACKUP SYSTEM
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") ;
On Tue, May 27, 2008 at 3:48 PM, Atkinson, Robert <ratkinson@tbs- ltd.co.uk>
wrote:
> Native MySQL backup utility
> (http://dev.mysql. com/doc/refman/ 5.0/en/mysqldump .html) :-
>
> <?php exec("mysqldump [options] db_name [tables]"); ?>
>
> Rob.
>
> -----Original Message-----
> From: php-objects@ yahoogroups. com [mailto:php-objects@ yahoogroups. com] On
> Behalf Of aslam doctor
> Sent: 27 May 2008 06:27
> To: php-objects@ yahoogroups. com
> Subject: PHP DATABASE BACKUP SYSTEM
>
> I want to put a database backup system into my website. I don't want to use
> phpMyAdmin for that.
> Any suggestion or reference for that?
>
> Thnks in Advance.
>
> --
> A.M.Doctor
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------ --------- --------- ------
>
> Are you looking for a PHP job? Join the PHP Professionals directory Now!
> http://www.phpclass es.org/professio nals/Yahoo! Groups Links
>
>
>
>
>
> ************ ********* ********* ********* ********* ********* ********* ********* ********
> Any opinions expressed in email are those of the individual and not
> necessarily those of the company. This email and any files transmitted with
> it are confidential and solely for the use of the intended recipient
> or entity to whom they are addressed. It may contain material protected by
> attorney-client privilege. If you are not the intended recipient, or a
> person responsible for delivering to the intended recipient, be advised that
> you have received this email in error and that any use is strictly
> prohibited.
>
> Random House Group + 44 (0) 20 7840 8400
> http://www.randomho use.co.uk
> http://www.booksatt ransworld. co.uk
> http://www.kidsatra ndomhouse. co.uk
> Generic email address - enquiries@randomhou se.co.uk
>
> Name & Registered Office:
> THE RANDOM HOUSE GROUP LIMITED
> 20 VAUXHALL BRIDGE ROAD
> LONDON
> SW1V 2SA
> Random House Group Ltd is registered in the United Kingdom with company No.
> 00954009, VAT number 102838980
>
> ************ ********* ********* ********* ********* ********* ********* ********* ********
>
>
> ------------ --------- --------- ------
>
> Are you looking for a PHP job? Join the PHP Professionals directory Now!
> http://www.phpclass es.org/professio nals/Yahoo! Groups Links
>
>
>
>
--
A.M.Doctor
[Non-text portions of this message have been removed]
Best Jokes, Best Friends, Best Food and more. Go to http://in.promos.yahoo.com/groups/bestofyahoo/
[Non-text portions of this message have been removed]
