MySQL Command-Line Script

Question

These are the commands I need to execute in a script. The date 2011.02.14 needs to be a parameter:

mysql --user=myusername --password=mypassword  
connect mydatabase  
source /var/www/2011.02.14.sql  
exit

How would I execute a script to do this?

Is the "mysql --user=myusername..." part of the script, or part of the command-line for executing the rest of the script?

Thanks much.

shantanuo · Accepted Answer · 2011-03-01 08:15:49Z

1

Enclose your commands in a here doc

mysql --user=myusername --password=mypassword  << here_doc
connect mydatabase  
source /var/www/2011.02.14.sql  
exit
here_doc

answered Mar 1, 2011 at 8:15

shantanuo

32.6k91 gold badges268 silver badges437 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1