Parrtitioning a sql file

Discussion in 'PHP' started by hendkandeel, Mar 23, 2009.

0
  1. #1
    I have a large sql file exported from an excel sheet
    when import it to a new mysql db it gives an error
    i downloaded a bigdump script to load it
    but i encountered a problem in uploading the large file !!!

    i heared that there is another way to do that
    is to partition the sql file into small parts by some programs

    how can I find this software ??
     
    hendkandeel, Mar 23, 2009 IP
  2. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #2
    crivion, Mar 23, 2009 IP
  3. steelaz

    steelaz Peon

    Messages:
    47
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    You can upload file via FTP and setup bigdump to use local file.
     
    steelaz, Mar 23, 2009 IP
  4. hendkandeel

    hendkandeel Peon

    Messages:
    52
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Dear crivion
    Thank a lot
    I am trying it
     
    hendkandeel, Mar 23, 2009 IP
  5. centralb

    centralb Peon

    Messages:
    26
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    If you're using a web-based tool to import, try gzipping the file.sql dump into file.sql.gz first.

    Importing the db through an SSH shell instead of through the web will work for very large files.

    Avoid FTPing your database if it contains sensitive information, unless your FTP client and the FTP support SFTP or FTPS for secure FTP.

    SSH is a more secure route if you have access.
     
    centralb, Mar 24, 2009 IP