Try using MySQL-Front. -----Original Message----- From: Vidhya CS [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 7:17 PM To: [EMAIL PROTECTED] Subject: 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/[EMAIL PROTECTED] This message and any attachments are confidential and intended solely for the addressee. Any unauthorized use, alteration or dissemination is prohibited. Lawyers Access Web (Pty) Ltd. accepts no liability whatsoever for any loss, whether it be direct, indirect or consequential, arising from information made available and actions resulting there from.
