X-Cart forums

[Nubius]

I believe it says in my sig, but my current version of X-cart is 3.5.4

Our X-cart backup database log is 56mb.....so basically if I were to ever need to use it and restore X-cart I'd be SOL....my current max upload size is 30mb changed from 2mb way back when we first got the store started, however it was the creators who had changed the max upload from 2mb to 30mb....

In what file can I change the max upload size and specify it to whatever I may need....at this current time I'd need to change it to 60mb, but I can foresee in the future needing 75mb or even more.

I'd greatly appreciate anyones help with this as I tried looking for it on my own, but I'm not entirely sure if it's in a .php file or one of the template files.

[Jon]

From what I understand it needs to be edited in php.ini

[levrik]

that seems kinda big for a database - if you haven't lately, it sounds like now is a good time to go and optimize your database.

Also, you might want to consider going to a filesystem for your image storage instead of storing them in your database (if you aren't already). When I did that, I cut my database size in half. THEN I went in and optimized it to realize the space saving.

[Nubius]

What kind of optimizing are you specifically speaking of?

I've just basically made sure theres no dead products floating around in the database and things like that, that may be taking up unnecessary space.

I just changed it from the database to filesystem and it took it from 56mb to 42mb but it's still higher than the 30mb max that's currently set =/

Also when "php.ini" is said, what file is that specifically, because I'm not finding any "php.ini"


I thank you both for taking the time to answer this

[levrik]

Nubius - removing dead products is good, but it's kinda like remove product information in your registry - it's gone, but the space is still taken (also kinda like a file after you delete it - the space is available, but still taken by the file) so you need to optimize the database.

Go into your mySQL administration console and click on the name of your database (my site is www.piptp.com, so my database name is piptp) - off to the right, it will show you all your tables and how much overhead there is - the overhead is what you want to get rid of. When you find a table that has a certain level of overhead (I usually did over 20k), click on the amount of overhead - it will open up a new page and from there (in the middle) you can choose to "Optimize Table"

You want to specifically look for the xcart_images and xcart_session_data (version 3.5.14) and optimize those. When I moved from images in the database to the file system, it had alot of overhead in xcart_images. The session data (I would imagine - my site is not live yet) table looks to continually grow, so that might be a weekly or monthly task.

Let us know if that helped!

Also, I went and looked at your site - very nice. Did you know that when you view a category, that becomes the title of your page? (For example, when you're at 27th Avenue :: Kitchen & Dining, the title is "- Kitchen & Dining." It looks a little strange with the hyphen in there)