Point in time forward MySQL Dump I have a MySQL table that stores a list of bookings that's made online. I need to have these bookings dumped to a CSV file which will then be picked up by a client server application through a SSH connection. Earlier we were dumping the entire table and so the CSV file had the transactions since beginning of time. Now we have to generate the dump several times in a day and the dump should contain only the newer records. Does my MySQL provide any options to generate a dump that contains only those records that were inserted after the last dump was taken?
If you know the time from where you need to start the backup then you can use mysqldump with --where clause like below to get the type of backup you are looking for 

mysqldump --user=username --password=password db_name table_name  --where=date_pulled &gt; '2014-07-21 16:25:00' &gt; backup.sql


You can also do like 

SELECT * FROM table_name 
WHERE date_pulled &gt; '2014-07-21 16:25:00'
INTO OUTFILE 'table_name.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'; 


You can create a simple automated script for this and change the date_pulled dynamically.

Have a look at below links that may help you as well

 Mysqldump in CSV format. 

How to output MySQL query results in csv format?