Sum data is hidden how I can recover


#1

Hi

I have a data base have 57 M data in mysql when i transfer data via this code (php)

    $search_host = '127.0.0.1';
$search_port = '9200';
$index = 'myindex1';
$doc_type = 'tweecoms1';
//hada reste static f 1M
$combien=1000000;
$limit=$_GET['l'];
$re = "select * from tweecoms as Tweecom limit $limit,$combien";
$r=$Acc->Select($re);
while($k=$r->fetch()) {
	$i++;
    $json_doc = array(
        "association_key" => $k['id'],
        "text" => $k['text'],
        "photo" => $k['photo'],
        "lien" => $k['lien'],
        "date" => $k['date'],
        "source" => $k['source'],
        "id_tweecom" => $k['id_tweecom'],
        "nb_retweets" => $k['nb_retweets'],
        "nb_favorite" => $k['nb_favorite'],
        "nb_followers" => $k['nb_followers'],
        "hashtag" => $k['hashtag'],
        "origine" => $k['origine'],
        "acceleration" => $k['acceleration'],
        "influence" => $k['influence'],
        "sentiment" => $k['sentiment'],
        "user_id" => $k['user_id'],
        "post_id" => $k['post_id'],
        $id = $k['id'],
    );
    $text = json_encode($json_doc);
    $baseUri = 'http://' . $search_host . ':' . $search_port . '/' . $index . '/' . $doc_type . '/' . $id;
    $ci = curl_init();
    curl_setopt($ci, CURLOPT_URL, $baseUri);
    curl_setopt($ci, CURLOPT_PORT, $search_port);
    curl_setopt($ci, CURLOPT_TIMEOUT, 200);
    curl_setopt($ci, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ci, CURLOPT_FORBID_REUSE, 0);
    curl_setopt($ci, CURLOPT_CUSTOMREQUEST, 'PUT');
    curl_setopt($ci, CURLOPT_POSTFIELDS, $text);
    $response = curl_exec($ci);
    curl_close($ci);
}
echo "\n \r j'ai fini sa ".$_GET['l'];

i have just 45 225 890 data look image clic to see image

how i can put all of my data in elastic and what's this docs: 45 225 890 (55 568 524) i have in my elastic 45 225 890 data or 55 568 524 data

English is not my native language, sorry for any mistakes.


(David Pilato) #2

In case you prefer speaking french you have a dedicated group for it.


#3

its dan


(system) #4