Results 1 to 6 of 6

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

  1. 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
    Is this for Mysql?
    If yes, do you have access to phpmyadmin?

  3. #3

  4. 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
    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
    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
  •