# pt-archiver not using --columns specified

**URL:** <https://forums.percona.com/t/pt-archiver-not-using-columns-specified/4609>\
**Category:** Percona Toolkit\
**Created:** [December 16, 2015, 10:26am UTC](https://forums.percona.com/t/pt-archiver-not-using-columns-specified/4609 "2015-12-16T10:26:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![isheedm](https://avatars.discourse-cdn.com/v4/letter/i/9fc348/32.png) [@isheedm](https://forums.percona.com/u/isheedm)\
**Post date:** [December 16, 2015, 10:26am UTC](https://forums.percona.com/t/pt-archiver-not-using-columns-specified/4609/1 "2015-12-16T10:26:55Z")

</div>

I have a table with large blobs in it that I’m trying to move to a new server. I want to move all the records without the blobs first, then I’ll run pt-table-sync later to update the blobs. I used the --columns option in pt-archiver to specify every column except the blob one I want to ignore. However, pt-archiver picked 3 of the columns and didn’t use the other ones I specified.

The command I’m using is:

pt-archiver --progress 1000 --columns=id,document\_id,loadDate,fullName,fileName,fileExtension,type,loadUser,sizeMB --database=db --source … --dest … --no-delete --why-quit --txn-size 500 --where “1=1”

The dry-run shows:

INSERT INTO `db`.`attachments`(`id`,`document_id`,`type`) VALUES (?,?,?)

Why did it only pick these 3 columns? I told it all the columns I wanted…

---

<div class="post-metadata">

**Author:** ![Muneer](https://avatars.discourse-cdn.com/v4/letter/m/cdc98d/32.png) [@Muneer](https://forums.percona.com/u/Muneer)\
**Post date:** [August 16, 2017, 9:25am UTC](https://forums.percona.com/t/pt-archiver-not-using-columns-specified/4609/2 "2017-08-16T09:25:46Z")

</div>

Even I am facing same problem, I think it’s because of column names, it has caps in between the words (fullName) may be pt-archvier doesn’t support it, not sure how to ignore it .

---

<div class="post-metadata">

**Author:** ![carlos.salguero](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/carlos.salguero/32/20_2.png) [@carlos.salguero](https://forums.percona.com/u/carlos.salguero)\
**Post date:** [August 16, 2017, 9:36am UTC](https://forums.percona.com/t/pt-archiver-not-using-columns-specified/4609/3 "2017-08-16T09:36:10Z")

</div>

Could you share the output of

```auto
SHOW CREATE TABLE

```

…?

---

<div class="post-metadata">

**Author:** ![carlos.salguero](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/carlos.salguero/32/20_2.png) [@carlos.salguero](https://forums.percona.com/u/carlos.salguero)\
**Post date:** [August 16, 2017, 1:12pm UTC](https://forums.percona.com/t/pt-archiver-not-using-columns-specified/4609/4 "2017-08-16T13:12:28Z")

</div>

Hi again,

Internally, pt-table-sync is converting all field names to lowercase.  
Use:

```auto
--columns action,minlat,minlon,ipaddr

```

Regards

---

<div class="post-metadata">

**Author:** ![Muneer](https://avatars.discourse-cdn.com/v4/letter/m/cdc98d/32.png) [@Muneer](https://forums.percona.com/u/Muneer)\
**Post date:** [August 17, 2017, 6:05am UTC](https://forums.percona.com/t/pt-archiver-not-using-columns-specified/4609/5 "2017-08-17T06:05:42Z")

</div>

Hi,

I have specified field names in lower case it worked.

Thanks