shell_exec with windows/*nix systems?

[N9ne]

 $do = shell_exec("mysql -u$dbusername -p$dbpassword $dbname < $backupfilepath"); 

Would that work on *nix machines and Windows machines? I can't try as I haven't anything set up on the internet, but I've tested that command on my windows computer (winXP) with a chdir command before it to change to the bin dir in mysql folder, and that execution works, but on the net, would that work on a server?

[DR_LaRRY_PEpPeR]

i would use exec() instead of shell_exec() just because it's possible that exec() could work in safe mode.

anyway, it should work (as long as you can exec() stuff etc.) on any server, as long as 1) /path/to/mysql/bin/ is in the path or 2) if you first chdir() to /path/to/mysql/bin/ or you specify that full path in the exec().

[N9ne]

So on any server, I should definitely have a chdir before the exec line, and I should use the exec function instead of shell_exec...

Doesn't sound too hard if that's the right way to do it .

[DR_LaRRY_PEpPeR]

right, a chdir() or use the full path to the mysql, mysqldump, etc. command; although most *nix servers would probably work without it since /path/to/mysql/bin/ is usually in the path.