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
