# Creating tables on disk

**URL:** <https://forum.kx.com/t/creating-tables-on-disk/5701>\
**Category:** Community Support\
**Tags:** kdb-and-q\
**Created:** [July 24, 2008, 11:59pm UTC](https://forum.kx.com/t/creating-tables-on-disk/5701 "2008-07-24T23:59:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sk11](https://avatars.discourse-cdn.com/v4/letter/s/848f3c/32.png) [@sk11](https://forum.kx.com/u/sk11)\
**Post date:** [July 24, 2008, 11:59pm UTC](https://forum.kx.com/t/creating-tables-on-disk/5701/1 "2008-07-24T23:59:00Z")

</div>

Received: by 10.114.61.1 with SMTP id j1mr67617waa.7.1216940345039; Thu, 24 Jul 2008 15:59:05 -0700 (PDT)Date: Thu, 24 Jul 2008 15:59:04 -0700 (PDT)X-IP: 141.162.101.50User-Agent: G2/1.0X-Google-Token: QbwmywwAAACPtUqvQDob7pb3j9K\_m4PmX-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022),gzip(gfe),gzip(gfe)Message-ID: \<7d302646-ee0b-470e-8af4-44b64a7c958d@q5g2000prf.googlegroups.com\>Subject: Creating tables on diskFrom: sk To: “Kdb+ Personal Developers” X-Google-Approved: [simon.garland@gmail.com](mailto:simon.garland@gmail.com) via email at 2008-07-25 06:17:13I am a newbie to Kdb+. I would like to move my MySQL db to Kdb+. TheDb size is about 50Gb. I will be running the 32 bit evalaution editionon 4 CPU ~ 8gb ram- sles10 box. I have all my MySQL data in csvformat (Largest table csv file is around 15gb) . I know we can loadcsv files using this commandq)testtable:(“IFSC”;enlist “,”)1:`test.csvbut i am guessing this loads into memory..How do i make it write to adisk? any help would be appreciated.Thanks

---

<div class="post-metadata">

**Author:** ![simon5](https://avatars.discourse-cdn.com/v4/letter/s/6de8d8/32.png) [@simon5](https://forum.kx.com/u/simon5)\
**Post date:** [July 25, 2008, 7:25am UTC](https://forum.kx.com/t/creating-tables-on-disk/5701/2 "2008-07-25T07:25:00Z")

</div>

yes, that would load it into memorysimple save would just be:q)`:savename set testtableorq)`:savename/ set testtableif you want to save it splayedhave a look at:[http://kx.com/q/e/csvguess.qthat](http://kx.com/q/e/csvguess.qthat) includes an option to generate a load script which you can thenuse to incrementally load&save your csvs2008/7/25 sk :\>\> I am a newbie to Kdb+. I would like to move my MySQL db to Kdb+. The\> Db size is about 50Gb. I will be running the 32 bit evalaution edition\> on 4 CPU ~ 8gb ram- sles10 box. I have all my MySQL data in csv\> format (Largest table csv file is around 15gb) . I know we can load\> csv files using this command\> q)testtable:(“IFSC”;enlist “,”)1:`test.csv\> but i am guessing this loads into memory..How do i make it write to a\> disk? any help would be appreciated.\>\> Thanks