Backing up a database

Hi! I’m using Heidi SQL to access a database. It gives me several options when exporting a database, i.e.:

DELETE + INSERT (truncate existing data)
INSERT IGNORE (do not update existing)
REPLACE existing data

Can you please explain the differences between these options? Especially between the first one and the second one and the first one and the last one. Thanks :slight_smile:

here’s a suggestion:

create a small database, with, like, two or three tables, and populate a few rows into each table

then run the export for each of those options, and inspect the .sql files that are created

i heart heidisql, by the way


and i’ll be happy to answer your questions after you’ve tested each of those export options