Glitch_01 Posted January 13, 2019 Share Posted January 13, 2019 Hey I haven't logged in in quite sometime and my account was archived, could it please be un-archived? Thanks in advance, Glitch1 Link to comment Share on other sites More sharing options...
Krydos Posted January 13, 2019 Share Posted January 13, 2019 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... Link to comment Share on other sites More sharing options...
Krydos Posted January 13, 2019 Share Posted January 13, 2019 Done. You should now be able to log in and your website should start working within 2 hours. Link to comment Share on other sites More sharing options...
Glitch_01 Posted January 13, 2019 Author Share Posted January 13, 2019 Thank you! Link to comment Share on other sites More sharing options...
Glitch_01 Posted January 14, 2019 Author Share Posted January 14, 2019 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: charsetThe size is showing as 0.00 MB (have tried repairing and creating new users). Has the database been lost? Thanks for your help, Glitch1 Link to comment Share on other sites More sharing options...
Krydos Posted January 14, 2019 Share Posted January 14, 2019 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. Link to comment Share on other sites More sharing options...
Glitch_01 Posted January 14, 2019 Author Share Posted January 14, 2019 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 Link to comment Share on other sites More sharing options...
Recommended Posts