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