>>TAC for the NMS using the database adviced me not to use a msqlclient for it, >>that it could break the database???
You are being given a false argument. If the application which connects to MySQL is running on that windows box then there already is a MySQL client on that machine, albeit a specialized one. Putting a plain old client console on that same box does not hurt anything, not even security unless you leave a text file full of passwords laying around. Having that console on the same host as the application is invaluable not only for data-dumping jobs like this one, but for all kinds of trouble shooting in general. - michael dykman On Tue, Jan 5, 2010 at 8:42 AM, ishaq gbola <ishaq...@yahoo.co.uk> wrote: > Am running windows on my local host and Redhat linux on the remote server, I > have no mysql client on local host. TAC for the NMS using the database > adviced me not to use a msqlclient for it, that it could break the database??? > > --- On Tue, 5/1/10, sureshkumar...@gmail.com <sureshkumar...@gmail.com> wrote: > > From: sureshkumar...@gmail.com <sureshkumar...@gmail.com> > Subject: Re: Exporting the result of a Query into excel > To: "ishaq gbola" <ishaq...@yahoo.co.uk>, mysql@lists.mysql.com > Date: Tuesday, 5 January, 2010, 13:37 > > Hi > What is the OS you are using on the remote and local server. > Is there a mysql client on local server? > > Thanks > Suresh Kuna > Sent from BlackBerry® on Airtel > > -----Original Message----- > From: ishaq gbola <ishaq...@yahoo.co.uk> > Date: Tue, 5 Jan 2010 13:31:59 > To: <mysql@lists.mysql.com> > Subject: Re: Exporting the result of a Query into excel > > Thanks a lot for that, but where does this file get saved in and how can i > copy it to my local host if the database is on a remote server > > --- On Tue, 5/1/10, Jay Ess <li...@netrogenic.com> wrote: > > From: Jay Ess <li...@netrogenic.com> > Subject: Re: Exporting the result of a Query into excel > To: "mysql@lists.mysql.com >> Mysql" <mysql@lists.mysql.com> > Date: Tuesday, 5 January, 2010, 13:22 > > ishaq gbola wrote: >> Hi all, >> >> I would like to know if there is a tool or command in mySQL that allows one >> to export the result of query into excel formart >> > select * from table into outfile "thefile.txt"; > That can be imported into excel using CSV and using "TAB" as separator. > http://code.anjanesh.net/2007/12/export-mysql-data-to-excel-compatible.html > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql?unsub=ishaq...@yahoo.co.uk > > > > > > > > > > -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org