Import databse ?

[Vidhya CS]

Hi ,
I am trying to export a database from one machine ie linux, and import
the same database to another machine ie ,solaris .

I exported the database using the following command .

mysqldump -c -u vidhya ifmonitor > $HOME/ifmonito.backup.

this is ok , ifmonitor-backup has the table creation info as well as the
table data .

but when I try to import the same database to mysql in solaris m/c
using the command

mysqldump -u vidhya ifmonitor < ifmonitor.backup

It is showing the table creation info , but the actual data is not
dumped .

I am getting the following o/p
-- MySQL dump 9.08
--
-- Host: localhost Database: ifmonitor
---------------------------------------------------------
-- Server version 4.0.14-standard

--
-- Table structure for table 'network'
--

CREATE TABLE network (
device char(16) NOT NULL default '',
timestamp int(14) default NULL,
rx_bytes int(10) unsigned default NULL,
tx_bytes int(10) unsigned default NULL,
rx_drop int(10) default NULL,
tx_drop int(10) default NULL,
KEY timestamp (timestamp),
KEY device (device)
) TYPE=MyISAM;

--
-- Dumping data for table 'network'
--
bash-2.05$
The table has nearly 358 records and those records has not been imported
to ifmonitor database .
how do I correct this .
any idea?
thanks
Vidhya


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw