Loading...
 
Features / Usability

Features / Usability

Forum List Topic List

Forums » Features / Usability » Convert between file storage methods
 
Thread actions
PDF Print this page
  • Print all pages

    • Convert between file storage methods

    Posted by iulianv posts: 5 Romania

    Hello everyone,

    Is there an easy way, in Tiki 24, to change how objects in galleries are stored (disk files or MySQL) without affecting existing pages?

    Also, when it comes to displaying pages containing many images (like hundreds, each ranging from tens to hundreds of kilobytes in size), is there a storage method that provides faster page loading than the other?

    Thank you.

    Reads: 459
    Link
    Posted by Bernard Sfez / Tiki Specialist posts: 8633 Israel

    Hello iulianv,

    In the admin control panel "File Galleries" (tiki-admin.php?page=fgal) you can set where your file from the Tiki file gallery should be stored. If you use the file Id to insert them in your Wiki page, it doesn't matter where they are stored.

    If you use an URL as path to point to an image... Then you will need to point to the right directory on your system.

    Screenshot 2023 12 30 At 8.17.12

    Link
    Posted by iulianv posts: 5 Romania

    Hi Bernard,

    But if I started my Tiki with MySQL gallery storage and created a few pages with lots of images stored in MySQL, won't those pages get broken when I switch to file storage?

    Bernard Sfez / Tiki Specialist wrote:

    Hello iulianv,

    In the admin control panel "File Galleries" (tiki-admin.php?page=fgal) you can set where your file from the Tiki file gallery should be stored. If you use the file Id to insert them in your Wiki page, it doesn't matter where they are stored.

    If you use an URL as path to point to an image... Then you will need to point to the right directory on your system.


    Link
    Posted by iulianv posts: 5 Romania

    Image references in pages do indeed use fileId (like {"img fileId="2"}).

    So, if image with id 2 is now stored in MySQL, after I change the storage method from DB to file this image id 2 will still be looked for in MySQL, but new images will be uploaded to filesystem and their ids referenced there?

    If so, does that mean that after hypothetically switching between MySQL and filesystem storage a number of times, each image id will still be remembered and referenced to its storage location (file or DB) at the time of its upload, and I can have a mix of DB- and file-stored images?

    Bernard Sfez / Tiki Specialist wrote:

    If you use the file Id to insert them in your Wiki page, it doesn't matter where they are stored.

    Paste here the code of your image inserted in a page. 🤷🏻‍♂️

    Link
    Posted by Josue Zirimwabagabo posts: 2 Democratic Republic of the Congo
    Bernard Sfez / Tiki Specialist wrote:

    It means that your Wikiplugins is looking for image id2.
    No matter where it is stored, Tiki should keep track of it.

    When you switch from file storage in the db to file storage in filesystem, at the same place (admin panel) you have an option to move images from db to filesystem. Once done all will be there. 🤗


    Hey Bernard! Please ignore this message. Just want to confirm https://dev.tiki.org/item8573

    Screenshot 2023 12 30 At 8.17.12

    Link