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 ????????????????????????????????????????????????????????????????????????????????????
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.
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?