Page 1 of 1

Small PHP Question

Posted: Sun Jun 15, 2003 2:39 am
by jackal
We need a little help with code below, We are dumping mysql db with php file name june.sql.
Problem is the way we are doing it instead of new file everytime it appends the file. We need some coding before the dumping to either clean the file or remove where only the new dump shows up.
Hoping someone can help.

<?
//server part config
$server_dumppath="/home/user/public_html/db/"; //path to dump on server file (must be web acessable, 777 and protected with .htaccess)
$server_mysql_tablename="dbname"; //name of mysql db to dump
$server_mysql_username="dbusrname"; //mysql username
$server_mysql_password="pass"; //guess
//end config
exec("mysqldump -u ".$server_mysql_username." -p".$server_mysql_password." ".$server_mysql_tablename." > ".$server_dumppath."june.sql" );
?>

Posted: Sun Jun 15, 2003 5:05 am
by twigletmac
I've moved this to PHP - Normal because it does not belong in the Advanced forum.

Please read:
Before Post Read: General Posting Guidelines

Mac

Posted: Sun Jun 15, 2003 7:06 am
by jackal
Fixed