restore mysql record

I was having problems with contact form 7 in WordPress, so I removed it and reinstalled it. Unfortunately, that resulted in some data being erased in the table wp_posts. THat means I lost my forms that I previously had.

The site is hosted on godaddy, and I have access to the MySQL database via mysqladmin. Is there a way to undelete these records? I do not know if the records were erased permanently, or if there is a chance to unerase them (I was able to unerase records years ago when working with other databases, but I am not familiar enough with MySQL).

Thank you.
Lev SeltzerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

InsoftserviceCommented:
I hope godaddy keeps backup of data and mysql in its log file of one day (i don't know its one day or 1 week).
Check in your ftp account accordingly and replace with old one
At there end they keep backup of 1 week as same is done at my company we keep backup of client for one week
Lev SeltzerAuthor Commented:
The last backup was 368 days ago. Too old.
It seems that godaddy does NOT keep backup data.
That is what I wanted to try to undelete the record. In other databases, there is a bit that is set to true if the record is deleted, and one can undelete the record by changing this bit.
InsoftserviceCommented:
Did you contact them.
They won't charge if your data is not  so late.
Did you checked the log folder present in ftp

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Lev SeltzerAuthor Commented:
I didn't see any further backups, so I restored the 389 day backup and was fortunate enough to find what I needed.
Jason C. LevineDon't talk to me.Commented:
Lev,

Godaddy hosting is just awful for many reasons and backups are one of them.  Most other hosts of this size will do automatic 12 hour backups of both web and mysql files.  Food for thought.

Also, you can install plugins like BackupBuddy that can be set to backup your database on a regular interval and send the file to Dropbox or S3.  This is a good workaround when your host is unreliable.
Lev SeltzerAuthor Commented:
Thank you for the suggestion. I had purchased backupbuddy for a wordpress transfer, and didn't think about using it for this client, too (the client picked godaddy, and I was not in a position to get him to change it).
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
WordPress

From novice to tech pro — start learning today.