Architecture / Installation

Posted by Xavier de Pedro 19 May 2014 09:03 GMT-0000 posts: 1817

Hi nikosal:
If you have the option in the new server to import your db from the command line ( mysql -uuser -p new_db < old_db_dump.sql ), then I would suggesst that you upgrade using your second option ("b").

Otherwise, if you have to import your db through phpmyadmin or similar in the new server, then you have to follow your option "a".

More information on how to move files from db to disk:
http://doc.tiki.org/File+Gallery+Config#Move_files_between_them

Remember that image galleries are deprecated, so sooner or later, you will have to move images in them to file galleries in new Tikis.

Posted by nikosal 24 May 2014 15:09 GMT-0000 posts: 98

Ok, I tried option (a) today and it seems I am bit confused. Please see why:
(a) I created a file gallery in admin->features. I called it Testing_file_gallery
(b) I went to admin->file galleries and I can see this new gallery over the list of the images I have uploaded so far

(c) I went to admin home->file galleries, selected my gallery (Testing_file_gallery) and then pressed Move Files from DB to Directory, hoping that exactly that would happen. Instead I got an error message: "you must specify a directory".

Ok, obviously I have to specify this directory, but how? Exactly below "Move Files from DB to Dir" button, one can find a space to specify a directory but it is the "podcast directory" (so not my file directory).

Any ideas?

Posted by Xavier de Pedro 24 May 2014 19:05 GMT-0000 posts: 1817

once you select to store them on disk, you'll see a text field where you can indicate where to store them.
Then you can request to move files from db to disk, etc.

Posted by nikosal 25 May 2014 08:25 GMT-0000 posts: 98

yes, I saw that text now.

Still, I cant make the move, as I get a "you must specify a directory" error in any path I use.

For example:
public_html/wiki/test/
or
wiki/test/
or just
test/

no need to say that I create these folders each time (note that my wiki folder is in public_html of my server).

I realize that the most possible thing here, is that I have not grasped the theory behind the file structure of my installation... So any help again would be useful.

Posted by nikosal 03 Jun 2014 10:06 GMT-0000 posts: 98

Back here to report that I was able to make the transfer (database -> directory) in my new hosting server.

The folder I used was the /files folder inside my tiki installation. So the whole path as I see it with plesk -> files tab is /root directory/www.mysite.com/files with permissions 755 (rwx, r-x, r-x) for this folder and 644 (rw-, r- -, r- -) for all the files that were created during the transfer (after I pressed the "move files from database to directory button").

All these files have a long name like 0bf9cde136094db76b166f3ad35a0149 and browser says they are bin files. Actually, all of these were pictures with a couple of pdfs.

Let me put forward a few question, to check if I am doing ok or not.

(a) is the folder / files permissions correct and secure?
(b) is getting these bin files, instead of .jpb or .pdf files ok?
(c) if yes, how do I check these pictures with plesk? If I click them I get an "Unable to read the file or the file format is not supported" error message. Mmmm, why I was expecting a readable file format for these files?
(d) finally, my database should be a lot smaller now, right?

PS. I opened my site from another computer and every pic is in its position, so I believe not major damage done (at least regarding the readability of my site).

note: I am using 12.2

Posted by nikosal 03 Jun 2014 16:48 GMT-0000 posts: 98

Hey Rick! Great answering me (a) to (d)!

Rick said: I'm not sure what Plesk is....

Plesk is one of the two most common tools to manage your site (the other being cpanel). There, if you click on a (say) .jpg file, it opens, you actually see the picture. I was expecting that after moving. Ok, thanks for clarifying this.

Now about that:
Rick said: Yes, if you deleted the items from the DB. As I recall, simply "moving" the files does not actually delete the record from the DB.

I guess the whole point of doing this move is to make db lighter. No point to keep images both in a directory and in db as well (as long as you properly backup your files).

So, how do I delete images from db?