distal-attribute
distal-attribute
distal-attribute
distal-attribute

Import : Append v Overwrite

MAC301 posted 2 years ago in General
I recently imported a cvs file that I "assumed" would append to my current tables ... to my surprise the overwrote the tables and it appears I lost all my prior data.

How do I just append or add to an existing Mysql table ?
ansgar posted 2 years ago
Probably you enabled the option "Truncate destination table before import"?
MAC301 posted 2 years ago
Yes.. I probably did...OOOPs... does that me wipe out?
MAC301 posted 2 years ago
Yes.. I probably did...OOOPs... does that me wipe out?
ansgar posted 2 years ago
Yes, think so. Newer versions do not store/restore the activation of that checkbox option, as it's just too critical.

Please login to leave a reply, or register at first.