HelioHost Posted April 23, 2018 Posted April 23, 2018 Username: moonland, Server: Johnny, Main domain: moonland.heliohost.org Hello, after account inactivation due to innactivity, and subsequent reactivation, the database from one of my applications stopped working. The "check" button gives the following response: [moonland_pwdmngr.blockip] Error: Table 'moonland_pwdmngr.blockip' doesn't exist[moonland_pwdmngr.blockip] status: Operation failed[moonland_pwdmngr.files] Error: Table 'moonland_pwdmngr.files' doesn't exist[moonland_pwdmngr.files] status: Operation failed[moonland_pwdmngr.history] Error: Table 'moonland_pwdmngr.history' doesn't exist[moonland_pwdmngr.history] status: Operation failed[moonland_pwdmngr.password] Error: Table 'moonland_pwdmngr.password' doesn't exist[moonland_pwdmngr.password] status: Operation failed[moonland_pwdmngr.pin] Error: Table 'moonland_pwdmngr.pin' doesn't exist[moonland_pwdmngr.pin] status: Operation failed[moonland_pwdmngr.pwdusrrecord] Error: Table 'moonland_pwdmngr.pwdusrrecord' doesn't exist[moonland_pwdmngr.pwdusrrecord] status: Operation failed Can you please help me? I sadly relied on this database for some important passwords... Thanks!
Krydos Posted April 23, 2018 Posted April 23, 2018 It looks like you were using InnoDB mysql> select engine from information_schema.tables where table_schema = 'moonland_pwdmngr'; +--------+ | engine | +--------+ | InnoDB | | InnoDB | | InnoDB | | InnoDB | | InnoDB | | InnoDB | +--------+ 6 rows in set (0.69 sec) We strongly recommend people use MyISAM for this very reason. Due to high load on Johnny the InnoDB tables crashed, and we were forced to put them into read-only mode. Are you able to take a backup of the database yourself? If not let us know and we can check to see if the system has a backup for you.
HelioHost Posted May 12, 2018 Author Posted May 12, 2018 Hi, I cannot take a backup of the database. When I did, the backup was of the c=urrent, empty, database, and the previous information lost. Can you please =look if there is some older backup from before the crash? Thanks! =E2=80=8BSent from ProtonMail, Swiss-based encrypted email.=E2=80=8B =E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90 Original Me=ssage =E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90 On April 23, 2018 8:37 PM, Heliohost Support wrote: > =E2=80=8B=E2=80=8B> > It looks like you were using InnoDBmysql> select engine from information_=schema.tables where table_schema =3D 'moonland_pwdmngr';+--------+| engine =|+--------+| InnoDB || InnoDB || InnoDB || InnoDB || InnoDB || InnoDB |+---=-----+6 rows in set (0.69 sec)We strongly recommend people use MyISAM for t=his very reason. Due to high load on Johnny the InnoDB tables crashed, and =we were forced to put them into read-only mode. Are you able to take a back=up of the database yourself? If not let us know and we can check to see if =the system has a backup for you.> > You may view the status of your ticket by visiting:> > https://www.helionet.org/index/index.php?showtopic=3D32646> > Thank you,> > Heliohost support> > https://www.heliohost.org/> > https://www.helionet.org/
ziad87 Posted May 13, 2018 Posted May 13, 2018 InnoDB is very fragile and is easy to nuke. MyISAM is much more reliable. Johnny is down anyways, so no restoration there. Maybe you have a backup here? https://heliohost.org/backup Remember : Backups are the user's responsibility.
Recommended Posts