mysql - mysqldump command in linux till date(I mean i dont want to dump changes in the database that i made today) -


normally dump data in such manner:

what require want dump data till yesterday !!!

mysqldump -u root -p gateway > dumpfilename.sql

you can pass -e parameter query should executed:

mysqldump -u root -p troy22022012 -e "select * gateway ..." > dumpfilename.sql 

Comments

Popular posts from this blog

monitor web browser programmatically in Android? -

Shrink a YouTube video to responsive width -

wpf - PdfWriter.GetInstance throws System.NullReferenceException -