I would like to be able to store data in various files instead of one huge one to make remote backups easier on MySQL. How can I set this up?

Thank you

Recommended Answers

All 2 Replies

I would like to be able to store data in various files instead of one huge one to make remote backups easier on MySQL. How can I set this up?

Thank you

You asked this question a week ago. I even posted and you never responded. I'll try again:

Are you using the InnoDB engine? Or is it MyISAM?

If you are using InnoDB then look at XtraBackup. I'll do what you're looking to accomplish: make backing up more efficient.

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.