mysqldump question between two dates

Polyglot Projects Other Tools
1

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…

2

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


"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"