Well, off the top of my head, to achieve a local-forwarding, you'd do
something like:
ssh [EMAIL PROTECTED] -L :localhost:3306 -N &
Remember, "localhost" is resolved after the tunnel is established, so
refers, actually, to the remote machine :) (The -N option simply
obviates the need to pe
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 probl
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 test
inventing false data, just to satisfy your need for a foreign key?
If you'd used auto-increment fields, 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 t
