[thelist] remedial help with mysqldump and mysqlimport

[Canfield, Joel]

i must be making some fundamental mistake here.

two databases, cdrdb and cdrtest (v4.1 on Win XP)

identical layout, different data (overlapping, but cdrdb is older,
cdrtest is newer)

dumped table 'session' from cdrtest, 94K records
cdrdb has 70K records
moved dumped file to cdrdb directory
mysqlimport reports 94K lines replaced
cdrdb still only has 70K records; nothing seems to have happened.

here are the commands for the dump and the import:

C:\Program Files\MySQL\MySQL Server 4.1\bin>
mysqldump --no-create-info --user=MyUser --password=MyPassword --quick
--result-file=session --verbose cdrtest session
-- Connecting to localhost...
-- Retrieving table structure for table session...
-- Sending SELECT query...
-- Retrieving rows...
-- Disconnecting from localhost...

C:\Program Files\MySQL\MySQL Server 4.1\bin>
mysqlimport --replace --verbose  --user=MyUser --password=MyPassword
cdrdb session
Connecting to localhost
Selecting database cdrdb
Loading data from SERVER file: session into session
cdrdb.session: Records: 94968  Deleted: 94968  Skipped: 0  Warnings:
3893688
Disconnecting from localhost