SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Reindex with phpMyAdmin

  1. #1
    SitePoint Enthusiast
    Join Date
    Aug 2009
    Posts
    89
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Reindex with phpMyAdmin

    Hello,

    I have a database which has 28 tables.

    How do I reindex all the tables?

    Someone suggested performing a repair to each table, but when I tried that I received an error message:
    The storage engine for the table doesn't support repair

    Thanks.

  2. #2
    SQL Consultant silver trophybronze trophy
    SitePoint Award Recipient r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    38,513
    Mentioned
    35 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by kath View Post
    How do I reindex all the tables?
    what does "reindex" mean in this context?

    what gave you the idea that you needed to do this?
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

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
  •