Restore database from Raw files

Taha Haider

• September 29, 2017 04:56

Hi, My Server got crashed recently, I have backup of all files including /var/lib/mysql how can I restore the databases from the raw files I have?

• 

  hydn79

  • October 01, 2017 15:47

  First make a copy of /var/lib/mysql Then you can restore by copying the files in /var/lib/mysql to a new server. Or restoring to the old server after fresh mysql install. If the backup is corrupt then thats another thing altogether and not really a backup. But rather the db files in their crashed/corrupt state. Depending on table type check innodb_force_recovery: MySQL :: MySQL 5.7 Reference Manual :: 14.21.2 Forcing InnoDB Recovery

  0
• 

  cPanelMichael

  • October 02, 2017 18:44

  Hello, Were account backups enabled on this system, or do you only have a copy of the filesystem? Thank you.

  0

Please sign in to leave a comment.