dl5ark1 Posted August 30, 2016 Posted August 30, 2016 user: dl5arkserver: steviedatabase: dl5ark_blitzortung @Krydos: I have exactly the same problem like in http://www.helionet.org/index/topic/23583-mysql-crash/?do=findComment&comment=115786 once again (Restoration Assistant: Restoring database "dl5ark_blitzortung" But nothing happens. dl5ark_blitzortung.mybo_strikes cannot be restored) Please can you do the manually edit and import as in May? The upload is in /home/dl5ark .
wolstech Posted August 30, 2016 Posted August 30, 2016 This support request is being escalated to our root admin.
Krydos Posted August 31, 2016 Posted August 31, 2016 You know you can do this yourself, right? Delete everything above DROP TABLE IF EXISTS `mybo_strikes`; and everything below the last INSERT INTO `mybo_strikes`... and then import that .sql file. Anyways, I did it for you. How does your database look now?
dl5ark1 Posted August 31, 2016 Author Posted August 31, 2016 No, but now ;-)Thanks.Why i cannot use the Restoring Assistant?
wolstech Posted August 31, 2016 Posted August 31, 2016 A variety of reasons. The big one here is that the database already exists and it was damaged by a crash. cPanel doesn't like a lot of things, especially dealing with corrupt databases. They break a lot of things, and also have a bad habit of not fully dropping when you tell them to, even if cP says that it did. If you had used a different database name, it may have worked (provided the new name wasn't previously damaged in some way). In my experience though, you're always better off just making a new empty database then going into PhpMyAdmin and importing your file to populate it.
Recommended Posts