php mysql scripts

Jzocco

Okay i think i have a script thats supposed to run a mysql restore command in shell but it doesn't work i wanted it to be able to pick the file run gzip on it then run the mysql restore command in shell but it wont work

Heres my script

<HTML>
<TITLE>Mysql Restore</TITLE>
<CENTER><B><FONT SIZE=32>Mysql Restore</FONT></B></CENTER>

<?php
$backupFile = filename
$command = "mysql -user -password database | gzip > $backupFile";
system($command);
?>
</HTML>

Thats the entire script if some one could possibly tell me what im doning wrong, or maybe fix the script for me i would be ever so greatful

Thanks!

leatherback

you forgot to set the filename, it just says filename.

Jzocco

i understand i wanted the browse box above that to get the filename

leatherback

Hm...

OK. I feel you should have been posting in newbies..

You have no experience with PhP, do you?

OK.

PHp lives on the webserver. However, the upload box 'lives' on the clients computer (The user). So.. your script runs before the user even sees the upload box.

You need to split this up, say in 2 pages. On with the form, which posts the file to the next.

In the processing page, you need to get the filename from the posted file array

However, this is a bit more complex then how you think it goes. I suggest you read this
first before you proceed.