I use a script to restore my database to my host, but I can not manage it under xampp, I do not understand or is the problem.
- Code: Select all
$host= 'localhost';
$user= 'root';
$pass= 'my_passl';
$db= 'my_base';
//$db_charset = "utf8";
$chemin = getenv('DOCUMENT_ROOT').'/admin/sauvegarde_mysql/';
// Décompresser le gzip et l'importer dans la base de données
system(sprintf(
'gunzip -c %s/'.$_GET['fichier'].' | mysql -h %s -u %s -p%s %s',
$chemin,
$host,
$user,
$pass,
$db
));
Thank