# mysqldump question between two dates

**URL:** <https://forums.percona.com/t/mysqldump-question-between-two-dates/3512>\
**Category:** Other Tools\
**Created:** [May 29, 2014, 7:45am UTC](https://forums.percona.com/t/mysqldump-question-between-two-dates/3512 "2014-05-29T07:45:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![banumathi](https://avatars.discourse-cdn.com/v4/letter/b/ce73a5/32.png) [@banumathi](https://forums.percona.com/u/banumathi)\
**Post date:** [May 29, 2014, 7:45am UTC](https://forums.percona.com/t/mysqldump-question-between-two-dates/3512/1 "2014-05-29T07:45:24Z")

</div>

hi

mysqldump using where condition for between two dates… if you know pls give proper syntax for this…

I used bellow code…It does’t work properly,

“C:/Program Files/MySQL/MySQL Server 5.0/bin/mysqldump -t -h localhost --force -f -u root -psa pts user\_master --where=entry\_date=BETWEEN’2014-05-11’and’2014-05-15’ -r D:\backup.sql”

i use this code getting database backup by java coding…

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [May 29, 2014, 12:58pm UTC](https://forums.percona.com/t/mysqldump-question-between-two-dates/3512/2 "2014-05-29T12:58:23Z")

</div>

Likely a quote issue, as you need quotes surrounding your WHERE clause:

```auto

"C:/Program Files/MySQL/MySQL Server 5.0/bin/mysqldump -t -h localhost --force -f -u root -psa pts user_master --where=\"entry_date=BETWEEN'2014-05-11'and'2014-05-15'\" -r D:\\backup.sql"

```