Re: Mysql commands from Linux shell
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
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
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
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
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
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