Repair query error

[Mayur Dange]

The query:
mysql_query(&mysql,"REPAIR TABLE locations;");
generates following error:
2006:MySQL server has gone away

the query runs well when ran through php!
so i guess it is some problem with c connector...
below is the full c program:

#include <stdio.h>
#include <stdlib.h>
#include "mysql.h"
MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW row;
int main()
{
char *server = "localhost";
char *user = "root";
char *password ="password";
char *database ="db";
mysql_real_connect(&mysql, server, user, password, database, 0, NULL, 0);
mysql_query(&mysql,"REPAIR TABLE locations;");
printf("%d:%s\n",mysql_errno(&mysql),mysql_error(&mysql));
mysql_close(&mysql);
}

Please help;
i am working on a database which handles about 100's of readings per second. so in case of any failure i need to manually run query repair table query on the server.