Problem downloading EP file

[port27374]

Hi Folks,

 

I have a site which is in a shared web hosting environment, it started of quiet small and has been modified quiet heavily with STS and add ons(still on V2.2 RC2a), however, with the combination of products and categories the site has grown to over 70,000 products. At some point in the near future i was thinking about moving this to a dedicated server as the site is quiet slow... however when i try to download a complete CSV file, my ISP server times out... with the following message:

 

Fatal error: Out of memory (allocated 50593792) (tried to allocate 48760518 bytes) in /home/website/public_html/admin/easypopulate.php on line 2689

 

I have tried all the different ways listed on the EP backend interface, I can download partial files (for example product name/descrition etc...) but it doesnt correlate because the same product has been duplicated into the category structure dozens of times. so when i download the category file, it has many fields corresponding to one product. In effect i am trying to move the whole structure over. Including the products.

 

Due to a previous server crash and a series of unfortunate circumstances at our company i am unable to retrieve the orignal EP files which were used to create these items in the first place.

 

The other problem is, that some of th products in the database are now obsolete, so for example, i have one product which is compatible with about 1300 categories, to remove this manually is impossible, is their anyway of editing the database directly through phpmyadmin in which i can remove or add products like this?

 

My EP settings are as follows:

 

EP vers: 2.76g-MS2

osCommerce Online Merchant v2.2 RC2a

OS: Linux 2.6.28.9

HTTP: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635

DB: MySQL 5.1.30

PHP: 5.2.9 (Zend: 2.2.0)

 

Temp Directory:

/home/website/public_html/temp/

Temp Dir is Writable

Magic Quotes is: off

register_globals is: on

Split files on: 300 records

Model Num Size: 20

Price with tax: false

Calc Precision: 2

Replace quotes: false

Field seperator: comma

Excel safe output: true

Preserve tab/cr/lf: false

Category depth: 7

Enable attributes: true

SEF Froogle URLS: false

More Pics: false

Unknown Pics: false

HTC: false

SPPC: false

Extra Fields: false

 

 

my question is, what is the easiest and quicket way of me retrieving my product data... and downloading or recompiling a complete CSV file. Is their a way to construct a query in phpmyadmin to extract all product info back to a CSV file with the same colum headings as the orignal EP file(s)? if so, how do i make it?:blink:

 

I have tried on several occassions to obtain help from the ISP but they are unsure why there server is timing out like this, a bunch of dodo's as far as i am concerned, but unfortunately i have to put up with them, as we are on contract.

 

I have something called PHP.ini EZ config in my cpanel and i have tried to increase mysql.connect.timeout, post_max-size, memory_limit etc... but to no avail, giving me the same error.

 

As always your viewing and contrbuting is always appreciated...:rolleyes:

 

Kind regards

 

port

[port27374]

Ok guys - just incase anyone else has this problem, i solved it by loading the site on to a local installation of XAMPP, then i could play around with the php.ini files myself, obviously the ISP had an overide on the EZ php config in the Cpanel.

 

In the end the file had over 70,000 products in it and was a 176MB CSV file....