Forums / Developer / Cleanup database?
Siniša Šehović
Monday 20 November 2006 6:51:43 am
Hi
I have one small problem!:-)
Need to clenup database of leftovers. (old unused records in database)
How to do that?
I am using ez 3.8.6 and mysql with innodb
Best regards,Sinisa
--- If at first you don't succeed, look in the trash for the instructions.
Ekkehard Dörre
Wednesday 22 November 2006 5:57:59 am
Hi Sinisa,
under bin/php/ are a lot of helper scripts which you can access via php cli.
flatten.php inline comment:
$script =& eZScript::instance( array( 'description' => ( "eZ publish database flattening.\n\n" . "Will remove data that is not considered currently in use to minimize the amount of database data it consumes\n" . "\n" . "Possible values for NAME is:\n" . "contentobject, contentclass, workflow, role or all (for all items)\n" . "flatten.php -s admin contentobject"), 'use-session' => false, 'use-modules' => true, 'use-extensions' => true ) );
Some documentation about the scripts:
http://ez.no/doc/ez_publish/upgrading/the_system_upgrade_scripts
Greetings, ekke
http://www.coolscreen.de - Over 40 years of certified eZ Publish know-how: http://www.cjw-network.com CJW Newsletter: http://projects.ez.no/cjw_newsletter - http://cjw-network.com/en/ez-publ...w-newsletter-multi-channel-marketing