| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | Mark Forums Read | User manuals | Login |
getting pics out of db | ||||
|
|
Thread Tools | Search this Thread |
#31
|
|||||||||
|
|||||||||
I don't know if this will help anyone here, but I have just performed the dreaded move images to the file system (if only we knew this when we started). Anyway, when I first did it, I thought that the images were still in the DB and as others have done, deleted them only to find they were no longer in the shop.
My point is this, when I checked carefully, it only appears that the images are still in the DB, when in fact they are now just references to the images now on the server. The DB no longer has the massive Blob data just the new file locations, so should be smaller. Like others, I was worried about doing this operation with the fear of it failing and having to reload tons of photos, but followed the help here and it was fine. Paul Dodman e-business consultant Lumino Internet luminointernet.co.uk
__________________
Paul Dodman e-business & m-commerce consultant w: www.luminointernet.com e: xcart@luminointernet.com Professional X-Cart help, advice, support and services, specialists in Mobile X-Cart. |
|||||||||
#32
|
|||||||||
|
|||||||||
I am glad that help you.
Now you can always look at your logs to see if they were moved from the DB to the FS. If it did not move it will be label as "FAILED" Kind regards, Ricky[/b]
__________________
X-CART Gold version 4.0.14 & 4.1.11 Apache Version 1.3.29 (Unix) EWDHosting-Quality X-cart Hosting We will always sell you the right shoe and the left one is free. |
|||||||||
#33
|
|||||||
|
|||||||
I'm getting ready to move images out of the DB. Below is the current stats:
# products: ~3000 Thumbnails: 34MB Images: 113MB Those that have successfully moved to the filesystem are there any problems with larger stores? Am I going to have to worry about timing out or anything with these numbers? I'm of course going to backup before doing this but I wanted to ask first. thanks!
__________________
----------------------- x-cart v4.7.6 [LIVE] x-cart v4.0.18 [retired 2004-2016] x-cart v3.5.13 [retired] x-cart v3.4.14 [retired] |
|||||||
#34
|
|||||||
|
|||||||
Ok, I tried this on a backup which went OK without any problems so I did it on the live site. No problems and my DB has changed from ~190MB to ~30MB.
Thanks again for all your help! Now I just have to change my cron job to zip up the images weekly..
__________________
----------------------- x-cart v4.7.6 [LIVE] x-cart v4.0.18 [retired 2004-2016] x-cart v3.5.13 [retired] x-cart v3.4.14 [retired] |
|||||||
#35
|
|||||||
|
|||||||
Here is my issue, we created a new website called exercise wisdom and xcart (ver 4.0.10), we have an existing website called vitaman cafe with an older cart (ver 3.5.1), we have now decided that we want to take our old cart, that is on a different site, and delete is and install a new cart (ver 4.0.10) export all the data and images from the exercise wisdom site and import it into the newer vitaman cafe site.
Is this possible, whats the easiest way? We tried and were able to export the csv but doesnt contain paths to images, we also managed to export the images and copied them over thanks to these posts. The images were originally stored in the database. We were able to import the products but not the images. I could use some help
__________________
http://www.VitaManCafe.com There is Nothing \"General\" about our Nutrition Center! X-Cart version 3.5.1 | Operation System Linux http://www.exercisewisdom.com X-Cart Gold Version 4.0.1 | Operation System Linux |
|||||||
#36
|
|||||||||
|
|||||||||
Hi all like everyone I attempted the move from db to fs. Followed instructions as directed. Here are the errors that I receive:
Warning: Cannot modify header information - headers already sent by (output started at /home/simply4/public_html/config.php:666) in /home/simply4/public_html/referer.php on line 61 Warning: Cannot modify header information - headers already sent by (output started at /home/simply4/public_html/config.php:666) in /home/simply4/public_html/include/get_language.php on line 134 Warning: Cannot modify header information - headers already sent by (output started at /home/simply4/public_html/config.php:666) in /home/simply4/public_html/include/get_language.php on line 135 Can someone please lend a hand none of my store's images are appearing. Thanks
__________________
X-Cart pro v4.0.17 X-Cart pro v4.1.6 X-Cart pro v4.2 |
|||||||||
#37
|
|||||||
|
|||||||
Log on to cpanel, go into this file:
Quote:
And make sure there are no blank lines at the end. If there are, delete them, save it, and then try again
__________________
Danielle X-Cart Pro 4.0.10 X-Gift-Registry X-AOM |
|||||||
#38
|
|||||||||
|
|||||||||
Thanks guys the problem was resolved the 'config.php' file had several blank lines at the end. Removed them and its working again.
__________________
X-Cart pro v4.0.17 X-Cart pro v4.1.6 X-Cart pro v4.2 |
|||||||||
#39
|
|||||||
|
|||||||
Wonderful!!! Isn't it nice when it's an easy fix
__________________
Danielle X-Cart Pro 4.0.10 X-Gift-Registry X-AOM |
|||||||
|
Thread Tools | Search this Thread |
|
|
|
|||
X-Cart forums © 2001-2020
|