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
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
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
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
The line separator isnt the problem ,
I used mysql -u vidhya ifmonitorifmonitor.sql instead of mysqldump
now all the records got inserted properly.
Thanks .
Vidhya.
Kenneth Illingsworth wrote:
Isn't the default field separator in Linux a Tab character? I suspect it is. And, I
also suspect
Vidhya CS wrote:
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