Import : Append v Overwrite

MAC301's profile image MAC301 posted 11 years ago in General Permalink
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's profile image ansgar posted 11 years ago Permalink
Probably you enabled the option "Truncate destination table before import"?
MAC301's profile image MAC301 posted 11 years ago Permalink
Yes.. I probably did...OOOPs... does that me wipe out?
MAC301's profile image MAC301 posted 11 years ago Permalink
Yes.. I probably did...OOOPs... does that me wipe out?
ansgar's profile image ansgar posted 11 years ago Permalink
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.