Loading...
 
Skip to main content

Architecture / Installation


SQL tables without tiki_ prefix?!

I cleaned up my MySQL database because there was lots of tables from different projects in the same database. I removed all tables without tiki_ prefix. Now I noticed my Tikiwiki-site doesn't work. It seems that table 'sessions' was also Tikiwiki's table. I forgot to do any backups. How can repair my site now?

There are several database tables that Tiki uses that do not have the tiki_ prefix. If you've already deleted these tables (without a backup) I don't think it is possible to recover the data. You can re-run the installation script (tiki-install.php) to re-create the database tables.

HTH,

-RickQuestion
Need more help? Try TikiWiki for Dummies SmartiesQuestion or read my Tiki Blog or visit my UserPage


Thanks. I luckily found some old backup from the server and was able to create the missing tables.

Is there a reason why some of the tables don't have prefix? I'm just wondering because it can create situations like this...