Thanks a lot.. On Tue, Oct 2, 2012 at 12:00 PM, Arun Khan <[email protected]> wrote:
> On Tue, Oct 2, 2012 at 8:30 AM, Karishma Balan <[email protected]> > wrote: > > I got the dataset from Mozilla.. It creates tables and insert data.. I > have > > only the .sql file.. Dont know how to filt > > er out from that.. > > Read the .sql dump file properly. It should have statements to > create tables and define fields within them. It will also have > statements to "insert" data into those tables/fields (some of them can > be default). These 'insert' statements are a NOP for you. > > You can filter out create sql statements since you are only interested > in the db schema, into another file and you will notice that the new > file is much smaller than your 2GB SQL dump. > > I suggest that you brush up on SQL basics (I am not a DBA). > > > On Mon, Oct 1, 2012 at 10:25 PM, Rajagopal Swaminathan < > > [email protected]> wrote: > > > >> Greetings, > >> > >> On Mon, Oct 1, 2012 at 9:29 PM, Karishma Balan < > [email protected]> > >> wrote: > >> > I tried SQLFairy but that couldnt handle the large dataset of More > >> > that 2GB I had.. > > Also, follow list guidelines for follow up postings - > (a) do *not* top post, > (b) *trim* your quotes to relevant text only. > > -- Arun Khan > _______________________________________________ > ILUGC Mailing List: > http://www.ae.iitm.ac.in/mailman/listinfo/ilugc > _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
