On Tue, 10 Jul 2007 at 12:01 -0000, [EMAIL PROTECTED] confabulated:

On Mon, 9 Jul 2007 at 23:33 -0400, [EMAIL PROTECTED] confabulated:

Just a general question about mysql remote access.

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?

Sure. As long as the account name used to login to MySQL has login access from the remote location.

mysql -host=ip_or_hostname -user=username -password=password dbname < statements.sql

My bad. The command line parameters should have two hyphens:

mysql --host=ip_or_hostname --user=username --password=password dbname < 
statements.sql

-----
 _|_
(_| |
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to