469,604 Members | 2,358 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,604 developers. It's quick & easy.

Import databse ?

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

Jul 19 '05 #1
0 1838

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Vidhya CS | last post: by
reply views Thread by Mario Ohnewald | last post: by
2 posts views Thread by Retheesh | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.