query($query); //display information: $dir = $DOCUMENT_ROOT . "/dumps/"; $c = 0; while($row = mysqli_fetch_array($result)) { //if($c==2) break; $table = $row[0]; $sql = "mysqldump -u $DB_LOGIN -p$DB_PASS -h $HOST $DB_NAME $table > $dir" . "$table.sql"; exec($sql, $output); echo $table . " created
"; $c++; }