[TomTom]

hello

I would like to clean up my mysql database.
The availability data is stored since 2 years.
Is there a simple way to delete all old data until last year?

thanks a lot
thomas

[mlist]

Good question! I'm interested also. Hope some guru will reply!

[curious_user2000]

I think most of us would,

I believe you can clean up Monarch database using the following:
cat /usr/local/groundwork/databases/monarch.sql | mysql monarch

If you set a root password for mysql (you should!), then use:

cat /usr/local/groundwork/databases/monarch.sql | mysql -u root -p monarch

and it will prompt you for the password.

WARNING: This will DELETE ALL your config data. You might want to do a backup first (Control - Commit - Backup - Abort).

You can restore a backup with a similar procedure, for instance

cat /usr/local/groundwork/monarch/backup/2008-03-25_17-25-47/monarch-2008-03-25_17-25-47.sql | mysql monarch
as per a posting on this group.

But I have issues with nagvis not updateing, and would really like to clean out the GWCollegeDB database, can anyone give me any pointers?