Command Line Redirect Input - file

[amuskie]

I failed to insert new record to MySQL database thru command line:

RUN("C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe --user=root -- password=root_pwd < c:\new_rec.sql")

If I remove use this one:

RUN("C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe --user=root -- password=root_pwd")

I could get the MySQL console prompt and it seem the redirect "< c:\new_rec.sql" having problem. Any idea how to solve it? Thanks!

[bo8ster]

Try it in a normal dos window first so make sure the command works.

Edited March 10, 2009 by bo8ster

[amuskie]

It works under DOS without any problem.

[bo8ster]

Try

Run("mysql.exe --user=root -- password=root_pwd < c:\new_rec.sql", "C:\Program Files\MySQL\MySQL Server 5.1\bin")

The spaces in the path might be causing issues.

[amuskie]

No luck under:

Run("mysql.exe --user=root -- password=root_pwd < c:\new_rec.sql", "C:\Program Files\MySQL\MySQL Server 5.1\bin")

or

Run("mysql.exe --user=root -- password=root_pwd < c:\new_rec.sql", "C:\Program Files\MySQL\MySQL Server 5.1\bin\")

[bo8ster]

Ok

Put "C:\Program Files\MySQL\MySQL Server 5.1\bin" on the path so when you type mysql --version in a cmd window it works.

Then try this

Run(@ComSpec & " /c mysql.exe --user=root -- password=root_pwd < new_rec.sql", "c:\")

Hope that works

Edited March 10, 2009 by bo8ster

[amuskie]

Still not working.

Note: Added the mysql path and checked "mysql.exe" works under c:\ if I manually run it under dos prompt.

[bo8ster]

Quick question, is the space required between the -- and password? This should be --password instead of -- password like you have for user?

You may also need to specify the database to which the sql file is to be applied on.

[amuskie]

No space after the "--".

The database/table is specified inside the sql file.

[bo8ster]

I'm sorry mate, i'm starting to run out of ideas. I hate it when code should work, but does not. I just know its something small. I don't have mysql to test out on either.

I would look to a MVP for a solution -- they are good with this type of stuff.

Anyone got any ideas?

[James]

Try this, I had a similar problem.

Run(@ComSpec & " mysql.exe --user=root -- password=root_pwd < new_rec.sql", "c:\")

If not that, then perhaps this.

Run("mysql.exe --user=root -- password=root_pwd < new_rec.sql", "c:\")

And if not that then I will look more when I have time to test.

[twostars]

Try this, I had a similar problem.

Run(@ComSpec & " mysql.exe --user=root -- password=root_pwd < new_rec.sql", "c:\")

If not that, then perhaps this.

Run("mysql.exe --user=root -- password=root_pwd < new_rec.sql", "c:\")

And if not that then I will look more when I have time to test.

What? You're adding a space after the "--" and before "password".

This should also work (in Debian that works, not too sure about Windows though - should be no different):

mysql -uroot -proot_pwd < new_rec.sql

[bo8ster]

I see your point but this is not Debin, it is windows. amuskie says it works in a cmd window with spaces so it should work with spaces in AutoIt.