Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Other *NIX Forums > Other *NIX
User Name
Other *NIX This forum is for the discussion of any UNIX platform that does not have its own forum. Examples would include HP-UX, IRIX, Darwin, Tru64 and OS X.


  Search this Thread
Old 07-08-2005, 08:56 PM   #1
LQ Newbie
Registered: Jul 2005
Location: Toronto, ON
Posts: 1

Rep: Reputation: 0
Unhappy segmentation fault when insert data into mysql

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.

Old 08-07-2005, 07:13 AM   #2
Registered: May 2005
Posts: 378

Rep: Reputation: 33
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.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
yast segmentation fault, system freezing - nvidia driver at fault? BaltikaTroika SUSE / openSUSE 2 12-02-2005 09:34 AM
MySQL Administrator segmentation fault joe2280 Linux - Software 2 10-28-2005 04:30 AM
problem to insert data os2 Programming 1 11-25-2004 10:44 AM
Insert Data by FORM in MYSQL gruger Linux - Software 0 07-16-2003 12:50 PM
After insert data, Database is empty ivankong Linux - Software 2 06-16-2003 07:35 AM > Forums > Other *NIX Forums > Other *NIX

All times are GMT -5. The time now is 12:11 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration