Help Me In MySQL Server Setting . . .

Discussion in 'Apache' started by hostimizer, May 10, 2010.

  1. #1
    hello friends

    i have detected server installed Linux Cent OS 5

    when i try to upload .sql backup file on my server on .zip format its say error

    i want to add .zip ext on sql server

    before screen short :-

    [​IMG]


    after error screen short : -

    [​IMG]

    Please Help me i want to upload my backup
     
    hostimizer, May 10, 2010 IP
  2. sahabcse

    sahabcse Well-Known Member

    Messages:
    272
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    140
    #2
    extract the .zip file and try to import the .sql dump file.

    #unzip filename.zip
     
    sahabcse, May 10, 2010 IP
  3. hostimizer

    hostimizer Well-Known Member

    Messages:
    548
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    150
    #3
    but i want to upland almost 400 MB .sql

    so i need to enable .zip upload option on my server

    so please tell me steps
     
    hostimizer, May 10, 2010 IP
  4. sahabcse

    sahabcse Well-Known Member

    Messages:
    272
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    140
    #4
    i think .zip mysql dump upload option not possible, so please change the max_upolad limit in php.ini and try to upolad. If you need my support please PM me
     
    sahabcse, May 11, 2010 IP
  5. hostimizer

    hostimizer Well-Known Member

    Messages:
    548
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    150
    #5
    i need to upload .sql file on .zip format on mysqladmin

    i have almost 400 mb sql in part of 20 20mb mb zip
     
    hostimizer, May 12, 2010 IP
  6. tolra

    tolra Active Member

    Messages:
    515
    Likes Received:
    36
    Best Answers:
    1
    Trophy Points:
    80
    #6
    You need the zip extension in PHP to be able to upload zip files, you should be able to find out how if you google for your os and control panel.

    Personally I'd FTP or whatever the files to the server then unzip and import them from the shell:

    mysql -u username -p data-base-name < data.sql

    You need to change the parameters as required.
     
    tolra, May 12, 2010 IP
  7. hostimizer

    hostimizer Well-Known Member

    Messages:
    548
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    150
    #7
    i need to upload .sql backup as a .zip format on mysql
     
    hostimizer, May 13, 2010 IP
  8. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    #8
    please use linux gzip format

    linux and windows zip are different

    so basically u need a tool on windows that can gzip and tar your file

    many such free tools are avaiable

    I hope it helps


    Regards

    Alex
     
    kmap, May 13, 2010 IP
  9. hostimizer

    hostimizer Well-Known Member

    Messages:
    548
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    150
    #9
    i need to add .zip option on my mysql

    any way to add this option threw HWM of SSH if ssh give me commands if WHM give me steps

    please help me in this
     
    hostimizer, May 14, 2010 IP