Skip to main content
Added backup tag since mysqldump is restored from a backup
Link
RolandoMySQLDBA
  • 184.3k
  • 33
  • 323
  • 531
edited tags
Link
RolandoMySQLDBA
  • 184.3k
  • 33
  • 323
  • 531
Source Link

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?