Gaston_Phone
25/11/2010, 09h58
Plus la peine de répondre mAn est partie à la cueillette aux champignons sans nous dire "au revoir".
$db_charset = "latin1"; /* mettre utf8 ou latin1 */
$db_server = "xxxxxx";
$db_name = "xxxxxx";
$db_username = "xxxxxx";
$db_password = "xxxxxx";
$cmd_mysql = "mysqldump";
$archive_GZIP = "Sauve_Base.gz";
echo " Sauvegarde de la base $db_name par mysqldump dans le fichier $archive_GZIP
\n";
$commande = $cmd_mysql." --host=$db_server --user=$db_username --password=$db_password -C -Q -e --default-character-set=$db_charset $db_name | gzip -c > $archive_GZIP ";
$CR_exec = system($commande);
?>
$db_charset = "latin1"; /* mettre utf8 ou latin1 */
$db_server = "xxxxxx";
$db_name = "xxxxxx";
$db_username = "xxxxxx";
$db_password = "xxxxxx";
$cmd_mysql = "mysql";
$archive_GZIP = "Sauve_Base.gz";
echo " Restauration de la base $db_name par mysql depuis le fichier $archive_GZIP
\n";
$commande = "gzip -d < $archive_GZIP | $cmd_mysql --host=$db_server --user=$db_username --password=$db_password $db_name";
$CR_exec = system($commande);
?>
$db_charset = "latin1"; /* mettre utf8 ou latin1 */
$db_server = "xxxxxx";
$db_name = "xxxxxx";
$db_username = "xxxxxx";
$db_password = "xxxxxx";
$cmd_mysql = "mysql";
$archive_SQL = "Sauve_Base.SQL";
echo " Restauration de la base $db_name par mysql depuis le fichier $archive_SQL
\n";
$commande = "$cmd_mysql --host=$db_server --user=$db_username --password=$db_password $db_name < $archive_SQL";
$CR_exec = system($commande);
?>