Charlottezweb

Charlottezweb Hosting => Support => FAQs => Topic started by: Jason on February 27, 2017, 06:53:20 PM

Title: How to repair a database in cPanel
Post by: Jason on February 27, 2017, 06:53:20 PM
Sometimes in the event of a service failure, a mysql database can become corrupted due to a partial save or lack of a save when the crash occurs. When this occurs, you may see errors (depending on the type of scripts you're using on your site) that show mysql errors or perhaps errors connecting to your database.

Normally this can be sorted by running a repair on the database in question in cPanel.  To do this:

1. Login to cPanel and click on the "MySQL databases" icon.
2. Select the database you'd like to repair under the "Modify Databases" section under "Repair Database" field.  [See below]

(https://www.charlottezweb.com/images/repair-database.gif)

3. Click the "Repair Database" button.

Depending on the size of your database, that could take a few seconds to a minute or more to run.  It will give you the results once completed.

Regards,
Jason
Title: Re: How to repair a database in cPanel
Post by: aura on February 28, 2017, 12:50:38 AM
Hi Jason

I did this repair before I read your email.  It didnt work for me, so I figured it was something I had done, my site is still saying

Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

Not sure if i have messed it up now. 

Title: Re: How to repair a database in cPanel
Post by: Jason on February 28, 2017, 08:30:14 AM
From what I'm seeing, your SMF Settings.php file is pointed to a database that doesn't exist.  Have you changed that file or removed a database by chance?

We can keep troubleshooting via your ticket if you'd like.

Regards,
Jason
Title: Re: How to repair a database in cPanel
Post by: aura on February 28, 2017, 10:38:39 AM
sneaks in all red faced like the naughty girl who got caught with her fingers in the candy jar...

am i the worst customer you have Jason? 

in my fixing i did a big opps.... thank you for just being simply amazing, your a wonderful host.

Title: Re: How to repair a database in cPanel
Post by: Jason on February 28, 2017, 10:44:15 AM
Heh - no worries.  :)

You're very welcome.

Cheers,
Jason
Title: Re: How to repair a database in cPanel
Post by: aura on February 28, 2017, 10:51:55 AM
Thanks again Jason.