wolstech Posted July 1, 2016 Posted July 1, 2016 @Marko30: The backup he just created cannot be used to fix his databases. The backup he just made will actually be missing his data...he just backed up the empty databases. The one he made now is only good for his restoring files and any databases that aren't damaged. It's better than nothing, but it's not a fix for his lost data. He needs a backup from before the data got lost (basically, he needs a backup made in the first week of June or before that). If he doesn't have that, the data is permanently lost.
Luigi123 Posted July 1, 2016 Author Posted July 1, 2016 I can't access my phpMyAdmin. Screenshot:1. https://www.dropbox.com/s/25062c1yq5004xv/Screen%20Shot%202016-07-01%20at%208.27.45%20AM.png?dl=0
wolstech Posted July 1, 2016 Posted July 1, 2016 Change your cPanel password (select "Synchronize MySQL Password"), then log out and in again.
Guest Marko30 Posted July 2, 2016 Posted July 2, 2016 @Marko30: The backup he just created cannot be used to fix his databases. The backup he just made will actually be missing his data...he just backed up the empty databases. The one he made now is only good for his restoring files and any databases that aren't damaged. It's better than nothing, but it's not a fix for his lost data. He needs a backup from before the data got lost (basically, he needs a backup made in the first week of June or before that). If he doesn't have that, the data is permanently lost.I know. I just thought that he has backup created before MySQL crash. Can @Krydos take a look for any backup on server?
wolstech Posted July 2, 2016 Posted July 2, 2016 Just wanted to make sure. The way he's phrasing it makes it sound like he thinks making a backup now can fix it.
Luigi123 Posted July 2, 2016 Author Posted July 2, 2016 When I upload my Backup File, it gives me an error. My Backup File is .tar.gz Screenshot:https://www.dropbox.com/s/xdrrpz11whlm51m/Capture.PNG?dl=0
Guest Marko30 Posted July 2, 2016 Posted July 2, 2016 When I upload my Backup File, it gives me an error. My Backup File is .tar.gz Screenshot:https://www.dropbox.com/s/xdrrpz11whlm51m/Capture.PNG?dl=0You can't restore empty database. To restore database you need backup file created before MySQL crashed. Maybe @Krydos can find older backup.
Guest Marko30 Posted July 2, 2016 Posted July 2, 2016 You should wait till Krydos checks if there is any backup on your account. If there's not, you have lost all the data from database and it cannot be restored. You should do website backup more often. Please provide your account username here so admins can find your account.
wolstech Posted July 3, 2016 Posted July 3, 2016 Escalating. @krydos: do we have any database backups for any databases on this account?
wolstech Posted July 3, 2016 Posted July 3, 2016 Well, that answers that...you'll need to start over In the future, please be sure to make regular backups of your account. If your data changes constantly, I would back up once a week. If not, I would suggest monthly.
Recommended Posts