Not sure if many ppl here use navicat, but I am somewhat confused by the way data entries are handled through my page and how that interacts with my local db server and my remote db server. For example, at work I am sometimes working on cfm templates on my laptop, and sometimes I'm working on my desktop with the same cfm templates. Now I realize, since I have navicat on my laptop as well as my desktop, that those are two different localhost and DB servers, but both instances are connected to my remote DB server and therefore I would think update the remote database simultaneously. It doesnt seem to be the case. Also, maybe I'm confused about this as well, but when I view my tables in navicat, shouldnt they be the latest version FROM the remote server? I know one day last week I entered 30 or so new records through my webpage remotely, but the records didnt show up when I viewed the table with navicat. Do I need to manually "get" the updated database from the remote DB server? or should this be something that is automatic? Please can someone give me some pointers on this issue? Thanks in advance!
teedoff
3
Posting Pro
Recommended Answers
Jump to PostI use navicat too. If your connections are the same at work and home then they both connect to the same database. If you connect to localhost and the user/password are the same (at work and at home), then they will connect to the database where you are locally. This …
Jump to PostYou would need some synchronization scheme. If you want to do it with navicat, it has a data synchronization option.
All 7 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
teedoff
3
Posting Pro
teedoff
3
Posting Pro
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
teedoff
3
Posting Pro
teedoff
3
Posting Pro
Ericklewis
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.