HELP - mysql file deletion mistake

Busy's picture

He has: 6,151 posts

Joined: May 2001

Help

I acidently dropped a database table in phpmyadmin (had two windows open, dropped wrong one) is there anyway to recover this file/folder?

It's on PC (localhost) I thought of the mysql data folder but XP hiccuped not long after I did it and closed all folders so there is no option to undo in the folder.

I really need this file/table back, even if it's only the structure, not so worried about the data.

Please someone have a magic cure for me, took me months to get it right and I can't remember everything that was in it Sad

And no one mention backups I had just finished redoing it and was about to test it then back up the database.

Mark Hensler's picture

He has: 4,048 posts

Joined: Aug 2000

I'm sorry, but I don't know of any.

Busy's picture

He has: 6,151 posts

Joined: May 2001

Was afraid of that answer Sad

thanks anyway

** anyone got a gun Sad **

mairving's picture

They have: 2,256 posts

Joined: Feb 2001

Is System Restore turned on in XP?

Busy's picture

He has: 6,151 posts

Joined: May 2001

mairving wrote: Is System Restore turned on in XP?

Probably not, haven't had XP that long and have been so busy with this project haven't had a decent look around yet. I have XP pro if it matters.

I had a look, it seems like its turned on, its giving me an option to either create a restore point or restore to an earlier time. The option to allow system restore is unchecked (allows it) so guess that is turned on.

mairving, have you ever used it (system restore), can I go back, say a day (probably two as its about 24hrs ago now), save the info to floppy then come back to now.
I was sent heaps of photos yesterday to edit that I can't save to floppy or zip disk and I dont have CD writer

He has: 1,758 posts

Joined: Jul 2002

I hope you learned a valuable lesson from this: Always make backups. Smiling

mairving's picture

They have: 2,256 posts

Joined: Feb 2001

You could try system restore although it seems like maybe that it only restores system files. Here is how to use it.

Busy's picture

He has: 6,151 posts

Joined: May 2001

Thanks, you may be right about just the system files thou

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.