mysql - 'RROR 1102 (42000): Incorrect database name 'database name -


i have sh script following:

#!/bin/sh mysqldump -hmy.host.com --user=p387829 --password=pwd -- all-databases > /backup/mysqlall-`/bin/date +\%y\%m\%d\%h\%i\%s`.sql  mysqldump -u p387829 -hmy.host.com --password=pwd --add- drop-table --no-data usr_p387829_1 | grep ^drop | mysql -up387829 - ppwd -hmy.host.com usr_p387829_1  mysqldump -u p387829 -hmy.host.com --password=pwd  usr_p387829_2 | mysql -u p387829 -ppwd -hmy.host.com  usr_p387829_1 

when execute each command individually in shell, works. when execute sh script.sh

warning: using password on command line interface can insecure. warning: using password on command line interface can insecure. warning: using password on command line interface can insecure. 'rror 1102 (42000): incorrect database name 'usr_p387829_1 warning: using password on command line interface can insecure. warning: using password on command line interface can insecure. 'rror 1102 (42000): incorrect database name 'usr_p387829_1 mysqldump: got errno 32 on write 


Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

python - ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'> -

java - How to provide dependency injections in Eclipse RCP 3.x? -