reshinaa Posted November 26, 2019 Share Posted November 26, 2019 My account was recently archived, but it has already been unarchived thanks to your team.Upon logging into my account, it seems that i have lost the database and users that i have created.Is this supposed to happen? Is there any way to retrieve my database? Link to comment Share on other sites More sharing options...
flazepe Posted November 26, 2019 Share Posted November 26, 2019 This support request is being escalated to our root admin. Link to comment Share on other sites More sharing options...
Krydos Posted November 26, 2019 Share Posted November 26, 2019 A backup of your files is named reshinaa.tar.gz and is in your home directory. Your database should be included. Link to comment Share on other sites More sharing options...
reshinaa Posted November 26, 2019 Author Share Posted November 26, 2019 Thank you very much, i have found the file. I've tried using the backup wizard to restore my database, but i can't seem to restore the database. Could you please guide me through the process of restoring my database. Link to comment Share on other sites More sharing options...
wolstech Posted November 26, 2019 Share Posted November 26, 2019 What format is the file in? It needs to be an .sql file. If you have a .sql.gz or something else that's compressed, unpack it first. Then, in cPanel, go to "Backup" (not "backup wizard") and use the "Restore MySQL database" section to upload the file. It should create the database and import the data all at once. Link to comment Share on other sites More sharing options...
reshinaa Posted November 26, 2019 Author Share Posted November 26, 2019 Upon extraction i am able to see all tables that i have previously created but the file format is in ".frm" and ".ibd" Link to comment Share on other sites More sharing options...
wolstech Posted November 26, 2019 Share Posted November 26, 2019 Those are InnoDB raw files. If you received those, it means your database could not be exported. There's no good or easy way to restore them. Supposedly there's ways to do it, but you also need the ibdata1 file (not sure if you have that or not), a linux box, a detailed knowledge of the inner workings of InnoDB and MySQL, and a procedure that looks something like this: https://hoststud.com/resources/steps-to-restoring-table-structure-from-frm-and-ibd-files.465/ Then you need to use the resulting structure SQLs to create the tables, then the data SQLs from the frm file to load the data. Then you need to export the entire complete database from the test box and reimport it here. I've personally never succeeded at restoring one of these, and I've been dealing with MySQL for years. This is the reason we usually don't recommend InnoDB...it's nearly impossible to recover if something goes wrong. We've lost entire servers' worth of InnoDB data before... Unfortunately, if you receive frm and ibd files, the easiest solution is almost always to just start over. Link to comment Share on other sites More sharing options...
reshinaa Posted November 26, 2019 Author Share Posted November 26, 2019 Oh god. Thank you very much for your input. I appreciate your help. Just to clarify, beside Primary Domain i have an error "(Self-Signed Certificate)". Can that be corrected? Link to comment Share on other sites More sharing options...
flazepe Posted November 26, 2019 Share Posted November 26, 2019 Refer https://www.helionet.org/index/topic/37842-hh832589-ssl-certificate/. Link to comment Share on other sites More sharing options...
reshinaa Posted November 27, 2019 Author Share Posted November 27, 2019 Thank you once again. Amazing customer service Link to comment Share on other sites More sharing options...
Recommended Posts