[Typo3] Clean up unused data in database

tapio tapio.markula at dnainternet.net
Fri Nov 18 23:48:36 CET 2005


> There are quite some tables I'm hesitant to delete; for example these:
> 
> Removing tables (rename with prefix)
> 	ALTER TABLE static_taxes RENAME zzz_deleted_static_taxes;	
> Records in table: 35	
> 	ALTER TABLE sys_todos RENAME zzz_deleted_sys_todos;	
> Records in table: 1	
> 	ALTER TABLE sys_todos_users_mm RENAME zzz_deleted_sys_todos_users_mm;	
> Records in table: 1	
> 	ALTER TABLE sys_workflows RENAME zzz_deleted_sys_workflows;	
> Records in table: 1	
> 	ALTER TABLE sys_workflows_algr_mm RENAME zzz_deleted_sys_workflows_algr_mm;	
> 	ALTER TABLE sys_workflows_pubuser_mm RENAME zzz_deleted_sys_workflows_pubuser_mm;	
> 	ALTER TABLE sys_workflows_rvuser_mm RENAME zzz_deleted_sys_workflows_rvuser_mm;	
> 	ALTER TABLE tt_news RENAME zzz_deleted_tt_news;	
> 	ALTER TABLE tt_news_cat RENAME zzz_deleted_tt_news_cat;	
> 	ALTER TABLE tt_news_cat_mm RENAME zzz_deleted_tt_news_cat_mm;	
> 	ALTER TABLE tt_news_related_mm RENAME zzz_deleted_tt_news_related_mm;
> 
> And it's really safe to rename them?!!? 

If typo needs tables, it creates thems if they don't exist when you use 
the comparing tool. If you uninstall any default plugin typo suggest 
first to rename table and then to delete renamed tables.
The purpose is that the database match *exactly* with the installed plugins.
Have you uninstalled 'User>Task Center, Tasks' etc. and 'tt_news'?



More information about the TYPO3-english mailing list