1 2 3 4 5 6 7 8 9 10 11 12 13 14
| my ($DB_DEST, $DB_HOST, $DB_USER, $DB_PASS, $DB_DBNAME) = ('C:/temp', 'localhost', 'aq1', 'aq1', 'aq1');
my $programme_dump = File::Spec->catfile('C:/Program Files/MySQL/MySQL Server 5.1/bin/mysqldump.exe');
my $fichier_resultat = File::Spec->catfile($DB_DEST, "$DB_DBNAME.sql");
my $commande = '"' . $programme_dump . '" '
. "--host=\"$DB_HOST\" "
. "--user=\"$DB_USER\" "
. "--password=\"$DB_PASS\" "
. "--single-transaction=\"$DB_DBNAME\" "
. "> \"$fichier_resultat\"";
;
print "[$commande]\n";
system $commande; |