LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Other *NIX Forums > Other *NIX
User Name
Password
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.

Notices

Reply
 
Search this Thread
Old 07-08-2005, 08:56 PM   #1
torontosmallbird
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.

Thanks
 
Old 08-07-2005, 07:13 AM   #2
eddiebaby1023
Member
 
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.
 
  


Reply


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/Novell 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


All times are GMT -5. The time now is 05:53 AM.

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