wolstech Posted July 1, 2016 Share 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. Link to comment Share on other sites More sharing options...
Luigi123 Posted July 1, 2016 Author Share 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 Link to comment Share on other sites More sharing options...
wolstech Posted July 1, 2016 Share Posted July 1, 2016 Change your cPanel password (select "Synchronize MySQL Password"), then log out and in again. Link to comment Share on other sites More sharing options...
Guest Marko30 Posted July 2, 2016 Share 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? Link to comment Share on other sites More sharing options...
wolstech Posted July 2, 2016 Share 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. Link to comment Share on other sites More sharing options...
Luigi123 Posted July 2, 2016 Author Share 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 Link to comment Share on other sites More sharing options...
Guest Marko30 Posted July 2, 2016 Share 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. Link to comment Share on other sites More sharing options...
Luigi123 Posted July 2, 2016 Author Share Posted July 2, 2016 So, what should I do? Link to comment Share on other sites More sharing options...
Guest Marko30 Posted July 2, 2016 Share 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. Link to comment Share on other sites More sharing options...
Luigi123 Posted July 2, 2016 Author Share Posted July 2, 2016 Do you mean my cPanel Username? Link to comment Share on other sites More sharing options...
wolstech Posted July 2, 2016 Share Posted July 2, 2016 Yes Link to comment Share on other sites More sharing options...
Luigi123 Posted July 2, 2016 Author Share Posted July 2, 2016 Alright, my cPanel Username is luigi123 Link to comment Share on other sites More sharing options...
wolstech Posted July 3, 2016 Share Posted July 3, 2016 Escalating. @krydos: do we have any database backups for any databases on this account? Link to comment Share on other sites More sharing options...
Krydos Posted July 3, 2016 Share Posted July 3, 2016 There are no backups for the username luigi123. Link to comment Share on other sites More sharing options...
wolstech Posted July 3, 2016 Share 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. Link to comment Share on other sites More sharing options...
Recommended Posts