SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict itsource's Avatar
    Join Date
    Jun 2001
    Location
    Thailand
    Posts
    369
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    recover data in mysql

    I have table that contain data about 30 rows in table. I want to update data only 1 rows and I write php script to update data in mysql.

    I use "update mytable set ....... ";
    but I'm forgot "where id=2" ,
    so all rows in table was update. I don't backup database.

    How can I recover all data in table?
    Is any way such as Undo command or using logfile?
    Last edited by itsource; Mar 4, 2002 at 15:54.
    I live in Thailand. My English grammar not well.

  2. #2
    PHP warrior dkode's Avatar
    Join Date
    Sep 2001
    Location
    Planet Namek
    Posts
    329
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i don't beleive so. once you make a change to a table (update) there is no going back.
    "Mankind cannot define memory, yet it defines mankind"
    -- Project 2501, Ghost in the Shell

    Smarty | PEAR | PHP Manual | MySQL Manual


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
  •