Re: SSH tunnel for Mysql

2005-11-20 Thread Daniel Walker
Well, off the top of my head, to achieve a local-forwarding, you'd do something like: ssh [EMAIL PROTECTED] -L arbitrary high port no:localhost:3306 -N Remember, localhost is resolved after the tunnel is established, so refers, actually, to the remote machine :) (The -N option simply

Re: not a rpm package?

2005-05-19 Thread Daniel Walker
On Wednesday 18 May 2005 21:27, Bing Du wrote: I downloaded MySQL-server-5.0.4-0.i386.rpm. When I did 'rpm -i MySQL-server-5.0.4-0.i386.rpm', the following message returned: MySQL-server-5.0.4-0.i386.rpm: not an rpm package (or package manifest): What's the problem? Bing The problem is

Re: Single vs Multiple primary keys

2005-05-16 Thread Daniel Walker
, the problem wouldn't arise. Furthermore, auto_increments are just integers: there is very little overhead involved in handling them. Real data is usually either more complex, or is apt to become so at some point in the future. Daniel Walker -- MySQL General Mailing List For list archives: http

Re: output in text file /migration

2005-05-16 Thread Daniel Walker
As for your second question, SELECT INTO OUTFILE (making sure mysql user has write privileges in the directory/file you want to write to). MySQL give the example: SELECT a,b,a+b INTO OUTFILE '/tmp/result.text' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' FROM