From owner-freebsd-questions@FreeBSD.ORG  Tue Jul 10 11:57:30 2007
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id D189416A400
	for <freebsd-questions@freebsd.org>;
	Tue, 10 Jul 2007 11:57:30 +0000 (UTC)
	(envelope-from yuri@darklight.org.ru)
Received: from darklight.org.ru (darklight.org.ru [194.186.18.14])
	by mx1.freebsd.org (Postfix) with ESMTP id E9A3313C468
	for <freebsd-questions@freebsd.org>;
	Tue, 10 Jul 2007 11:57:29 +0000 (UTC)
	(envelope-from yuri@darklight.org.ru)
Received: from darklight.org.ru (yuri@darklight.org.ru [127.0.0.1])
	by darklight.org.ru (8.14.1/8.14.1) with ESMTP id l6ABv4dJ026524
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Tue, 10 Jul 2007 15:57:05 +0400 (MSD)
	(envelope-from yuri@darklight.org.ru)
Received: (from yuri@localhost)
	by darklight.org.ru (8.14.1/8.14.1/Submit) id l6ABv3G3026523;
	Tue, 10 Jul 2007 15:57:03 +0400 (MSD)
	(envelope-from yuri@darklight.org.ru)
Date: Tue, 10 Jul 2007 15:57:03 +0400
From: Yuri Pankov <yuri@darklight.org.ru>
To: fbsd2 <fbsd2@a1poweruser.com>
Message-ID: <20070710115703.GB95578@darklight.org.ru>
References: <NBECLJEKGLBKHHFFANMBIELHCEAA.fbsd2@a1poweruser.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="dDRMvlgZJXvWKvBx"
Content-Disposition: inline
In-Reply-To: <NBECLJEKGLBKHHFFANMBIELHCEAA.fbsd2@a1poweruser.com>
User-Agent: Mutt/1.5.16 (2007-06-09)
X-Greylist: Sender is SPF-compliant, not delayed by milter-greylist-3.0
	(darklight.org.ru [127.0.0.1]);
	Tue, 10 Jul 2007 15:57:05 +0400 (MSD)
Cc: "freebsd-questions@FreeBSD. ORG" <freebsd-questions@freebsd.org>
Subject: Re: accessing mysql server remotely
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 10 Jul 2007 11:57:30 -0000


--dDRMvlgZJXvWKvBx
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Mon, Jul 09, 2007 at 11:40:07PM -0400, fbsd2 wrote:
> Just a general question about mysql remote access.
>=20
> Is it possible to login to my remote mysql server and create a
> new db & table using a file on the local system which contains
> the definition statements?
>=20
> Thanks
>=20

Of course, it's possible. It's the same as you would use it locally,
with added hostname parameter:

mysql -h <hostname> -u <username> -p <dbname> < yourfile.sql

(that's basic syntax, check mysql(1) manpage).

HTH,
Yuri

--dDRMvlgZJXvWKvBx
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (FreeBSD)

iD8DBQBGk3QKeoAklVFrLdgRAv/YAKCZrYSwmDGIBAtthJAZxtpnOnBgFwCfVmwf
aSJq6YaO1Co07QHlGu5EURU=
=J5tQ
-----END PGP SIGNATURE-----

--dDRMvlgZJXvWKvBx--