Koozali.org: home of the SME Server

Problems importing compression files via phpmyadmin in SME.

Offline spyrule

  • ***
  • 50
  • +0/-0
    • http://n/a
Problems importing compression files via phpmyadmin in SME.
« on: November 12, 2007, 05:56:01 PM »
Hello,

 I am using phpmyadmin (latest release), all is well in the sense that all functions work except 1.  When I import compressed files (I've tried, zip, bzip2, gzip file formats), the only response I ever get is "file cannot be read".  However I CAN import .sql files, so I know the import feature does work.  I've also tried the upload directory, which again reads .sql files, but does not see any compression formats.

 my php.ini already has 30MB max upload file size, and memory limits set, and the actual file sizes are about 3-5MB apiece.

 The reason why I would MUCH prefer to use the zip files is because I have well over 500+ .sql files ranging from 500KB to 15MB each.

 Could anybody suggest a test or possible solution to this issue?

 How could I test compression support via php?

 Thank you in advance,

 Spyrule

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Problems importing compression files via phpmyadmin in SME.
« Reply #1 on: November 12, 2007, 07:13:17 PM »
Hello,

 I am using phpmyadmin (latest release), all is well in the sense that all functions work except 1.  When I import compressed files (I've tried, zip, bzip2, gzip file formats), the only response I ever get is "file cannot be read".  However I CAN import .sql files, so I know the import feature does work.  I've also tried the upload directory, which again reads .sql files, but does not see any compression formats.

 my php.ini already has 30MB max upload file size, and memory limits set, and the actual file sizes are about 3-5MB apiece.

 The reason why I would MUCH prefer to use the zip files is because I have well over 500+ .sql files ranging from 500KB to 15MB each.

 Could anybody suggest a test or possible solution to this issue?

 How could I test compression support via php?

 Thank you in advance,

 Spyrule
Did you have a look at the error logs to try and find out why things might not go as you desire? Check the /var/log/messages and the /var/log/httpd/error_log file around the time you tried to see if there are any pointers there.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline spyrule

  • ***
  • 50
  • +0/-0
    • http://n/a
Re: Problems importing compression files via phpmyadmin in SME.
« Reply #2 on: November 13, 2007, 03:11:40 PM »
After running several trials, and re-setups, I honestly think it's a system setting that won't allow the files to be read/decompressed.

I have looked through all the log files, and I find no indicator as to the source of the problem.

 I am tempted to turn on php error reporting to see if I get something from there.

 Any other suggestions ?

 spyrule.