Backup Alternatives, Incremental, My SQL InnoDB

consultant

• December 03, 2015 02:19

I recently moved off a full-managed server to semi-managed and they only do weekly backups. While the Cpanel built-in backup function is conveniently included, having no experience with it before I'm wondering how robust/effective it really is. On my previous host, if I needed restore of a MySQL InnoDB table, it was not a trivial process and I'm curious if the Cpanel restore has robust enough functionality to restore an individual table from a specific database? Moreover, I'm dissapointed you can't do compressed incremental backups. This leads me to believe maybe a lot of CPanel users with systems where backup and recovery are critical, may be using alternative solutions. Is there an alternative solution (preferably no-cost/open source) I should look at? It would be nice on certain mission-critical databases to do hourly incrementals or at least hourly syncs to another duplicate database to protect against someone screwing up the DB. I suppose mastery of the mysqbackup cmd might fill this need?

• 

  cPanelMichael

  • December 03, 2015 15:48

  On my previous host, if I needed restore of a MySQL InnoDB table, it was not a trivial process and I'm curious if the Cpanel restore has robust enough functionality to restore an individual table from a specific database?

  
  Hello :) There's no native functionality for this type of restoration. While you can choose to backup databases, and/or the entire MySQL data directory, restoring an individual table would require you to manually extract the database and utilize the MySQL command line to insert the data. As far as third-party backup solutions, R1Soft is commonly used, but I'm not aware of a specific provider with the type of robustness you are seeking. Thank you.

  0
• 

  consultant

  • December 03, 2015 17:23

  Thanks for the confirmation of what I suspected. I think a solution like R1Soft is overkill (although I see they have a free Linux snapshot tool but that's not going to help me very well with easy restoration of individual MySQL tables - maybe that's what you were referring to?) I've determined the best solution is a cron even that runs every 2 hours that does a mysqldump of the mission critical database and gzips it up with 24 hour retention.

  0
• 

  cPanelMichael

  • December 03, 2015 18:12

  Also, feel free to open a feature request for the specific functionality you are seeking via: Submit A Feature Request Thank you.

  0

Please sign in to leave a comment.