200,000 images to upload help needed

[dajster]

Hi guys, spent 5 - 6 hours the other day uploading 5000 images, I need to upload 200,000 images to the database on my server, having achieved so little in such a long time, I thought someone else must have had this problem before, are there any automation processes for doing this and confirming on DB, it would need to generate thumb, 70% image and full image,any help would be greatly appreciated.

Daj

[ktwenrick]

I used cpmassimport and it works great!! I uploaded over 1000 pictures while i cooked dinner and didn't have to babysit my upload. You just need to make sure your photos are already in folders just like how you will want them to show up in your gallery when you do upload them. If that makes any sense.

heres a link : http://cpg-contrib.org/board/index.php?topic=123.0

[dajster]

Many thanks KT, I ll have a look at this seems very interesting..and may resolve the issues I am having, tried an applet took it an hour to process 6 sets,



Daj

[dajster]

Hey thanks for the link, not really solved the issue, im using mysql version 5 so running into the same problems, and got to much work done in this to change back, anyone got any other ideas ??, as always any help is appreciated.

Daj

[Paver]

There are threads that discuss using MySQL 5 with Coppermine.  I think many of the problems can be solved by simple changes to the database structure (including default values for instance).

[dajster]

Debugged that mass batch script, running a test on it now to see if its compatible with mysql 5, will post it if it works should save a lot of hassle for some folks, thanks for the reply Paver.

Daj