MySQL Forums
Forum List  »  Data Recovery

Copy of data folder
Posted by: dileep ch
Date: August 03, 2012 04:31AM


I we have problem with harddisk of the server,Suddenly the machine is down, So as there is no any other way to backup of the database i copied all the data which is in /varlib/mysql and send that to another machine and then changed the file and folder permissions and ownerships which the original one have, after that i restarted the server.Here comes the problem with this, mysql could not start again and errors in the error log is

120803 12:02:10 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
120803 12:02:10 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

I could understand what to do.

THe complete error log is

InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120803 16:00:10 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120803 16:00:11 InnoDB: Started; log sequence number 0 47587
120803 16:00:11 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
120803 16:00:11 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

What to do any idea please.

Options: ReplyQuote

Written By
Copy of data folder
August 03, 2012 04:31AM
August 09, 2012 11:22PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.