Re: Updating DB Locally

From: Paige (noemail_at_hotmail.com)
Date: 06/21/04 

Date: Mon, 21 Jun 2004 02:28:42 GMT

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.

Relevant Pages

  • Re: Updating DB Locally
    ... >>I am the only one that changes the database entries. ... > etc.) but in practice it may be a disaster (lost updates). ... there is no writing done to the database on the server at ...
    (comp.lang.php)
  • 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)