Bart De Man wrote: > Hello Michiel, > > Thanks for your answer. How do I configure the system to use disk files > instead of blob fields?
You place a file config/storage/databases/mysql.xml (take it from mmbase.jar), and add: <option name="database-stores-binary-as-file" /> In 1.7 it is similar, but you have to place it somewhere under WEB-INF/classes (to hide the one in the mmbase.jar). Then, restart, and go to the admin-pages mmbase/admin->admin->blobs and click on the 'convert' button. Then cross your fingers. If step 1 did not succeed it will report that the database is not configured for blobs on disk. After that, check if images and attachments are still working. If everything seems ok (also try to create news ones and so on), you can alter your tables (drop the handle fields). I've done it a few times, though perhaps not with 1G with data. Michiel -- Michiel Meeuwissen mihxil' Peperbus 107 MediaPark H'sum []() +31 (0)35 6772979 nl_NL eo_XX en_US _______________________________________________ Users mailing list [email protected] http://lists.mmbase.org/mailman/listinfo/users
