Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 10 Jul 2007 15:57:03 +0400
From:      Yuri Pankov <yuri@darklight.org.ru>
To:        fbsd2 <fbsd2@a1poweruser.com>
Cc:        "freebsd-questions@FreeBSD. ORG" <freebsd-questions@freebsd.org>
Subject:   Re: accessing mysql server remotely
Message-ID:  <20070710115703.GB95578@darklight.org.ru>
In-Reply-To: <NBECLJEKGLBKHHFFANMBIELHCEAA.fbsd2@a1poweruser.com>
References:  <NBECLJEKGLBKHHFFANMBIELHCEAA.fbsd2@a1poweruser.com>

Next in thread | Previous in thread | Raw E-Mail | Index | Archive | Help

--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--



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?20070710115703.GB95578>