mysqldump has a
--where option. Assuming you have some sort of toehold to figure out what the last 1000 inserted records are (for instance, an auto-increment field called
id), you should be able to tack that onto the
mysqldump command, like so:
mysqldump --where "1=1 ORDER BY id DESC LIMIT 1000" DB_NAME TBL_NAME
1=1 is necessary because the "WHERE" keyword is inserted into the query automatically, so you do have to give it some SQL to evaluate.
EDIT: There was an anonymous edit made to this response removing the space between --where and "1=1, saying that the command errored without a space. I just tested and it works with the space and errors without the space, unsure what the editor was seeing.
The error when leaving the space out:
mysqldump: unknown variable 'where1=1 ORDER BY UserID DESC LIMIT 1000'