Database management

Use this forum for questions regarding adoption and functionality of OpenEMM

Moderator: moderator

Bernard
Posts: 3
Joined: Thu Dec 10, 2009 6:39 am

Database management

Post by Bernard »

How does an administrator level user delete multiple records and pack the recipient database?
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Post by maschoff »

To delete a set of records define a new target group which contains all records to be deleted and select option "Delete recipients of this target".

to backup the database please see the install guide, section uninstall/update.
OpenEMM Maintainer
Bernard
Posts: 3
Joined: Thu Dec 10, 2009 6:39 am

Post by Bernard »

Many thanks for the help.
roger
Posts: 8
Joined: Tue Mar 02, 2010 11:34 am

Post by roger »

Just as a follow up, the docs do not cover the packing of a database table and it's indexes.

You can do this in a number of ways

a) You can install a tools such as MySQL Administrator and use the maintanance option on the table you wich to pack.

b) You can use the following SQL command from within a command line tool

optimize table [table name]

I find that installing MySQL Administrator is very useful as it gives a good overview of the system and allows system based scheduled backups to be setup.
Post Reply