Re: Mysql commands from Linux shell

2001-04-21 Thread Peter van Dijk

On Fri, Apr 20, 2001 at 12:03:22PM -0300, Fabio Galarraga wrote:
 Hi to all:
 I have a linux script and I need it can execute some mysql commands.
 Is it possible? If possible, how?

http://www.dataloss.nl/dteq/

(you probably want to disable DEBUGging in the Makefile).

Greetz, Peter.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Mysql commands from Linux shell

2001-04-20 Thread Fabio Galarraga

Hi to all:
I have a linux script and I need it can execute some mysql commands.
Is it possible? If possible, how?

Best regards,
Fabio Galarraga
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Mysql commands from Linux shell

2001-04-20 Thread Steve Ruby

Fabio Galarraga wrote:
 
 Hi to all:
 I have a linux script and I need it can execute some mysql commands.
 Is it possible? If possible, how?
 
 Best regards,
 Fabio Galarraga
 [EMAIL PROTECTED]


see 
mysql --help

you probably want

mysql -e "SQL code here" dbname

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Mysql commands from Linux shell

2001-04-20 Thread Robert Vetter



Fabio Galarraga wrote:
 
 Hi to all:
 I have a linux script and I need it can execute some mysql commands.
 Is it possible? If possible, how?

Simply put the SQL commands in a text file. To execute them in the bash
script you use the mysql client program:

mysql -u user -p password the_database  the_sql_commands_file.sql

Robert

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Mysql commands from Linux shell

2001-04-20 Thread Mikel

yes absolutely...look into mysqlbackup
(http://www.ocsny.com/main/index.ocs?url=osl ) for an example.

Cheers,
Miekl

Fabio Galarraga wrote:

 Hi to all:
 I have a linux script and I need it can execute some mysql commands.
 Is it possible? If possible, how?

 Best regards,
 Fabio Galarraga
 [EMAIL PROTECTED]

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Mysql commands from Linux shell

2001-04-20 Thread Gerald Clark

Except, leave out the space bhetween the -p and the password, or put the
userid
and the password in your .my.cnf file.
Robert Vetter wrote:
 
 Fabio Galarraga wrote:
 
  Hi to all:
  I have a linux script and I need it can execute some mysql commands.
  Is it possible? If possible, how?
 
 Simply put the SQL commands in a text file. To execute them in the bash
 script you use the mysql client program:
 
 mysql -u user -p password the_database  the_sql_commands_file.sql
 
 Robert
 
 -

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php