Forums / Developer / Cleanup database?

Cleanup database?

Author Message

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