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

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.