Solved

restore mysql record

Posted on 2014-11-03
6
159 Views
Last Modified: 2014-11-03
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.
0
Comment
Question by:Lev Seltzer
  • 3
  • 2
6 Comments
 
LVL 15

Expert Comment

by:Insoftservice
ID: 40419281
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
0
 

Author Comment

by:Lev Seltzer
ID: 40419286
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.
0
 
LVL 15

Accepted Solution

by:
Insoftservice earned 500 total points
ID: 40419291
Did you contact them.
They won't charge if your data is not  so late.
Did you checked the log folder present in ftp
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Closing Comment

by:Lev Seltzer
ID: 40419557
I didn't see any further backups, so I restored the 389 day backup and was fortunate enough to find what I needed.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 40419662
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.
0
 

Author Comment

by:Lev Seltzer
ID: 40419803
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).
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Do you think that WordPress is just for blogs?  Think again!  WordPress is really a fantastic all around platform that you can use to develop websites on.  Integrated into its basic functionality is the ability to create pages using your choice of a…
In Part I (http://www.experts-exchange.com/Web_Development/Blogs/WordPress/A_8410-Getting-Started-In-WordPress-Part-I.html), I introduced you to the powerful WordPress backend, the WordPress administrative Dashboard.  In Part II, I will introduce yo…
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

930 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

15 Experts available now in Live!

Get 1:1 Help Now