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
Jump to PostI 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 …
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.
I did but accidiently made two threads: http://www.daniweb.com/web-development/databases/threads/476852/split-databasetables-across-various-files
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.