[Solved] Archived: Glitch_01

[Glitch_01]

Hey I haven't logged in in quite sometime and my account was archived, could it please be un-archived?

 

Thanks in advance,

 

Glitch1

[Krydos]

Your account was archived because you haven't logged in for quite a while. We have a limited amount of space on our servers, and occasionally we have to remove the unused accounts to make space for new users. To prevent your account from becoming archived again please remember to log in at https://www.heliohost.org/login/ at least once every 30 days.

 

Unarchiving...

[Krydos]

Done. You should now be able to log in and your website should start working within 2 hours.

[Glitch_01]

Thank you!

[Glitch_01]

All seems good except mysql is not working. When trying to go to phpmyadmin I get

 mysqli_connect(): (HY000/3118): Access denied for user 'glitch1'@'localhost'. Account is locked.
 Undefined index: auth_type
 Undefined index: charset

The size is showing as 0.00 MB (have tried repairing and creating new users). Has the database been lost?

 

Thanks for your help,

 

Glitch1

[Krydos]

I checked the archive, and the glitch1_xenforo.sql database is empty so it wasn't an issue with how it was restored. It looks like the default for xenforo is innodb, which has a really bad track record during crashes. Pretty much every innodb table gets lost when Johnny has a mysql crash. With myisam tables we've never lost any data during a crash so we always recommend using it instead of innodb. When you try to make a backup of an innodb database that has crashed it will result in an empty .sql file like that. That's my guess of what happened. So, unless you have a backup saved somewhere on your home pc your database is probably lost.

[Glitch_01]

Ah okay, not a big deal as this is just a testing environment for me. (I'll just start over).

 

Thanks for all your help!

Glitch1