these are linux machines on internet, one is web server and another db server, with real IPs. but I may optionally want to export data to my PC, also on internet connected through LAN to my web server and db server.
thanx for ur time Nitin ----- Original Message ----- From: "Christensen, Dave" <[EMAIL PROTECTED]> To: "'Nitin'" <[EMAIL PROTECTED]>; "Mysql List" <[EMAIL PROTECTED]> Sent: Wednesday, October 08, 2003 10:00 PM Subject: RE: how to export data from multiple tables > What machines are you working with at each end? Internal network? > > -----Original Message----- > From: Nitin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 08, 2003 10:19 AM > To: Andy Eastham; Mysql List > Subject: Re: how to export data from multiple tables > > > any idea, how to export data to a file on the remote machine? > > thanx for the help anyway > Nitin > > ----- Original Message ----- > From: "Andy Eastham" <[EMAIL PROTECTED]> > To: "Mysql List" <[EMAIL PROTECTED]> > Sent: Tuesday, October 07, 2003 9:49 PM > Subject: RE: how to export data from multiple tables > > > > Nitin, > > > > Create a temporary table, then select each table into it in turn, then > > output that to the file? > > > > Andy > > > > > -----Original Message----- > > > From: Nitin [mailto:[EMAIL PROTECTED] > > > Sent: 07 October 2003 11:40 > > > To: [EMAIL PROTECTED] > > > Subject: how to export data from multiple tables > > > > > > > > > Hi all, > > > > > > I've got a small problem (hope it's very small). Could any of you > > > suggest me how to select my data into a simple text file from > > > multiple tables (selected with union)! > > > > > > I've tried: > > > > > > select field-list into outfile filename from table1 > > > union > > > select field-list into outfile filename from table2 > > > union > > > select field-list into outfile filename from table3 > > > > > > It says check your version manual....blah blah > > > > > > Any idea, how to do it? > > > > > > Thanx in advance > > > Nitin > > > > > > > > -- > > 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]