This is an archived, read-only copy of the United-TI subforum , including posts and topic from May 2003 to April 2012. If you would like to discuss any of the topics in this forum, you can visit Cemetech's
Technology & Calculator Open Topic subforum. Some of these topics may also be directly-linked to active Cemetech topics. If you are a Cemetech member with a linked United-TI account, you can link United-TI topics here with your current Cemetech topics.
Computer Tech Support =>
Technology & Calculator Open Topic
| Author |
Message |
|
Newbie
Bandwidth Hog
Joined: 23 Jan 2004
Posts: 2247
|
 Posted: 03 Oct 2008 02:29:37 pm Post subject: |
|
|
Curious. Is there such a thing as undo delete in mysql? I accidentally deleted 20 records in a table and need them back.
Nevermind I'll just have to bite the bullet on this and learn to backup my databases daily.
Last edited by Guest on 03 Oct 2008 04:39:34 pm; edited 1 time in total |
|
| Back to top |
|
|
pugboy
Active Member
Joined: 11 Apr 2007
Posts: 544
|
| Posted: 03 Oct 2008 09:49:00 pm Post subject: |
|
|
Just for future reference, no, there is no way to undelete  |
|
| Back to top |
|
|
AlienCC
Creative Receptacle!
Know-It-All
Joined: 24 May 2003
Posts: 1927
|
| Posted: 19 Oct 2008 12:05:52 pm Post subject: |
|
|
If you were using a "real" database with transaction logs, and had rolled your delete statement into a transaction then you would be able to roll your entire database back to where it was before you deleted those rows.
Having said that, welcome to mysql the toy database. |
|
| Back to top |
|
|
NETWizz
Byte by bit
Bandwidth Hog
Joined: 20 May 2003
Posts: 2369
|
| Posted: 04 Nov 2008 11:39:20 pm Post subject: |
|
|
Are the MySQL table files hosted on a drive that has Volume Shadow Services running?
If it does, you can stop the service and roll back the database files from volume shadow services. If not, you are SOL |
|
| Back to top |
|
|
|
Register to Join the Conversation
Have your own thoughts to add to this or any other topic? Want to ask a question, offer a suggestion, share your own programs and projects, upload a file to the file archives, get help with calculator and computer programming, or simply chat with like-minded coders and tech and calculator enthusiasts via the site-wide AJAX SAX widget? Registration for a free Cemetech account only takes a minute.
»
Go to Registration page
