And even quicker, staying on the RPI prompt, without copying to pc or manually editing:
# Remove first line of dumped database: tail dump.sql -n +2 > dump1.sql # Make back-up of original just in case: mv domoticz.db domoticz.bak.db # Import into fresh database: sqlite3 domoticz.db < dump1.sql ...