Undo upate command of mysql database

Posted on 2006-03-25
Last Modified: 2010-08-05
Hi there,        

I have accidentally updated my mysql table in all the rows, while my intension was just to update one row. I need help to undo the update command and get my old data back. Thanks a lot.
Question by:idOle
    LVL 28

    Assisted Solution

    If you dont have a backup file somewhere I'm affraid you are out of luck.

    LVL 30

    Expert Comment

    I agree with gamebits.  Hopefully, you have a backup.  This is also one reason to use transactional tables (InnoDB) and work with autocommit off - so you can rollback changes.  Sorry there's not a better answer.

    Author Comment

    Would you please tell me how to turn autocommit off, since I just change my table to type InnoDB. Thanks.
    LVL 30

    Accepted Solution


    There's some good information on transactions that you will want to read here:
    LVL 30

    Expert Comment

    Thanks for the points - sorry there isn't a better answer.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Suggested Solutions

    Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (, A SQLite Tidbit: Quick Numbers Table Generation (…
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    This video discusses moving either the default database or any database to a new volume.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now