SitePoint Sponsor

User Tag List

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

    ButterFingers and Futzing with the database

    Hello!

    Two unrelated questions:

    1) I just accidentally "Dropped" one of my local Database tables. So that this won't happen again, I revoked my privileges so that in order to drop a table, I'd first have to change the privileges back, minimizing a chance of an accident.

    I'm using GoDaddy to host my site, and I can't seem to find how I can do the same thing with my remote database. Any thoughts would help.

    2) What happens to a user who is trying to input data into my database that's on a remote server if I'm "in it" at the same time? In other words, if I'm updating or making some sort of change manually.

    Thanks so much!

    -Eric

  2. #2
    Utopia, Inc. silver trophy
    ScallioXTX's Avatar
    Join Date
    Aug 2008
    Location
    The Netherlands
    Posts
    9,031
    Mentioned
    152 Post(s)
    Tagged
    2 Thread(s)
    1) If you're using shared hosting you probably don't have the privileges to drop tables, so I wouldn't worry about it too much.

    2) There are several scenarios here.

    2a) Working on different data
    If person A and person B are working on unrelated data, or person A is issuing insert queries while person B is issuing update quer/ies (or vice versa) there is no problem; this will work flawlessly.

    2b) Working on the same data
    If person A and person B both update the same data the one who fires the update query last wins, since that update query will overwrite the changes from the former update query.

    Does that answer your question?
    Rémon - Hosting Advisor

    Minimal Bookmarks Tree
    My Google Chrome extension: browsing bookmarks made easy

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

    Thank you....

    -Eric


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
  •