SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Hybrid View

  1. #1
    SitePoint Evangelist
    Join Date
    Mar 2011
    Location
    Bellingham, WA
    Posts
    450
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Updating Local Database during testing

    Hello!

    I'm at the point in the development of my first dynamic website where I'm going back and forth between my local testing server and my site up on the Great World Wide Web. I successfully uploaded my "test" database from my computer up to the internet. My question, that I'm hoping someone can answer is how to I can go the other way. In particular, my internet database name is "kreut" while my local database name is "algebrabook". Is there a way that I can overwrite anything in my algebrabook database with my new entries that I put up on the web; both databases have the same exact table names and structures.

    Thanks so much,

    Eric

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,021
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    sure there's a way

    extract the data from your web database, reformatting it if necessary into INSERT statements, then execute the sql file against your local database after having deleted all the rows in your local database

    in mysql this is fairly trivial, because the dump utility program uses INSERT statements by default

    what system are you using? i think i recall from one of your earlier threads that it's microsoft access, in which case you could just copy the entire .mdb file and overwrite your local file
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Evangelist
    Join Date
    Mar 2011
    Location
    Bellingham, WA
    Posts
    450
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Exactly what I' needed...and I think that you did in fact help me with a Query not too long ago!

    -Eric

    PS it's MySql that I'm using.

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,021
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    FYI please note we have a Databases forum and a MySQL forum, and if you're using MySQL you really should post there -- the Databases forum is for all the others

    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •