What would be the best way to move forward with a mySQL backup/restore when the traditional backup/restore have slow performance? Backup is decent but restore of a few GB in a single table takes hours to complete.
So, with restore performance in mind, would it be best to update the license model to enable Enterprise SBT-bases backups? Or would a block-based backup be the best way to go?
Best answer by SunilView original
The problem with restoring tables from dump based backup is that, even if you need only a few tables we will first have to restore the entire DB dump and then import the tables you need from that database.
Block level restore would minimize the amount of data needs to be restored by restoring only the blocks needed. You can give it a try.