[thelist] mysqlimport with 'ignore' to archive data

Canfield, Joel JCanfield at PacAdvantage.org
Thu Apr 20 11:01:47 CDT 2006

our phone records box will start overwriting old data when the primary
table hits 100K rows. to preserve historical data we need to write it
off to another table.

the phone box admin tools can be set up to automatically back up the db
on a schedule. on the slave side, would mysqlimport with the ignore
option be my best choice for importing all new records without touching
existing records?

thanks some more


More information about the thelist mailing list