I created this script in windows and transferred it to linux. Now this script gives me a error. It says no such file or directory in /usr/etc/scripts/script.sql But i have my file in that directory? is it a bracket missing? please check my script dont know where the error is

thanks



/usr/bin/mysql -h localhost -u root ehpadmin < /usr/etc/scripts/script.sql
/usr/bin/mysqldump -h localhost -u root ehpadmin > backup.txt
/usr/bin/mysqldump -h localhost -u root --tab=/usr/etc/scripts/ --fields-terminated-by=";" --lines-terminated-by="\n" --no-create-info ehpadmin Direct_Referral
/usr/bin/mysqldump -h localhost -u root --tab=/usr/etc/scripts/ --fields-terminated-by=";" --lines-terminated-by="\n" --no-create-info ehpadmin Referral_Authorization
/usr/bin/mysql -h localhost -u root ehpadmin < /usr/etc/scripts/truncate.sql

This is probably caused by Windows line throw characters. Take a backup copy of your script (just in case) and convert them with
where myscript.sh is your script.

You also need some continuations. A line is continued by a backslash just ahead of the return.

/usr/bin/mysql -h localhost -u root ehpadmin < /usr/etc/scripts/script.sql
/usr/bin/mysqldump -h localhost -u root ehpadmin > backup.txt
/usr/bin/mysqldump -h localhost -u root --tab=/usr/etc/scripts/ --fields-terminated-by=";" \ --lines-terminated-by="\n" --no-create-info ehpadmin Direct_Referral
/usr/bin/mysqldump -h localhost -u root --tab=/usr/etc/scripts/ --fields-terminated-by=";" \ --lines-terminated-by="\n" --no-create-info ehpadmin Referral_Authorization
/usr/bin/mysql -h localhost -u root ehpadmin < /usr/etc/scripts/truncate.sql

-----------------------------
Steve Stites

i simply just tried to run a more simplier script and it dosent do anything. im new to linux. I click the .bat and run it form the command terminal and nothing happens. The data should move from my Referral_Authorization table to my referralhistory table?????
If i am missing soemthing please let me know

thanks do i ahev to re write this a different way???

.bat file
/usr/bin/mysql -h localhost -u root ehpadmin < /usr/etc/scripts/script.sql

script.sql
INSERT INTO referralhistory(MEMBERID)
select MEMBERID from FROM Referral_Authorization WHERE FORMTYPE ="D";

1) I'm not an expert in MySQL, but in Oracle SQL, single (not double) quotes are used around string literals.
2) You have repeated the word FROM.

So the last statement should be:
It is best to try SQL statements from the command line before putting them into a batch file. That way you can debug them.

I got half the script to work. now i have a piece of script that writes my record from my mysql tbale into a csv file. the code below works in windows. how can i get it to work in linux.


/usr/bin/mysqldump -h localhost -u root --tab=/usr/etc/scripts --fields-terminated-by=";" --lines-terminated-by="\n" --no-create-info ehpadmin referral_authorization


Now am i missing soemthing (brackets etc)becuase this part of my script is suppose to write a csv file???


please help thanks