Split database data (tables, columns, data, etc) into various files

[riahc3]

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

[Bob Hensley]

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.

[riahc3]

I did but accidiently made two threads: http://www.daniweb.com/web-development/databases/threads/476852/split-databasetables-across-various-files