I am scripting an automated backup and migration solution. We don't need the data from the log table which is extremely large and causing the backup to take almost an hour.
As designed we can currently:
* specify specific tables or the full db to back up
* specify schema only or schema and data
It would be helpful if I could pass arguments that would allow me to backup just the schema of a particular table when doing a full back up. For my case it would allow me to leave out the log data.
I am scripting an automated backup and migration solution. We don't need the data from the log table which is extremely large and causing the backup to take almost an hour.
As designed we can currently:
* specify specific tables or the full db to back up
* specify schema only or schema and data
It would be helpful if I could pass arguments that would allow me to backup just the schema of a particular table when doing a full back up. For my case it would allow me to leave out the log data.
Hello!
Do you need all these logs? If not, you can remove all except records for last month, for example. You can also create a script that will remove old logs once a month.
It would be helpful if I could pass arguments that would allow me to backup just the schema of a particular table when doing a full back up. For my case it would allow me to leave out the log data.
I am afraid, you can only create two separate backups
- one with schema and data
- another one with schema of big tables
Hello!
Do you need all these logs? If not, you can remove all except records for last month, for example. You can also create a script that will remove old logs once a month.
Hey Oleg thanks for the reply. Yeah we keep about 6 months in the db but since theres no built in way to archive and off load old logs its a pain sometimes.
Yep thats why I'm asking for a feature
I am afraid, you can only create two separate backups
- one with schema and data
- another one with schema of big tables
Hey Oleg thanks for the reply. Yeah we keep about 6 months in the db but since theres no built in way to archive and off load old logs its a pain sometimes.
6 months is quite long. It may worth to develop script once that saves logs to file and removes them from database.
6 months is quite long. It may worth to develop script once that saves logs to file and removes them from database.
I agree. I also think it should be built in. The whole logging system needs overhauled its a huge mess.