--- Rhino <[EMAIL PROTECTED]> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
