1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

please please need the fast help with repair table

Discussion in 'Databases' started by bersy, Aug 28, 2013.

0
  1. #1
    hi my friends ,
    i am have host at godaddy and i can't repair my database there are big table at it
    (size :1 gigabit)
    but when i try to repair it with phpmyadmin i get error
    i think that's because the memory_limit 83 mb
    how can i repair this table cuz the support at godaddy most shit thing at this world
    ???????????????????????????????????????????????????????????????????????????????????? :(
     
    bersy, Aug 28, 2013 IP
  2. GSP

    GSP Greenhorn

    Messages:
    60
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    18
    #2
    You can connect to the database remotely with software (MySQL Workbench, Navican, SQLyog...) and repair it from there. Before you must allow the connection from godaddy control panel.
     
    GSP, Aug 28, 2013 IP
  3. Flatliner86

    Flatliner86 Well-Known Member

    Messages:
    186
    Likes Received:
    19
    Best Answers:
    1
    Trophy Points:
    118
    #3
    Did you try the official repair command?

    REPAIR [LOCAL | NO_WRITE_TO_BINLOG] TABLE
  tbl_name [, tbl_name
 
] ... [QUICK] [EXTENDED] [USE_FRM]
    Code (markup):
    You can find more Details here:
    http://dev.mysql.com/doc/refman/5.1/de/repair-table.html


    This command should not be linked to your upload Limit! So if you get the error there has to be another reason. What Kind of error do you get?
     
    Flatliner86, Sep 2, 2013 IP