how do i optimize or refresh database?

Discussion in 'MySQL' started by secretsau, Mar 9, 2009.

0
  1. #1
    Hi everyone

    I have a problem on my server!! and i need to optimize or refresh database?? Does anyone know how to do this??

    :confused:

    Regards
     
    secretsau, Mar 9, 2009 IP
  2. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #2
    DO a qeury like this for optimize
    OPTIMIZE TABLE table_name;
    but for refresh I doubt whats the query
     
    crivion, Mar 9, 2009 IP
  3. OinkOink

    OinkOink Peon

    Messages:
    39
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    You can refresh the privileges on your server using:

    FLUSH PRIVILEGES;
     
    OinkOink, Mar 9, 2009 IP
  4. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Vacuum full analyze
    reindex all

    Since you don't specify you database server Crivion an OinkOink are assuming (ASS U ME) Mysql I am guessing Postgresql. Can someone give the syntax for the other database servers out there, as long as we don't know it is fun to keep guessing.
     
    chisara, Mar 12, 2009 IP