Re: Updating DB Locally

From: Michael Austin (maustin_at_firstdbasource.com)
Date: 06/21/04 

Date: Mon, 21 Jun 2004 03:30:02 GMT

Paige wrote:

> Michael Austin wrote:
>
>> Paige wrote:
>>
>>> I have a database on my local machine that I make entries and
>>> corrections on. I'd like to be able to upload that to my server and
>>> have that update the database that's on the server. What I've been
>>> doing is saving the local file as a backup. Then I have to edit the
>>> backup, deleting the create file info and all previously uploaded
>>> entries before I can import the text file to the server.
>>>
>>> Is there an easier way to do this so I won't get duplicate entry
>>> notices. I'd like the info from my local file to overwrite the server
>>> file like FTPing a new web page will overwrite the old one. Is this
>>> possible to do with mySQL?
>>>
>>
>> First, you have not given enough information to give you the proper
>> response.
>>
>> What platform (specifically the OS)
>
>
> Win XP
>
>> Are the corrections/changes DDL (table/column definitions) or DML
>> (insert/update/delete)?
>
>
> I guess they'd be DML. Nothing changes as to columns or definitions. The
> only thing that might change would be the info already stored in an
> entrylike if someone was to move and change their address, that sort of
> thing. And of course, the new version that I would want to upload would
> have more total entries than the old one.
>
>> Is the data in the database static (read w/occasional updates) or is
>> it a read/write database (new information stored daily).
>
>
> static
>
>> I take it that your "local machine" is a test system and the other is
>> "production"
>
>
> I guess that's a fair assessment. I want to do the work on my WinXP,
> then upload the table to the server to replace what is there so I don't
> have to be online when I want to work on the database.
>
>> If you do not care what is in your production database and it gets
>> over-written with the new version:
>
>
>> Backup/Restore your database from one place to another...
>>
>> http://www.phpbb.com/phpBB/viewtopic.php?t=9963
>
>
> Thank you for this suggestion and maybe it's me but this thread seems to
> involve backing up and restoring phpbb databases on a *new* server/host.
> If that was my situation, I would have no problem as there would be no
> entries on the new server so there couldn't be any duplicate ones in the
> upload. But it's the same table on the same server that I'm looking to
> do with the new one overwriting the old one.
>

If users of the "production" database can change their information and
you make different changes to your "local" database, then you must
guarantee that one does not overwrite the other. Basically you need to
be able to synchronize your databases not overwrite them... true? Next
question is this just one table or multiple tables?

Michael.

Relevant Pages

  • Re: Can I set relative paths for linked tables instead of absolute path?
    ... way to run the Access file to get it to connect itself. ... sure the connection is pointed correctly before you upload. ... When I upload the database to the server, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Updating DB Locally
    ... >> upload would have more total entries than the old one. ... >> there would be no entries on the new server so there couldn't be any ... > be able to synchronize your databases not overwrite them... ... I am the only one that changes the database entries. ...
    (comp.lang.php)
  • Re: HELP Access DB, ASP.NET 2.0 and whole lot of pain
    ... The new Sql Server 2005 is supposed to be great for storing files! ... >> Are you trying to store the file in your Access database? ... >>> In my Web App i have an upload feature and I've discovered that if i ... >>> spent writing to the Access Database.. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Document mangment in .net
    ... user will upload the document form here. ... uploaded from the client to the webserver server over a webservice. ... the user machine and database sitting on the webserver and webservices being ...
    (microsoft.public.dotnet.framework)
  • Re: Updating DB Locally
    ... >> have that update the database that's on the server. ... >> entries before I can import the text file to the server. ... the new version that I would want to upload would ...
    (comp.lang.php)