Re: Using ssh tunnel and mysql

2003-03-11 Thread Rick Mann
on 3/10/03 1:55 PM, Pete Harlan at [EMAIL PROTECTED] wrote: So your db is on foo.bar.com, and that's the machine you're sshing into? If so, then you might try ssh -n -N -L 3307:127.0.0.1:3306 foo.bar.com Since, once on the new host, it's the localhost's IP address you want to connect

Re: Using ssh tunnel and mysql

2003-03-10 Thread Rick Mann
on 3/10/03 9:24 AM, Pete Harlan at [EMAIL PROTECTED] wrote: If you want to connect to localhost via TCP/IP, you have to specify the host by IP address (127.0.0.1), not as localhost. Tried that, it doesn't work. In my case, I call ssh like this: ssh -n -N -L 3307:foo.bar.com:3306 foo.bar.com

mysqldump and InnoDB tables

2003-03-06 Thread Rick Mann
I have a DB where all of the tables are InnoDB, and there are a few straightforward FOREIGN KEY constraints. I would like to use mysqldump to back up the data or move it to another machine. The problem I'm running into is that when I try to import the data using mysql, the data is imported in the

Re: JDBC Connection Pooling Not Quite Right?

2002-11-09 Thread Rick Mann
sql, query ... just to make the filter happy. on 11/8/02 2:30 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: You are missing something, I am afraid. To quite Sun's Javadoc for the PooledConnection class Thank you so much for the quick reply. Now I understand why the implementation of

JDBC Connection Pooling Not Quite Right?

2002-11-08 Thread Rick Mann
Hi. I hope this is the right place to discuss this, now that the drivers are part of the official MySQL stuff. If not, please let me know where I should post this. Thanks. I've been using the 2.0.14 version of the drivers, and just recently switched to using the pooled connections supplied by

Changes to compile successfully on Mac OS X release

2001-04-16 Thread Rick Mann
I'd like to get a minor source change into the next revision of MySQL to make the standard source distribution compile on Mac OS X. I read somewhere to use some diffing tool when providing the bug report, but can't find those instructions. What's the proper way to get the revision into the tree?