How to recover MySQL database from .myd, .myi, .frm files

by

If these are MyISAM tables, then plopping the .FRM, .MYD, and .MYI files into a database directory (e.g., /var/lib/mysql/dbname) will make that table available. It doesn’t have to be the same database as they came from, the same server, the same MySQL version, or the same architecture. You may also need to change ownership for the folder (e.g., chown -R mysql:mysql /var/lib/mysql/dbname)

Note that permissions (GRANT, etc.) are part of the mysql database. So they won’t be restored along with the tables; you may need to run the appropriate GRANT statements to create users, give access, etc. (Restoring the mysql database is possible, but you need to be careful with MySQL versions and any needed runs of the mysql_upgrade utility.)

Actually, you probably just need the .FRM (table structure) and .MYD (table data), but you’ll have to repair table to rebuild the .MYI (indexes).

The only constraint is that if you’re downgrading, you’d best check the release notes (and probably run repair table). Newer MySQL versions add features, of course.

[Although it should be obvious, if you mix and match tables, the integrity of relationships between those tables is your problem; MySQL won’t care, but your application and your users may. Also, this method does not work at all for InnoDB tables. Only MyISAM, but considering the files you have, you have MyISAM]

More Related Contents:

  1. MySQL Data – Best way to implement paging?
  2. How can I find all the tables in MySQL with specific column names in them?
  3. ERROR 2006 (HY000): MySQL server has gone away
  4. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  5. Create table variable in MySQL
  6. Stored procedure that Automatically delete rows older than 7 days in MYSQL
  7. MySQL: multiple tables or one table with many columns? [closed]
  8. How do I check to see if a value is an integer in MySQL?
  9. Add 2 hours to current time in MySQL?
  10. Store image to database blob; retrieve from db into Picturebox
  11. How to prepend a string to a column value in MySQL?
  12. MySQL trigger On Insert/Update events
  13. MySQL combine two columns into one column
  14. How to get first day of every corresponding month in mysql?
  15. How can I change MariaDB to MySQL in XAMPP?
  16. MySQL: LIMIT by a percentage of the amount of records?
  17. MySQL multiple columns in IN clause
  18. GROUP BY – do not group NULL
  19. Reserved word in column name – insert into MySQL [duplicate]
  20. MySQL 1062 – Duplicate entry ‘0’ for key ‘PRIMARY’
  21. MySQL LEFT JOIN 3 tables
  22. Communications link failure , Spring Boot + MySql +Docker + Hibernate
  23. Doctrine 2 mysql FIELD function in order by
  24. FIND_IN_SET with multiple value [duplicate]
  25. Accessing a mysql database from external host/ip? (ie: mysql workbench)
  26. MySQL table -> Can you return the same row multiple times, in the same query?
  27. MySQL LIMIT on DELETE statement
  28. Select all where [first letter starts with B]
  29. CakePHP – get last query run
  30. Why is connecting to MySQL server so slow?

Leave a Comment