My account got deleated

+2 votes
asked Nov 20, 2021 in AB/DL by mwalker1996 (9,270 points)
It seemed that my old posts are gone. I was mwalker96, I was one of the fastest growing users on the site. I hope that you guys are doing ok. It felt weird not being able to post for almost a week.

2 Answers

0 votes
answered Nov 20, 2021 by chad (14,670 points)
Sorry that your posts and account got deleted.

We had a server issue on the old server and the mysql crashed.

I did and do have a backup of the server database for that date that it crashed and tried to move it over to the new server.

However the database was giving errors and would not work properly because of some sql syntax errors.

I have a mysql expert working on the database to hopefully fix the errors of the database from the night the database server crashed.

So when and if they get it fixed which should hopefully be in a few days or so the posts may come back.

Luckily I did have an older database file that worked and is what got the site back up right now but it was from last year.

So we lost a years worth of posts and user accounts.

If someone's account got deleted then they will have to sign back up.

Sorry for the inconvenience.

I worked hard on restoring things and I was luckily aware of the issue within minutes of the server crashing.

We moved to a different hosting company with better server specs and more ram etc to hopefully prevent this from happening.

I take nightly backups and even morning back ups to ensure we have a current database but for some reason the most current database didn't work properly.

The information and posts and accounts are in the database however it's just a problem with some code in the database which I have hired a mysql admin to help fix the issue.

I worked hard all through the night and stayed up trying to get it moved over and restored but it just wasn't working.

So I made the decision to go ahead and restore it with the working database of a year ago.

We lost over 10,000 questions but at least the site got back online or it may have been down for another few days or even longer.
commented Nov 20, 2021 by Pamperslover (25,840 points)
Thanks for working hard on it even without getting sleep.

Glad you got it back up though even if some of the posts and accounts are gone.
0 votes
answered Nov 20, 2021 by Pamperslover (25,840 points)
I'm okay and was wondering what happened as well.

It seems a lot of websites have been going down lately for some reason.

It's been a weird year this year and things this year have been getting worse it seems but hopefully things will start getting better next year.

I hated seeing your account gone and posts as well as some of my posts and other posts but thankfully the website is back online.

Glad to see you signed back up.

98,443 questions

94,802 answers

1,270 comments

6,992,778 users

...