mysql database backup by a single click with php [duplicate]

Question

Possible Duplicate:
PHP download backup of MySQL database

I want a one click database backup. backup can be saved as .sql or .zip or .txt file in a folder which I define.

my program runs in localhost(windows/xampp). how can I do this? — Imrul.H
– Imrul.H, Commented Dec 28, 2011 at 11:39
Click? Why do you want to have to click? If you're backing up - which is good - you want to do it regularly so automate it. — Ben
– Ben, Commented Dec 28, 2011 at 11:40

juergen d · Accepted Answer · 2011-12-28 11:41:34Z

0

I did the same thing in my C# app and started a console call of mysqldump like this:

mysqldump -u username --password=yourpass db_name > outputfile.sql

answered Dec 28, 2011 at 11:41

juergen d

205k40 gold badges304 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sharad D · Accepted Answer · 2011-12-28 11:38:29Z

-2

You can backup database or tables using phpMyAdmin

answered Dec 28, 2011 at 11:38

Sharad D

3291 silver badge11 bronze badges