Solved

maximum number of rows in mysql table??

Posted on 2002-06-21
3
1,015 Views
Last Modified: 2007-11-27
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!!
0
Comment
Question by:saloua
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 2

Accepted Solution

by:
vasan_sr earned 100 total points
ID: 7100281
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
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 7103035
besides of that max limit you have the limit imposed by the primary key...

Can you describe your table and your files
CHeers
0
 

Author Comment

by:saloua
ID: 7105106
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

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question