Skip to content

Instantly share code, notes, and snippets.

@kmvan

kmvan/mariadb-recovery.md

Created June 18, 2022 03:51
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kmvan/8ae015c5fd94695ce271a3a0986986cf to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kmvan/8ae015c5fd94695ce271a3a0986986cf to your computer and use it in GitHub Desktop.
Download ZIP
Recovery MariaDB data
Raw
mariadb-recovery.md

Create table without index, foreign key and data.

ALTER TABLE [table] DISCARD TABLESPACE;

Copy [table].ibd to database dir.

ALTER TABLE [table] IMPORT TABLESPACE;

Add table index and done.

Note: must be same mariadb version.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment