Re: Dumping MySQL result set to a spreadsheet

2004-02-29 Thread Neale Banks 
On Sun, 29 Feb 2004, Joshua Beall wrote:

 I am wondering if anyone can point me to a utility that will let me dump
 the
 result of a MySQL query to a file I can open in MS Excel or (preferably)
 OpenOffice.org Calc.
[...]
 But before I spend any time working on doing that, I am wondering if
 anyone
 knows of a way to do this already?
 
 I am running MySQL 4.0.12-standard on Mandrake 9.2 on the server, and my
 workstation is an XP Pro box.  I use MySQL CC 0.9.1-beta and phpMyAdmin
 2.5.0, but am completely willing to upgrade more recent versions of
 either
 of these tools, or try a new one.

Should we presume you haven't noticed the, admittedly not widely
publicised, Database Access features of OpenOffice.org?  You can use odbc
or jdbc (I can only vouch for the latter, on Linux) to connect to the
mysql server from within OOo.  Should work just fine on your XP box.

To get started, open a new spreadseet (or any other kind of document) and
select View-Data Sources (or F4).  Once you've defined the database
connection and the query your original question reduces to dragging the
query result and dropping it into the spreadsheet :-)

HTH,
Neale.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

disabling wait_timeout?

2004-02-02 Thread Neale Banks 

Can it be done?

I tried to disable this timer with wait_timeout = 0 in my.cnf.

That changed the timeout (as reported by mysqladmin variables) from the
default 28800 to 1.  Tested, it was definitely a one-second timeout :-(

As a hack-around, I've currently got it set to ten days.

Alternatively, where is the bounds for the value of wait_timeout
documented?

Lastly, this is for a long-held JDBC connection from an application server
which could run for days, no, weeks - and gets upset if mysql closes down
the connection (e.g. overnight/weekends). Any suggestions on a better way
to handle this?

Thanks,
Neale.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]