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 wai

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:

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

automating import process

2002-08-04 Thread sql_newbie
Hi, I want to try to automate a phonebook list import process into MySQL database. The phonebook was originally created with MS Access and exported into a text file. I upload that text file onto my server and I proceed with the following import process. Using Telnet I type: # ./mysql -u 'root'

error message?

2001-09-19 Thread sql_newbie
Hi, I am trying to use PHP and MySQL together on a script that I installed. I got an error message of the following on my browser when I try to execute the PHP file: Warning: Supplied argument is not a valid MySQL result resource in /usr/local/apache/htdocs/authen/authlib/backend.php on line 98