Database management

Bernard · Post by **Bernard** » Sat Dec 12, 2009 2:02 am

How does an administrator level user delete multiple records and pack the recipient database?

Post by **maschoff** » Sat Dec 12, 2009 11:17 pm

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.

Bernard · Post by **Bernard** » Sun Dec 13, 2009 8:59 pm

Many thanks for the help.

roger · Post by **roger** » Wed Mar 03, 2010 4:20 pm

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.