Mobile app version of vmapp.org
Login or Join
Michele947

: In what location does Tiki store articles: in the file system or in the MySQL database? I have a dump of the directory structure from an old Tiki website from around 2010 that is no longer

@Michele947

Posted in: #Filenames #Mysql #SiteStructure #Wiki

I have a dump of the directory structure from an old Tiki website from around 2010 that is no longer up. I would like to view the raw text of the articles but am unable to locate any files that appear to be articles after browsing the directory structure. Where does Tiki store user articles in the file system? I found lib/articles/artlib.php and lib/articles/index.php, but nothing appeared to be user added in there. Perhaps there were no articles, if so, how can I confirm that?

Alternatively, are the articles stored in the MySQL database and not stored as textual files? If in the db, is there an easy way to browse them? I'd rather not create a complete Tiki site and try to map these old file system into it only to discover that there was no useful content, so how can I judge how much content was actually added? Thus far, I've found one image file in temp/CRW_0075.jpg that was added to the site, but that is the only sign of content I've located thus far.

My ultimate goal here is to assess if there is any useful information in this Tiki and if so, to extract it into a private MediaWiki I am helping to create.



Note that this is Tikiwiki v3.0 the README in the top level directory shows:


Tiki! The wiki with a lot of features!
Version 3.0

DOCUMENTATION


The documentation for 3.0 version is under construction on >http://doc.tikiwiki.org.
You're encouraged to contribute.
It is highly recommended that you refer to the online documentation:
doc.tikiwiki.org/Installation for a setup guide
Notes about this release are accessible from tikiwiki.org/ReleaseNotes30 Tikiwiki has an active IRC channel, #tikiwiki on irc.freenode.net


INSTALLATION


There is a file INSTALL in this directory with notes on how to setup and
configure Tiki. Again, see doc.tikiwiki.org/Installation for the latest install help.


UPGRADES


Read the online instructions if you want to upgrade your Tiki from a previous release doc.tikiwiki.org/Upgrade

COPYRIGHT

Copyright (c) 2002-2009, Luis Argerich, Garland Foster, Eduardo Polidor, et. al.
All Rights Reserved. See copyright.txt for details and a complete list of authors.
Licensed under the GNU LESSER GENERAL PUBLIC LICENSE. See license.txt for details.

... Have fun!

Note to Tiki developers: update this text through release.php.

10.01% popularity Vote Up Vote Down


Login to follow query

More posts by @Michele947

1 Comments

Sorted by latest first Latest Oldest Best

 

@Berumen354

You will need to export the mysql table that it is stored in.

Open a SSH connection to your server.

Sign in to mysql with mysql - u [username] -p. Enter your password when prompted. Type show databases. Choose the database the seems the right one. Type use [database name ]. Type show tables. Remember the table that appears relevant. Now, exit mysql with exit.

Type mysqldump - u [username] - p [table name that you remembered]  > exportedTable.sql. Enter your password when prompted. The file exportable.sql has the table's data, and you can download it over sftp/ftp.

If the table doesn't have the right data, try again, but pick a different database or table.

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme