Small PHP Question
Posted: Sun Jun 15, 2003 2:39 am
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" );
?>
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" );
?>