Tweet
My site died today, and i'm not sure what's happened/ing to it. 
It all started with me having my host move me to a different server. Should have known something would go wrong.
So once it had moved the site came back up after the DNS changes, my site was redirecting to the install folder but because it didn't exist it couldn't find the page. I wasn't sure what was happening, so I attempted to restore the database, it is only 40Mb in size.
Various attempts to restore the database, phpmyadmin, SQL, sql dumper, etc all failed and as a result the database was damaged as it went from 40Mb to 3.52Mb.
After speaking with my host they indicated the likely issue is that the new server has PHP 5.5, and if my database is several years old, which it is, then the password hash is old and it isn't liking it. He said the likely solution is to either change the password for the account connected to the database, or just create a new user account and associate it with the db, then updated the vbulletin config.php.
Well, sounds like a simple solution, but came too late as my database was already messed up.
But after creating a new user account, linking it to the database, then updating the config.php and then trying to restore the database again it seemed to work, however, it worked way too quick for my liking. The 40Mb database was restored within a minute. However, the database then slightly dropped to 38.9MB and remained there.
Then the next thing I know my site appears like this: http://www.gamerperfection.com
Then I lose complete access to the server cpanel as it doesn't accept the username and password for it anymore.
And so I also lose FTP access.
Now I sit and wait to hear from my host.
- - - Updated - - -
Seems like they moved me back to my old server and my database restored to 30th August. Not all bad, disappointing about the server move and I lost some data and a couple of user accounts since 30th Aug. But better than losing the site entirely.
It all started with me having my host move me to a different server. Should have known something would go wrong.
So once it had moved the site came back up after the DNS changes, my site was redirecting to the install folder but because it didn't exist it couldn't find the page. I wasn't sure what was happening, so I attempted to restore the database, it is only 40Mb in size.
Various attempts to restore the database, phpmyadmin, SQL, sql dumper, etc all failed and as a result the database was damaged as it went from 40Mb to 3.52Mb.
After speaking with my host they indicated the likely issue is that the new server has PHP 5.5, and if my database is several years old, which it is, then the password hash is old and it isn't liking it. He said the likely solution is to either change the password for the account connected to the database, or just create a new user account and associate it with the db, then updated the vbulletin config.php.
Well, sounds like a simple solution, but came too late as my database was already messed up.
But after creating a new user account, linking it to the database, then updating the config.php and then trying to restore the database again it seemed to work, however, it worked way too quick for my liking. The 40Mb database was restored within a minute. However, the database then slightly dropped to 38.9MB and remained there.
Then the next thing I know my site appears like this: http://www.gamerperfection.com
Then I lose complete access to the server cpanel as it doesn't accept the username and password for it anymore.
And so I also lose FTP access.
Now I sit and wait to hear from my host.
- - - Updated - - -
Seems like they moved me back to my old server and my database restored to 30th August. Not all bad, disappointing about the server move and I lost some data and a couple of user accounts since 30th Aug. But better than losing the site entirely.
Comment