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

Import : Append v Overwrite

User, date Message
Written by MAC301
2 years ago
Category: General
8 posts since Sun, 21 Oct 12
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 ?
Written by ansgar
2 years ago
4973 posts since Fri, 07 Apr 06
Probably you enabled the option "Truncate destination table before import"?
Written by MAC301
2 years ago
8 posts since Sun, 21 Oct 12
Yes.. I probably did...OOOPs... does that me wipe out?
Written by MAC301
2 years ago
8 posts since Sun, 21 Oct 12
Yes.. I probably did...OOOPs... does that me wipe out?
Written by ansgar
2 years ago
4973 posts since Fri, 07 Apr 06
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.