maximum number of rows in mysql table??

HI,

I tried to load data from a text file into mysql database , I realized that not all the data get loaded. IS there a maximun number of row for a table with mysql?
My file is really big, I was able to load 10000 records but I still have  a  lot. Could you please tell me how I can overcome this problem.
THanks a lot!!
salouaAsked:
Who is Participating?
 
vasan_srConnect With a Mentor Commented:
I think mysql can load 2 -3 millions of data...thats what mentioned in thier site.

can u insert it manually...i think u wud have no space in  ur harddisk.

check for the partitions...

regards
VasanS
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
besides of that max limit you have the limit imposed by the primary key...

Can you describe your table and your files
CHeers
0
 
salouaAuthor Commented:
Hello,

NO I can not even insert manually  any more data on the table!

Here is my table:
create table PRC_Sbb(
PRC  char(10) not null,
Sbb char(10) not null,
primary key(PRC,Sbb)
);

BEst Regards
Saloua
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.