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
update not insert?
Moderator: jr
-
basementjack
- Posts: 8
- Joined: Tue Mar 30, 2010 8:48 pm
Re: update not insert?
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)
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)