eZ Community » Forums » Developer » Cleanup database?
expandshrink

Cleanup database?

Cleanup database?

Monday 20 November 2006 3:51:43 pm - 1 reply

Hi

I have one small problem!happy.gif Emoticon

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

Wednesday 22 November 2006 2:57:59 pm

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

expandshrink

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu