Can You tell me Please,How to Import a ZIP file into Database?

Discussion in 'Databases' started by RahulSaini, Oct 1, 2012.

  1. #1
    Hello Friends, i have around 34-35 text file in a zip folder, each file have 1 query for creating a table and second is inserting rows...
    when i import this .zip folder then only one file's query exclude..(Import)
    Please Tell me how to do this? i want to run all files query...
    Thanks!
     
    RahulSaini, Oct 1, 2012 IP
  2. nannysingh

    nannysingh Peon

    Messages:
    23
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    hi rahulsaini,
    # Copy it to the server via pscp
    C:\> pscp.exe numbers.sql.gz user@serverhostname:/home/user
     
    nannysingh, Oct 3, 2012 IP
  3. RahulSaini

    RahulSaini Well-Known Member

    Messages:
    222
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    123
    #3
    thanks. I wil try it
     
    RahulSaini, Oct 3, 2012 IP