Restore the mysql database from .frm files

by

Yes this is possible. It is not enough you just copy the .frm files to the to the databse folder but you also need to copy the ib_logfiles and ibdata file into your data folder. I have just copy the .frm files and copy those files and just restart the server and my database is restored.

After copying the above files execute the following command –

sudo chown -R mysql:mysql /var/lib/mysql

The above command will change the file owner under mysql and it’s folder to MySql user. Which is important for mysql to read the .frm and ibdata files.

More Related Contents:

  1. #1071 – Specified key was too long; max key length is 1000 bytes
  2. How can I access the MySQL command line with XAMPP for Windows?
  3. How can I get rid of these comments in a MySQL dump?
  4. script to convert mysql dump sql file into format that can be imported into sqlite3 db
  5. Mysqldump launched by cron and password security
  6. Which DB technology is sued to solve the following search issue? [closed]
  7. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  8. How should I resolve –secure-file-priv in MySQL?
  9. node-mysql multiple statements in one query
  10. MySQL server startup error ‘The server quit without updating PID file’
  11. Select last row in MySQL
  12. Best type of indexing when there is LIKE clause [duplicate]
  13. MySQL LOAD DATA INFILE with ON DUPLICATE KEY UPDATE
  14. Difference between Key, Primary Key, Unique Key and Index in MySQL
  15. What’s the difference between MyISAM and InnoDB? [duplicate]
  16. MySQL: Split comma separated list into multiple rows
  17. How to start MySQL with –skip-grant-tables?
  18. When to use STRAIGHT_JOIN with MySQL
  19. Remove Primary Key in MySQL
  20. Difference in MySQL JOIN vs LEFT JOIN
  21. Get most recent row for given ID
  22. Update a column in MySQL
  23. Is merge statement available in MySQL
  24. Using an IF Statement in a MySQL SELECT query
  25. Insert/ Update random date in MySQL
  26. How to determine which database is selected
  27. Replace null with 0 in MySQL
  28. Update multiple rows with multiple ‘where’ clauses for each individual row
  29. WHERE datetime older than some time (eg. 15 minutes)
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment