Another option is to set up archive tables and use INSERT SELECT to move the data and then delete from active users.