RE: automating import process

2002-09-29 Thread Iikka Meriläinen
On Sun, 29 Sep 2002 [EMAIL PROTECTED] wrote: The script so far is like this: ./mysql -u 'root' -ppassword use import_test1; When it executes, it just waits at the mysql prompt. It does not seem to recognize that I want to input use import_test1; Can anyone help? Sure! You have to

RE: automating import process

2002-09-28 Thread sql_newbie
Thanks for your help. But now I am stuck on another part. I successfully use the script to login , but it does not respond to the next line of the script which is use import_test1; The script so far is like this: ./mysql -u 'root' -ppassword use import_test1; When it executes, it just

RE: automating import process

2002-09-27 Thread sql_newbie
Hi Carl, Thanks for your reply. I have created a shell script but I get stuck on the part where it asks to input password. How do I get the script to input the password that I put in? So far my script looks like this: ./mysql -u 'root' -p echo abc The script executes, but it just waits for

RE: automating import process

2002-09-27 Thread Iikka Meriläinen
Hi, use this: mysql -u root -ppassword It's important NOT to put a space between -p and the real password. Having a password in a script is unsafe at its best, though. I'm not sure if you have any other options than to put it that way or enter it manually each time you run the script. Regards,

RE: automating import process

2002-09-27 Thread sql_newbie
Thanks for your reply. Just out of curiousity, is it possible to use it by echoing back the password somehow? I think that echoing back the reply would work great if I ever needed any unattended process using scripts. Thanks. Peter On Fri, 27 Sep 2002, [ISO-8859-1] Iikka Meriläinen wrote: