Restoring MySQL database from physical files

by

A MySQL MyISAM table is the combination of three files:

  • The FRM file is the table definition.
  • The MYD file is where the actual data is stored.
  • The MYI file is where the indexes created on the table are stored.

You should be able to restore by copying them in your database folder (In linux, the default location is /var/lib/mysql/)

You should do it while the server is not running.

More Related Contents:

  1. Can I restore a single table from a full mysql mysqldump file?
  2. How to take backup of a single table in a MySQL database?
  3. Speeding up mysql dumps and imports [closed]
  4. Dump a mysql database to a plaintext (CSV) backup from the command line
  5. What is the best way to do incremental backups in MySQL?
  6. How to import a SQL Server .bak file into MySQL?
  7. SQL split values to multiple rows
  8. How do I escape reserved words used as column names? MySQL/Create Table
  9. How to store multiple options in a single table?
  10. How to populate a table with a range of dates?
  11. Get the new record primary key ID from MySQL insert query?
  12. What is the opposite of GROUP_CONCAT in MySQL?
  13. How to Perform an UPSERT so that I can use both new and old values in update part
  14. MySQL pagination without double-querying?
  15. MySQL convert date string to Unix timestamp
  16. How to speed up SELECT .. LIKE queries in MySQL on multiple columns?
  17. MySql Table Insert if not exist otherwise update
  18. How do I select an entire row which has the largest ID in the table?
  19. MySQL error 1064 syntax but everything seems fine
  20. MySQL/MariaDB – order by inside subquery
  21. How to run SQL script in MySQL?
  22. My MySQL trigger doesn’t work, simple syntax, not complicated
  23. Removing MySQL 5.7 Completely [closed]
  24. How to optimize COUNT(*) performance on InnoDB by using index
  25. script to convert mysql dump sql file into format that can be imported into sqlite3 db
  26. ERROR 1148: The used command is not allowed with this MySQL version
  27. Too many auto increments with ON DUPLICATE KEY UPDATE
  28. MySQL: Setting sql_mode permanently
  29. Is it possible to count two columns in the same query
  30. mySQL regex in the where clause

Leave a Comment