Issue while taking backup of mysql database table using php script

Question

I am Trying to get backup of mysql database table using php script below but by executing this script it is creating the backup file but with no data in it .Any idea how to overcome this please help me out. enter image description here

Script

<?php

echo exec('mysqldump -u[root] -p[123456789] -h[localhost] [Android] [houseDetails] --where="addedDate=\'2013-11-22 09:17:28\'"> houseDetails.sql');

?>

in the flag --where you specify that you only want fields that have the exact date to be 2013-11-22 09:17:28. You might want to specify a date range or something like addedDate >= "2013-11-22 00:00:00" or --where="addedDate BETWEEN '2013-11-22 00:00:00' and '2013-11-23 00:00:00'" — Max
– Max, Commented Oct 10, 2014 at 9:03
And is your column name really addedDate or rather added_date? — Max
– Max, Commented Oct 10, 2014 at 9:05
still not getting records in file my column name is same that i had mention in my question. — Ricky
– Ricky, Commented Oct 10, 2014 at 9:06
please execute a select with the given where condition on your table and check if you get results........ — Vickrant
– Vickrant, Commented Oct 10, 2014 at 9:07
If you do not get results in your select then you will not get results here also. — Vickrant
– Vickrant, Commented Oct 10, 2014 at 9:07

Rajesh Ujade · Accepted Answer · 2014-10-13 05:53:31Z

1

Try this:

shell_exec("mysqldump -u root -ppassword db_name table_name --where=\"post_date in ('2011-12-15 06:14:55')\" > /tmp/test.sql");

edited Oct 13, 2014 at 5:53

Rajesh Ujade

2,73521 silver badges40 bronze badges

answered Oct 10, 2014 at 9:16

Vickrant

1,3312 gold badges9 silver badges15 bronze badges

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

5 Comments

Ricky Over a year ago

still generating empty file

Ricky Over a year ago

i am uploading database image so please check it

Vickrant Over a year ago

echo exec('mysqldump -u[root] -p[123456789] -h[localhost] [Android] [houseDetails] --where=" addedDate in ('2013-11-22 09:17:28')"> houseDetails.sql');

Vickrant Over a year ago

Try this: echo exec('mysqldump -u[root] -p[123456789] -h[localhost] [Android] [houseDetails] --where=" addedDate in ('2013-11-22')"> houseDetails.sql');

Ricky Over a year ago

Let us continue this discussion in chat.

Collectives™ on Stack Overflow

Issue while taking backup of mysql database table using php script

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related