I am new to mysql . I was not aware that the default separator in Linux is tab . if so it should be changed to what in solaris . and how I do it , any commands for this or should it be edited manually Thanks Vidhya.
If I have to change the default field separator from tab Kenneth Illingsworth wrote: > Isn't the default field separator in Linux a Tab character? I suspect it is. And, I > also suspect that the default field separator in Solaris is not a Tab character. > Check these out. If these are in fact true, then it might go a long way in > explaining why your import failed. > > >>> Vidhya CS <[EMAIL PROTECTED]> 07/30/03 01:17PM >>> > 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] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]