Major help needed urgently - Server rebuild.

[ineedhelp]

Suddenly my site went down and got the 503 server error.

I couldn't access my pleask (web fusion software) to restart my services, The host tried and then got this error:

ERROR: PleskFatalException
Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: No such file or directory

0: common_func.php3:153
psaerror(string 'Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: No such file or directory')
1: auth.php3:112
ERROR: PleskFatalException
Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: No such file or directory

0: common_func.php3:153
psaerror(string 'Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: No such file or directory')
1: auth.php3:112

They have told me I need to rebuild my server. I've never done a server rebuild and I don't want to risk losing my database/files.

They've given me steps to follow but it all looks complex.

I've never used SSH etc.

Anyone got any advice or willing to help?

@DRE and anyone else!

 

[Jeremy]

It looks like your mySQL server has crashed. Try restarting that (via SSH).

 

[ineedhelp]

It looks like your mySQL server has crashed. Try restarting that (via SSH).

Unfortunately the MySQL server fails start and unfortunately you will need to rebuild the server in order to solve this issue.

The host has already tried. And now it's up to me to fix it.

Got any ideas?

 

[DRE]

I didn't get an alert for this. Did you edit your post, then tagged me? Alerts are not given when you do it that way. Anyway hopefully you have a latest backup. Whens your latest backup?

 

[DRE]

The host has already tried. And now it's up to me to fix it.

Got any ideas?

Are you on a managed or unmanaged vps or a dedicated server?

 

[ineedhelp]

I didn't get an alert for this. Did you edit your post, then tagged me? Alerts are not given when you do it that way. Anyway hopefully you have a latest backup. Whens your latest backup?

No I didn't edit the post.

Back up is from 12pm GMT today. I've never used any back up database files before, I can only hope it works.

 

[ineedhelp]

Are you on a managed or unmanaged vps or a dedicated server?

Unmanaged VPS.

 

[DRE]

Oh so your restoring it already? Good job!

 

[ineedhelp]

Oh so your restoring it already? Good job!

No I'm not lol.

I'm still stuck.

 

[DRE]

Unmanaged VPS.

Unmanaged VPS are cheap but in cases like yours I'd switch to a managed VPS. Since most of your users are in the UK, i suggest you switch to http://www.nimbushosting.co.uk/ and holler at Tim for the transfer. I remember you said you had some kinda contract. Whats that entail? You have to remain with them a couple more months? Anyway nimbushosting is great, I was on them when @Chris Deeming hosted me when I had issues.

 

[Chris D]

I think you should consider using a manged VPS provider.

You obviously don't have the expertise required to maintain and repair your server if it goes wrong, so you should be paying for someone to do that for you, via a VPS provider that would manage it for you.

Hopefully you'll find someone kind enough to help you out otherwise your site is going to be down for a long time.

Maybe you should ask if there's any sort of one off fee you can pay to your VPS provider so they will sort this issue out for you.

 

[kprojects]

can you go in and see what mysql is complaining about when it doesn't start?

 

[ineedhelp]

Unmanaged VPS are cheap but in cases like yours I'd switch to a managed VPS. Since most of your users are in the UK, i suggest you switch to http://www.nimbushosting.co.uk/ and holler at Tim for the transfer. I remember you said you had some kinda contract. Whats that entail? You have to remain with them a couple more months? Anyway nimbushosting is great, I was on them when @Chris Deeming hosted me when I had issues.

Contract ends end of the month.

But right now, I need to rebuild the server and restore everything, so the site is back up.

 

[DRE]

Contract ends end of the month.

But right now, I need to rebuild the server and restore everything, so the site is back up.

Please don't renew because you've had issues before. Also sometimes the site was slow for me when I was on there. Go with nimbushosting.

 

[ineedhelp]

I think you should consider using a manged VPS provider.

You obviously don't have the expertise required to maintain and repair your server if it goes wrong, so you should be paying for someone to do that for you, via a VPS provider that would manage it for you.

Hopefully you'll find someone kind enough to help you out otherwise your site is going to be down for a long time.

Maybe you should ask if there's any sort of one off fee you can pay to your VPS provider so they will sort this issue out for you.

They charge £100+ for a one off.

 

[DRE]

Yeah that's ridiculous. Your contract does not mean you absolutely have to host your site with them right? You can still move, you'll just be paying the remainder of the month. In the meantime you should email nimbushosting and ask them to move you. They'll quote you and hopefully get you started if you give them the info they need.

 

[Martok]

No I didn't edit the post.

Yes you did. When I first saw it, the final line tagging DRE wasn't in it.

 

[DRE]

lol

 

[ineedhelp]

Problem solved. Did a server rebuild.

Thanks all.

 

[ineedhelp]

Yes you did. When I first saw it, the final line tagging DRE wasn't in it.

I was too concerned about my site to remember if I edited the post or not lol.