Results 1 to 13 of 13

Thread: Learn by your mistakes

  1. Oct 29th, 2008, 05:58 AM #1
    I_Love_My_Vans
    I_Love_My_Vans is offline

    Thread Starter
    Frenzied Member I_Love_My_Vans's Avatar
    Join Date
    Jan 2005
    Location
    In the PHP compiler
    Posts
    1,275

    Learn by your mistakes

    I have just deleted numerous complex queries from my database.

    I am literally about to go nuts


    But no worries, because I haven't saved the SQL to any of them :@::@!!1!!one


    I think I have to say, Epic fail
    Reply With Quote Reply With Quote
  2. Oct 29th, 2008, 06:20 AM #2
    JPicasso
    JPicasso is offline
    Fanatic Member JPicasso's Avatar
    Join Date
    Aug 2001
    Location
    Kalamazoo, MI
    Posts
    843

    Re: Learn by your mistakes

    That's okay, now you can make it right with numerous in-line string concatenations in code!

    win!
    Merry Christmas
    Reply With Quote Reply With Quote
  3. Oct 29th, 2008, 06:25 AM #3
    homer13j
    homer13j is offline
    Lively Member homer13j's Avatar
    Join Date
    Nov 2003
    Location
    Ohio Turnpike Exit 173
    Posts
    80

    Re: Learn by your mistakes

    Reply With Quote Reply With Quote
  4. Oct 29th, 2008, 06:33 AM #4
    I_Love_My_Vans
    I_Love_My_Vans is offline

    Thread Starter
    Frenzied Member I_Love_My_Vans's Avatar
    Join Date
    Jan 2005
    Location
    In the PHP compiler
    Posts
    1,275

    Re: Learn by your mistakes

    I feel like a n00b, the thing is, after they had been deleted, I could still see the code, but because I didnt think they were deleted I refreshed the environment and poof, gone...
    Reply With Quote Reply With Quote
  6. Oct 29th, 2008, 07:07 AM #5
    FunkyDexter
    FunkyDexter is offline
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    7,957

    Re: Learn by your mistakes

    Ouch. Do you have a backup you can restore as a different instance? That way you could copy the queries across from your restored instance into your live instance.
    The best argument against democracy is a five minute conversation with the average voter - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd
    Reply With Quote Reply With Quote
  7. Oct 29th, 2008, 07:47 AM #6
    I_Love_My_Vans
    I_Love_My_Vans is offline

    Thread Starter
    Frenzied Member I_Love_My_Vans's Avatar
    Join Date
    Jan 2005
    Location
    In the PHP compiler
    Posts
    1,275

    Re: Learn by your mistakes

    There are backups on tapes, but retrieving them would not be easy.

    I am rewriting it as we speak, problem is, its not 100% as it was (obviously) and its returning loads of foreign error codes.
    Last edited by I_Love_My_Vans; Oct 29th, 2008 at 08:37 AM.
    Reply With Quote Reply With Quote
  8. Oct 29th, 2008, 08:15 AM #7
    Kasracer
    Kasracer is offline
    KrisSiegel.com Kasracer's Avatar
    Join Date
    Jul 2003
    Location
    USA, Maryland
    Posts
    4,985

    Re: Learn by your mistakes

    VSS, CVS, SVN, TFS, PICK YOUR POISON AND USE IT DAMMIT!

    I've learned the hard way. No more. I have my own server with SVN setup and nightly backups and I commit everything to it as soon as I'm done or if a lot of time has passed and I don't want to rewrite everything if something happens.
    KrisSiegel.com - My Personal Website with my blog and portfolio
    Don't Forget to Rate Posts!

    Free Icons: FamFamFam, VBCorner, VBAccelerator
    Useful Links: System.Security.SecureString Managed DPAPI Overview Part 1 Managed DPAPI Overview Part 2 MSDN, MSDN2, Comparing the Timer Classes
    Reply With Quote Reply With Quote
  9. Oct 29th, 2008, 08:28 AM #8
    I_Love_My_Vans
    I_Love_My_Vans is offline

    Thread Starter
    Frenzied Member I_Love_My_Vans's Avatar
    Join Date
    Jan 2005
    Location
    In the PHP compiler
    Posts
    1,275

    Re: Learn by your mistakes

    At the moment its only the database queries that has been affected. We do indeed have a backup, but I haven't committed my code in a little while, I am playing with fire here...
    Reply With Quote Reply With Quote
  11. Oct 29th, 2008, 08:54 AM #9
    I_Love_My_Vans
    I_Love_My_Vans is offline

    Thread Starter
    Frenzied Member I_Love_My_Vans's Avatar
    Join Date
    Jan 2005
    Location
    In the PHP compiler
    Posts
    1,275

    Re: Learn by your mistakes

    Backup completed now, I should do this more often...
    Reply With Quote Reply With Quote
  12. Oct 30th, 2008, 01:32 AM #10
    BillGeek
    BillGeek is offline
    Hyperactive Member BillGeek's Avatar
    Join Date
    Jun 2006
    Location
    Canada
    Posts
    440

    Re: Learn by your mistakes

    Pfffft.... real developers don't need backups. As a matter of fact, they don't even need a development environment. Just go straight to Production.




    And for those of you without a radar: Yes, I was being sarcastic...
    Reply With Quote Reply With Quote
  13. Oct 30th, 2008, 04:35 AM #11
    I_Love_My_Vans
    I_Love_My_Vans is offline

    Thread Starter
    Frenzied Member I_Love_My_Vans's Avatar
    Join Date
    Jan 2005
    Location
    In the PHP compiler
    Posts
    1,275

    Re: Learn by your mistakes

    Sounds like Windows
    Reply With Quote Reply With Quote
  14. Oct 30th, 2008, 07:35 AM #12
    Kasracer
    Kasracer is offline
    KrisSiegel.com Kasracer's Avatar
    Join Date
    Jul 2003
    Location
    USA, Maryland
    Posts
    4,985

    Re: Learn by your mistakes

    Quote Originally Posted by BillGeek
    Pfffft.... real developers don't need backups. As a matter of fact, they don't even need a development environment. Just go straight to Production.
    I had a job where all development was done in real time against the production server. To hide it everything would be duplicated and you'd have to set the query string variable Admin to 1 to see the new stuff. Heh.
    KrisSiegel.com - My Personal Website with my blog and portfolio
    Don't Forget to Rate Posts!

    Free Icons: FamFamFam, VBCorner, VBAccelerator
    Useful Links: System.Security.SecureString Managed DPAPI Overview Part 1 Managed DPAPI Overview Part 2 MSDN, MSDN2, Comparing the Timer Classes
    Reply With Quote Reply With Quote
  15. Nov 2nd, 2008, 02:53 PM #13
    dclamp
    dclamp is offline
    WiggleWiggle dclamp's Avatar
    Join Date
    Aug 2006
    Posts
    3,527

    Re: Learn by your mistakes

    Quote Originally Posted by homer13j
    i wonder how much some one paid him to hold that sign while they took that picture...

    Doesnt really matter, because he went to the liquor store and bought booze.... damn homeless people.
    My usual boring signature: Something
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width