if you include this:
set(:root_db_password) do
Capistrano::CLI.password_prompt "Root DB Password?: "
end
then your task would be:
task :before_migrate, :roles => :db do
run "mysql -u root -p #{root_db_password}"
end
...which is actually a 1/2-assed solution b/c then your command will
immediately echo your carefully hidden password. Lmk if you figure
out how to not echo the command.
btw, you may've already figured this out, but I find it handy to use
here strings to get commands to mysql -- like:
run "mysql -u root -p #{root_db_password} <<< \"create database
my_prod_db character set utf8;\""
--~--~---------~--~----~------------~-------~--~----~
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/capistrano
-~----------~----~----~----~------~----~------~--~---
