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?

Recommended Answers

All 2 Replies

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.

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.