List:General Discussion« Previous MessageNext Message »
From:David Blomstrom Date:July 2 2004 10:14pm
Subject:Re: 16-Page Database Table Limit?
View as plain text  
--- Rhino <rhino1@stripped> wrote:

> I would try to track the problem down as follows:
> 
> 1. Are there any error messages from the import? If
> yes, what do they say?

No. I import my data as csv files using Navicat, and I
fix any errors until they import with 0 errors.

> If the import
> actually says that it has only loaded 480 rows and
> rejected the rest for
> Reason X, have you done anything to eliminate Reason
> X? For example, if the
> import says it can only load 480 rows because the
> *disk* is full, have you
> tried locating your table on a different disk?

I don't recall seeing messages of this nature.

> 2. What happens when you do 'select count(*)' on
> your new table?

I'm not familiar with that command. If I type select
count (*) into the "query" box on phpMyAdmin, it says 
count(*) = 0 Or is this a type of table query I do on
my webpage?

 Does it say
> 480; if it does, you should tend to believe phpAdmin
> that the table really
> does contain only 480 rows and then double-check the
> import. Does it say
> 3000; if it does, you may be misunderstanding
> phpAdmin's display and are
> confusing the number of *pages* of data with the
> number of rows of data. Or
> maybe phpAdmin is misreporting the amount of data in
> the table; it is a
> program like any other and could have a bug in it.
> Do you have any tables at
> all in your MySQL database that have more than 480
> rows? If yes, you've
> proven that MySQL tables can contain over 480 rows.
> Look at the phpAdmin
> display for that table and see if they are
> "truncated at 16 pages" too.
> 
> If the count(*) really shows 480 rows in the table
> and there are no error
> messages in your import, or if you can't understand
> the messages, you should
> post the import statement you've used, a few sample
> rows of your input, the
> definition of your table, and the messages, if any.
> Someone here can
> probably figure out what you're doing wrong.

I checked two tables and found that each end with the
row below (row #480):

"al01103","Morgan","cou","al01103","us-al","Alabama","sta","al",,,,480

This would be row #481:

"al01105","Perry","cou","al01105","us-al","Alabama","sta","al",,,,481

The fields are all char(3) or varchar(4-255), except
for one int(5). All the Null values are Yes/Null
except for the first and last fields, which are No.
There is no index.

I didn't realize there was a problem until today. At
first, I was struck by the fact that MySQL can somehow
squeeze 3,000 rows into 16 pages!

Thanks.


		
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail 
Thread
16-Page Database Table Limit?David Blomstrom2 Jul
Re: 16-Page Database Table Limit?David Blomstrom3 Jul
  • Re: 16-Page Database Table Limit?Dan Nelson3 Jul
Re: 16-Page Database Table Limit?David Blomstrom3 Jul