Hi, everyone:

How is everybody doing today! I am a little mad since I have tried to put the URLs and anchor texts into mysql database using mysql c API. I kept getting segmentation fault error after I insert URLS more than 3000 or 4000. you know the log files are always more than 10000 records and up to 1G. I am not sure if somthing wrong with my database design but I only insert three fields.

Anyway, the code I am using is:

mysql_query(conn, "CREATE TABLE anchor_db (id int(11) NOT NULL auto_increment, input_url TEXT(8192) default NULL, input_referer TEXT(8192) default NULL, anchor_text TEXT(1024) default NULL, PRIMARY KEY (id)) TYPE=MyISAM");

Please offer to help if tou are expert in mysql since I just got into it a couple of weeks ago.

Thanks

You've shown us the code you're using to create the table (which works), but not the code that's inserting the data (which isn't working!). Help us to help you, please, by showing us the code that you want us to fix.