exec("mysql -uusername -ppassword <'export.sql'") return nothing

[andrewxie]

Hi,
when I run
exec("mysql -uusername ppassword<'export.sql'");
on solaris9 it returns nothing.
I also tried
system("mysql -uusername -ppassword <'export.sql'")
it return nothing.
but when I run on windows xp
exec("mysql -uusername -ppassword -e \"source export.sql\"");
it works and returns records.

anybody any idea?

 

[varakal]

Did you try giving the host name in it.

exec("mysql -hxxx.xxx.xxx.xxx -uusername ppassword<'export.sql'");

 

[andrewxie]

yes

 

[varakal]

I am not sure what can be problem from your solaris machine. Make sure that permissions were set appropriately. I tried the same thing from my Linux box with both exec and system, and it worked just fine. Did you try to capture any errors if there are any?

 

[andrewxie]

I find the problem. mysql has to be full path.

thank you anyway.