GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

mysqldump question between two dates

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysqldump question between two dates

    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:

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

    Comment

    Working...
    X