0

We have various databases on several offsite locations and we want to do a backup to here. Problem is that database is problably going to weigh GBs of data so it would be better to split it into several "files" so we can only get the updates in small amounts.

How can this be done in MySQL?

2
Contributors
2
Replies
25
Views
3 Years
Discussion Span
Last Post by riahc3
0

We have various databases on several offsite locations and we want to do a backup to here. Problem is that database is problably going to weigh GBs of data so it would be better to split it into several "files" so we can only get the updates in small amounts.

How can this be done in MySQL?

Are you using InnoDB, per chance? If so I would encourage you to use XtraBackup. It's designed to do just this: efficiently backup large databases.

0

I perfer something built into MySQL natively, not a third party solution which Im sure there are plenty out there.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.