whoguesswho Posted May 9 Posted May 9 Hello, Received the email of the issue with the Johnny server, appreciate the email with the notice and the backup. I am wondering about the database, seems some were not able to be recovered and mine is not in the backup file, want to confirm if it is the case with it. While Johnny is rebuild, could the site be move to Morty temporarily?, once the server is back will confirm if we stay on Morty. 😉 Thanks for the all service and support you guys have been given with the hosting service. \m/
Unknown025 Posted May 10 Posted May 10 An administrator will be able to help with the Morty migration and your missing database files. It is possible that your database may be recoverable, but as always, we recommend creating your own backups. What name(s) did you use in your database?
whoguesswho Posted May 10 Author Posted May 10 Hi, Thanks for the reply, had one backup of the site but forgot to made one of the DB to be honest 😐 DB name would be: whoguesswho_msgboard, if it can be recoverable great but I understand that it might be loss forever.
whoguesswho Posted May 11 Author Posted May 11 Hi, For tables iirc messages was the one left in the end.
Krydos Posted May 14 Posted May 14 So, the only table in the database had the name messages, and there were no other tables?
whoguesswho Posted May 15 Author Posted May 15 Hi, yes. The database was for build quickly for a board, in the end was decide to keep users and any other stuff out and leave just that table. It was the quick solution for users to leave the msg and admins to approve/delete them, with no history/log necessary.
Krydos Posted May 16 Posted May 16 There are two databases where messages is the only table. Can you narrow it down any further?
whoguesswho Posted May 16 Author Posted May 16 Hi, I recall the database was created by September last year and wiped last March when then was filled with the new content (March 15 is the last day I remember a new entry was added to the table as it was reviewed that day).
Krydos Posted May 16 Posted May 16 Ok, I added the database to your backup at https://heliohost.org/backup Please be aware that the database is in .frm and .ibd files which are binary, not .sql file which would be text. You will need to do some database recovery to get the data out of there. I've googled it and it seems like there are a lot of different methods to do this. If you succeed at extracting the data from the binary files we would appreciate it if you shared the method you used so we can instruct other people to do the same.
whoguesswho Posted May 18 Author Posted May 18 Hi, Thanks for that!!, I'll check it. For some reason I can log in the forums but not the main site (either with email or username), I'm getting error Unable to login with that username and password. Even tried to reset the password but still the same issue.
Recommended Posts