Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

getting pics out of db

 
Reply
   X-Cart forums > Forum FAQs and guides
 
Thread Tools Search this Thread
  #31  
Old 03-01-2005, 04:59 AM
  pauldodman's Avatar 
pauldodman pauldodman is offline
 

X-Guru
  
Join Date: Jul 2003
Location: Spain / UK
Posts: 3,060
 

Default

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.
Reply With Quote
  #32  
Old 03-01-2005, 09:54 AM
  rjcbear's Avatar 
rjcbear rjcbear is offline
 

X-Adept
  
Join Date: Jun 2004
Location: Alabama,U.S.A
Posts: 503
 

Default

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.
Reply With Quote
  #33  
Old 03-12-2005, 02:56 AM
 
nfc5382 nfc5382 is offline
 

X-Adept
  
Join Date: Nov 2002
Posts: 480
 

Default

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]
Reply With Quote
  #34  
Old 03-23-2005, 03:18 PM
 
nfc5382 nfc5382 is offline
 

X-Adept
  
Join Date: Nov 2002
Posts: 480
 

Default

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]
Reply With Quote
  #35  
Old 04-27-2005, 08:53 AM
 
PersonalizedFitness PersonalizedFitness is offline
 

Advanced Member
  
Join Date: Oct 2004
Location: Omaha, Nebraska
Posts: 93
 

Default

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
Reply With Quote
  #36  
Old 06-13-2005, 08:16 PM
  jedak's Avatar 
jedak jedak is offline
 

Senior Member
  
Join Date: Apr 2005
Location: NY
Posts: 149
 

Default

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
Reply With Quote
  #37  
Old 06-13-2005, 08:23 PM
 
Danielle Danielle is offline
 

Senior Member
  
Join Date: Jan 2005
Posts: 138
 

Default

Log on to cpanel, go into this file:

Quote:
Originally Posted by jedak
/public_html/config.php

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
Reply With Quote
  #38  
Old 06-13-2005, 08:38 PM
  jedak's Avatar 
jedak jedak is offline
 

Senior Member
  
Join Date: Apr 2005
Location: NY
Posts: 149
 

Default

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
Reply With Quote
  #39  
Old 06-13-2005, 08:49 PM
 
Danielle Danielle is offline
 

Senior Member
  
Join Date: Jan 2005
Posts: 138
 

Default

Wonderful!!! Isn't it nice when it's an easy fix
__________________
Danielle
X-Cart Pro 4.0.10
X-Gift-Registry
X-AOM
Reply With Quote
Reply
   X-Cart forums > Forum FAQs and guides


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 12:32 PM.

   

 
X-Cart forums © 2001-2020