I am searching a way to administrate my netflow database. I need to make backup of all the flow collected and sometime to purge the old records (not the entire database).
- How can I backup the mysql database ? (mysqldump can't work because we don't have the sql password)
- How to clean the old flow (for example 3 month ago)
- How to restore the backup to see old flow logs without erasing the actual data ?