Results 1 to 6 of 6

Thread: which SQL query syntax to optimize and repair a database?

  1. #1
    garfish's Avatar
    garfish is offline I'm Not Sure.
    Join Date
    May 2009
    Posts
    848
    Blog Entries
    12
    Thanks
    155
    Thanked 57 Times in 54 Posts

    which SQL query syntax to optimize and repair a database?

    i think i have ruined my database and don't know which SQL query syntax to optimize and repair a database.
    can you tell me please which SQL query syntax to optimize and repair a database?


    .

  2. #2
    Shenron's Avatar
    Shenron is offline Administrator
    Join Date
    Dec 2008
    Location
    Portugal
    Posts
    1,900
    Blog Entries
    2
    Thanks
    561
    Thanked 548 Times in 368 Posts
    Is this for Mysql?
    If yes, do you have access to phpmyadmin?

  3. #3
    markwillium is offline Unknown Net Builder
    Join Date
    Sep 2011
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

  4. #4
    garfish's Avatar
    garfish is offline I'm Not Sure.
    Join Date
    May 2009
    Posts
    848
    Blog Entries
    12
    Thanks
    155
    Thanked 57 Times in 54 Posts
    yes mysql. i think i have once again ruined my database.
    i can view the site and can also login in the dashboard but if i click Add new post or anywhere like themes or widget, it prompts The connection cannot be used to perform this operation.

  5. #5
    iowadawg's Avatar
    iowadawg is offline Free Cell Champion
    Join Date
    May 2010
    Location
    Not in Texas
    Posts
    2,071
    Blog Entries
    4
    Thanks
    166
    Thanked 360 Times in 309 Posts
    Tell me what you did wrong, so I won't do it!
    But really, in your mysql in cpanel, there is a button to hit to repair a database.
    I have never tried that, but it may work.

  6. #6
    Andy101's Avatar
    Andy101 is offline Code Otaku
    Join Date
    Aug 2009
    Location
    Kanazawa
    Posts
    1,252
    Thanks
    173
    Thanked 303 Times in 230 Posts
    Tell me what you did wrong, so I won't do it!
    Yep, knowing what you did may help. I never tried the REPAIR TABLE function but it may help if the data was corrupted.

    But if you ran some code to mess up the data, then it could be difficult to undo the damage.

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
  •