# Sum data is hidden how I can recover

**URL:** <https://discuss.elastic.co/t/sum-data-is-hidden-how-i-can-recover/33447>\
**Category:** Elasticsearch\
**Created:** [November 1, 2015, 12:10am UTC](https://discuss.elastic.co/t/sum-data-is-hidden-how-i-can-recover/33447 "2015-11-01T00:10:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ryodo](https://avatars.discourse-cdn.com/v4/letter/r/b3f665/32.png) [@ryodo](https://discuss.elastic.co/u/ryodo)\
**Post date:** [November 1, 2015, 12:10am UTC](https://discuss.elastic.co/t/sum-data-is-hidden-how-i-can-recover/33447/1 "2015-11-01T00:10:22Z")

</div>

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](http://www.icoz.ma/a.png)

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.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [November 1, 2015, 12:59am UTC](https://discuss.elastic.co/t/sum-data-is-hidden-how-i-can-recover/33447/2 "2015-11-01T00:59:00Z")

</div>

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

> **[Discussions en français](https://discuss.elastic.co/c/in-your-native-tongue/discussions-en-francais)**
>
> Cette catégorie est dédiée aux discussions en français. Elle concerne tout sujet sur n'importe quel projet elastic !

---

<div class="post-metadata">

**Author:** ![ryodo](https://avatars.discourse-cdn.com/v4/letter/r/b3f665/32.png) [@ryodo](https://discuss.elastic.co/u/ryodo)\
**Post date:** [November 1, 2015, 1:19am UTC](https://discuss.elastic.co/t/sum-data-is-hidden-how-i-can-recover/33447/3 "2015-11-01T01:19:50Z")

</div>

its dan

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 5, 2017, 11:41pm UTC](https://discuss.elastic.co/t/sum-data-is-hidden-how-i-can-recover/33447/4 "2017-07-05T23:41:29Z")

</div>