How so i split .sql file into few parts???

Discussion in 'Site & Server Administration' started by chetanmadaan, Oct 14, 2009.

0
  1. #1
    i have a 100 MB of sql file and i would like it to be into parts.

    i.e. 30 mb each or something else would even work.

    my hosting doesn't allow more then 50 MB.

    and when i open the file into dreamweaver... it kinda hangs there.

    my host doesn't allow shell access.

    is there a way out there?
     
    chetanmadaan, Oct 14, 2009 IP
  2. Natashalein

    Natashalein Peon

    Messages:
    83
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Sure just open your .sql file and edit it with a programm that supports opening large text files like notepad++.Then search for long inserts and then split up the insert parts and copy the header to each part and run them seperately and your done.If you can't handle it on your own i could help you.
     
    Natashalein, Oct 14, 2009 IP
  3. chetanmadaan

    chetanmadaan Active Member

    Messages:
    325
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    55
    #3
    chetanmadaan, Oct 14, 2009 IP