Page 1 of 1

update not insert?

Posted: Sun Aug 01, 2010 4:10 pm
by muscle_tech
Hey guys every time it connects it drops all in restarts with the new..is it possivble that it can update and add whats missing?

un uncheck the fisrt box drop and recreat destination

but it still says creating tablexx in the comments when done

Re: update not insert?

Posted: Fri Oct 08, 2010 6:32 am
by basementjack
This is more of a programming issue.
for example bullzip won't know what data you have so it would not know what records to update vs insert.

You might be better off importing the whole table into a temp area in mysql, then doing an update query from the temp to the production.
using this method, you can also query changes (IE see all records being updated or see all records being added)