mysql batch file won't work... bug?

Red Squirrel · 08-22-2004, 09:24 PM

ok this is weird... I'm trying to execute a script and this is what I get:

Code:

[root@mailserver temp]# ./scadalog_put
: No such file or directoryta/shared/scadadump.sql
: command not founde 2: 
[root@mailserver temp]#

The script is:

Code:

/usr/local/mysql/bin/mysql -h localhost -D business -uroot -p12345678 </data/shared/temp/scadadump.sql

All the paths are right since if I do it manually it works.

Anyone know what the heck is going on? Should I just reinstall red hat, since obviously something is way wrong. command not founde !?

More BS behaviour:

Code:

echo restoring forum...
/usr/local/mysql/bin/mysql -u root -p12345678 -h localhost iceteks_reliexec</data/shared/temp/forum.sql

echo restoring articles
/usr/local/mysql/bin/mysql -u root -p12345678 -h localhost iceteks_articles</data/shared/temp/articles.sql

echo restoring scada
/usr/local/mysql/bin/mysql -u root -p12345678 -h localhost iceteks_scada</data/shared/temp/scada.sql

echo restoring front page news
/usr/local/mysql/bin/mysql -u root -p12345678 -h localhost icetek_frontpagenews</data/shared/temp/news.sql

echo done

WTF? If I copy and paste it in the console, it works... but I don't want to do that, I want to be able to just type the script name and boom, it executes all of it.

Oh and it keeps referring to lines that don't even have anything in them.

Code:

restoring forum...
: No such file or directory /data/shared/temp/forum.sql
: command not found line 3: 
restoring articles
: No such file or directory /data/shared/temp/articles.sql
: command not found line 6: 
restoring scada
: No such file or directory /data/shared/temp/scada.sql
: command not found line 9: 
restoring front page news
: No such file or directory: /data/shared/temp/news.sql
: command not found line 12: 
done
: command not found line 14:

If I just remove the spaces, it still screws around with me.

Code:

restoring forum...
: No such file or directory /data/shared/temp/forum.sql
restoring articles
: No such file or directory /data/shared/temp/articles.sql
restoring scada
: No such file or directory /data/shared/temp/scada.sql
restoring front page news
: No such file or directory /data/shared/temp/news.sql
done
[root@mailserver temp]#

This thing is screwed up real good. Is there a way I can fix this? Do I need to reinstall anything? Obviously something is WAY wrong. And everything is right, I checked a million times. I can open those paths no problem so I have no clue what the hell it's trying to say that it's "not founde" (spelling mistake too)

AltF4 · 08-22-2004, 09:47 PM

try putting this in the first line of your script:
--------------------------------------------
#!/bin/sh
your script here ....
--------------------------------------------

Red Squirrel · 08-22-2004, 10:10 PM

What does that mean?

Tried it but I just get:

: bad interpreter: No such file or directory

AltF4 · 08-22-2004, 10:17 PM

linux needs to know the interpreter used to run your script

-) test your script with "bash ./scadalog_put"

-) add a single ":" character or "#!/bin/bash" as the first (!) line of your script

Red Squirrel · 08-22-2004, 10:22 PM

Tried all, still no luck. same errors.

Red Squirrel · 08-22-2004, 10:37 PM

BTW I have a ton of other scripts and they work fine, but suddently new ones that I make just decided to start acting up on me like this. It's a real piss off. I think the only solution is to do it manually every time, maybe I can just keep the lines in a file and I just copy and paste them each time. Scripts pretty much defeat their own purpose if they don't even work with all commands.

AltF4 · 08-23-2004, 01:21 PM

did you edit the scripts under MSDOS ?

try "cat -v scriptname" and look for "^M"

"unix2dos" can convert dos <--> unix

Red Squirrel · 08-23-2004, 04:29 PM

No I just used winsyntax which is a text editor for windows, then I uploaded it using ssh. To make small changes I use vim through ssh.

AltF4 · 08-23-2004, 05:01 PM

that's it

once it's in DOS format, vim keeps dos format

use "dos2unix myscript" to convert to unix format and retry