Jerry,

I moved the load.txt file to d:\mysql\data\UserProfile (which is the name of my database) and the load still doesn't work. However, if I executed the same command from the command prompt from the directory (d:\mysql\bin) with the load.txt file located in the same directory it seems to load the data file okay. In other words, using the equivalent command at the prompt works but when I use the mysql_query command from within C code it always fails. Any more suggestions on this. My guess is that the load.txt file is somehow not be located.

Take a look at the revised code: <<load.txt>>

/* The function parameters are getting passed in from another procedure */ int mysql_insert(MYSQL *conn, char *user_id, char *host_id, unsigned int Ppid, unsigned int Pid, double cputime, char *activity_code, double ctls, double cpusls, char *command, char *mode) {

FILE *mysql_load_file; char ip_addr[] = "149.8.6.103"; char datetime[] = "0000-00-00 00:00:00";

/* open mysql load file for writing */ if ((mysql_load_file = fopen("d:\\mysql\\data\\UserProfile\\load.txt","a+")) == NULL) // Doesn't seem to work using (d:\\mysql\\data\\UserProfile\\load.txt) either { printf("Couldn't open the bulk_load_file for writing\n"); exit(2); }

fprintf(mysql_load_file,"%s\t%s\t%lu\t%ld\t%s\t%s\n", user_id,host_id,Pid, Ppid, mode, command);

if (mysql_query(conn,"LOAD DATA LOCAL INFILE 'load.txt' INTO TABLE Process FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' ") != 0) { printf("LOAD DATA process failed\n");

}

else { printf("LOAD statement succeeded: %lu rows affected \n", (unsigned long) mysql_affected_rows (conn)); }

fprintf(mysql_load_file,"%s\t%s\t%s\t%s\n",user_id, host_id, ip_addr, datetime);

if (mysql_query(conn,"LOAD DATA LOCAL INFILE 'load.txt' INTO TABLE Session FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'") != 0) { printf("LOAD DATA process failed\n");

}

else { printf("LOAD statement succeeded: %lu rows affected \n", (unsigned long) mysql_affected_rows (conn)); }

fprintf(mysql_load_file,"%lu\t%ld\t%12.3f\t%12.3f\t%12.3f%\t%c\n", Pid, Ppid, cputime,(double)ctls,cpusls,activity_code);

if (mysql_query(conn,"LOAD DATA LOCAL INFILE 'load.txt' INTO TABLE Activity FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'") != 0) { printf("LOAD DATA process failed\n");

}

else { printf("LOAD statement succeeded: %lu rows affected \n", (unsigned long) mysql_affected_rows (conn)); }

return 0; }

Regards, Darrick Addison SAIC Software Engineer