extract .sql file

Discussion in 'Databases' started by peppy.gal88, Feb 4, 2010.

  1. #1
    i have a .sql file and i need to extract data from it. I am using xampp server and it allows extracting maximum 16MB file. Can some1 help me to extract data from the file via some method
     
    peppy.gal88, Feb 4, 2010 IP
  2. hireme

    hireme Member

    Messages:
    58
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    45
    #2
    hmmmm so is the db more than 16mb? if so, just break it up to smaller pieaces (tables by tables).
     
    hireme, Feb 4, 2010 IP
  3. peppy.gal88

    peppy.gal88 Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    but how do i open it?? only then can i break it rite...
     
    peppy.gal88, Feb 4, 2010 IP
  4. hireme

    hireme Member

    Messages:
    58
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    45
    #4
    you can open it using text
     
    hireme, Feb 4, 2010 IP
  5. peppy.gal88

    peppy.gal88 Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    but im not able to open it as text. its not opening..:(
     
    peppy.gal88, Feb 5, 2010 IP
  6. Rudolf Bodocsi

    Rudolf Bodocsi Peon

    Messages:
    69
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Rudolf Bodocsi, Feb 6, 2010 IP
  7. vntutor

    vntutor Peon

    Messages:
    1,721
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    0
    #7
    What data do you want to extract? It is only a text file which you can read in a text editor.
     
    vntutor, Feb 6, 2010 IP
  8. CNETpro

    CNETpro Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Try the navicat . It dump your .sql file easily and quickly.
     
    CNETpro, Feb 8, 2010 IP
  9. ar30067

    ar30067 Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Open it by using Mysql Administrator and restore it
     
    ar30067, Feb 10, 2010 IP
  10. burhankhan

    burhankhan Well-Known Member

    Messages:
    489
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    108
    #10
    Search on google with query "big sql dump".
     
    burhankhan, Feb 13, 2010 IP
  11. halo636

    halo636 Peon

    Messages:
    59
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #11
    If I was you I would create it on a different server to extract data if it is only allowing a set amount.

    Use navicat, make a new database, right click on it and click restore from dump and then browse to the .sql file.

    If that isn't what you want then double click it, if it asks what program to open with select notepad or wordpad etc.
     
    halo636, Feb 13, 2010 IP
  12. chengary

    chengary Banned

    Messages:
    88
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #12
    big sql dump
     
    chengary, Feb 19, 2010 IP
  13. Bohra

    Bohra Prominent Member

    Messages:
    12,573
    Likes Received:
    537
    Best Answers:
    0
    Trophy Points:
    310
    #13
    i would say import into phpmyadmin and export the stuff u need
     
    Bohra, Feb 19, 2010 IP