Page 1 of 2 12 LastLast
Results 1 to 10 of 20

Thread: How to Repair a MySQL Database

Hybrid View

  1. How to Repair a MySQL Database

    Every active database of any significant size will eventually experience some sort of corruption.

    MySQL is the market leader for open-source databases. Most web software that uses databases supports MySQL and many of those packages support only MySQL.

    Luckily, you can repair all of the databases in your database server with just one command:
    mysqlcheck --auto-repair -e --all-databases -u<MYSQL_USERNAME> -p<MYSQL_PASSWORD> -h<MYSQL_HOST>
    • --auto-repair means "If a checked table is corrupted, automatically fix it."
    • -e means "Check and repair tables."
    • --all-databases means "Check all tables in all databases." It can be replaced with --databases <DATABASE_LIST> to check/repair just one or a few databases.
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.


  2. #3
    Quote Originally Posted by MeetHere View Post
    I use repair button in my mysql admin in cpanel.
    What happens when that doesn't work?
    (

    Diet Fads

  3. #4
    Quote Originally Posted by m42 View Post
    What happens when that doesn't work?
    A huge amount of cPanel web hosts don't offer full SSH access in the first place.

    Quote Originally Posted by MeetHere View Post
    hmm, never had such problem.
    where should I add the above commands ?
    In an SSH program, like PuTTY.

  4. #5
    Quote Originally Posted by Charles View Post
    A huge amount of cPanel web hosts don't offer full SSH access in the first place.
    Talk to Mia/Hostinglizard.com. I refuse to host with anyone who doesn't provide shell access. cPanel is severely limiting. I doubt the hosting company wants to spend time troubleshooting my SQL errors.
    (

    Diet Fads

  5. #6
    Quote Originally Posted by m42 View Post
    Talk to Mia/Hostinglizard.com. I refuse to host with anyone who doesn't provide shell access. cPanel is severely limiting. I doubt the hosting company wants to spend time troubleshooting my SQL errors.
    Doesn't mean to say that mine doesn't. The only con that I can point out with O2... Is that, depending on which server Nathan places you on, you cannot perform all .htaccess edits (i.e. enabling PHP on HTML).

    I bought a plan with Mia (for a whole year) -- not realizin' that you couldn't have any add-on domains. Kinda unuseable to meh, now.

  6. #7
    Quote Originally Posted by Charles View Post
    A huge amount of cPanel web hosts don't offer full SSH access in the first place.
    Typically, if you're on a shared plan you can't have Root/SSh access.
    VPS plans typically offer it, as well as dedicated.

  7. hmm, never had such problem.
    where should I add the above commands ?

  8. I can't imagine life without SSH. It would be like trying to work with mittens on.
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

  9. #10
    I knew there should be something behind it...

Page 1 of 2 12 LastLast

Similar Threads

  1. [WTS] US Golf Courses Database (MySQL) – 19,168 Records
    By yangyang in forum Content
    Replies: 0
    Last Post: 22 December, 2010, 15:16 PM
  2. MySQL database update
    By proweb in forum Databases
    Replies: 4
    Last Post: 22 May, 2010, 21:55 PM
  3. Replies: 0
    Last Post: 21 April, 2010, 17:35 PM
  4. Backup of Mysql database using PhpMyAdmin
    By mega in forum Databases
    Replies: 2
    Last Post: 14 May, 2009, 09:06 AM
  5. How to Optimize a MySQL Database
    By Tom in forum Databases
    Replies: 0
    Last Post: 23 December, 2008, 10:48 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •