Run shell command with input redirections from python 2.4?

You have to feed the file into mysql stdin by yourself. This should do it.

import subprocess...filename = ...cmd = ["mysql", "-h", ip, "-u", mysqlUser, dbName]f = open(filename)subprocess.call(cmd, stdin=f)

The symbol < has this meaning (i. e. reading a file to stdin) only in shell. In Python you should use either of the following:

1) Read file contents in your process and push it to stdin of the child process:

fd = open(filename,  'rb')try:    subprocess.call(cmd, stdin=fd)finally:    fd.close()

2) Read file contents via shell (as you mentioned), but redirect stdin of your process accordingly:

# In file myprocess.pysubprocess.call(cmd, stdin=subprocess.PIPE)# In shell command line$ python myprocess.py < filename

As Andrey correctly noticed, the < redirection operator is interpreted by shell. Hence another possible solution:

import osos.system("mysql -h " + ip + " -u " + mysqlUser + " " + dbName)

It works because os.system passes its argument to the shell.

Note that I assumed that all used variables come from a trusted source, otherwise you need to validate them in order to prevent arbitrary code execution. Also those variables should not contain whitespace (default IFS value) or shell special characters.