0

Normally we Dump data in such manner:

What i require is i just want to dump data till yesterday !!!

mysqldump -u root -p gateway > dumpfilename.sql

sidhesh
  • 29
  • 1
  • 6

1 Answers1

1

You can pass -e parameter with query that should be executed:

mysqldump -u root -p troy22022012 -e "SELECT * FROM gateway WHERE ..." > dumpfilename.sql
tuffkid
  • 1,323
  • 9
  • 8
  • Thanks that worked.... tuffkid how to pass specified database name and from that table name using the same – sidhesh Apr 05 '13 at 12:47