MySQL Messedup after backup restore..

[RobinVossen]

Hello,

A little while I had a server crash... I was happy I had backups.

So, I took my backups out, reinstalled everything. POP back online in an hour.
However, it looks I overlooked something with MySQL...
When I launch the script that does the SQL thing I get

DBD::mysql::str execute failed: Can't find file: './av/users.frm' (errno: 13) at line x

So I thought, did I forget to copy the Databases -,-'
I had a look in my /var/lib/mysql folder and guess whats there.. the file.

So, what did I forget to copy? And maybe I can still recover it?

Thanks

Robin

[elija]

OK, I'm guessing that av is the name of your database and that you have a table called users.

In MySQL each table is represented by three files

tableName.frm holds the structure of the data
tableName.MYD is the actual data
tableName.MYI holds the indexes.

These files should be in your mysqldatadir/databaseName directory.

How did you do your backup?

Also when you copied your data back, did you stop the MySQL Service first?

[RobinVossen]

OK, I'm guessing that av is the name of your database and that you have a table called users.

I Guess you guessed correctly

In MySQL each table is represented by three files

tableName.frm holds the structure of the data
tableName.MYD is the actual data
tableName.MYI holds the indexes.

These files should be in your mysqldatadir/databaseName directory.

Dang, that explains enough, I only have the frm files..

How did you do your backup?
Also when you copied your data back, did you stop the MySQL Service first?

The Backup is done with a dd but the hard drive got damaged.

I'll have a good look around and hope I can find my data back in older backups..

Thanks ^^

EDIT:
During the Backup the HD Crashed. Backup lost.. This is annoying..
I try to add them again, and I get the error already exists. So I had to do this:

DROP TABLE `av`.`***`;
CREATE TABLE `av`.`***` (
  `***` VARCHAR(45) NOT NULL,
  `***` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`***`)
)
ENGINE = InnoDB;
DROP TABLE `av`.`users`;
CREATE TABLE `av`.`users` (
  `***` VARCHAR(45) NOT NULL,
  `***` VARCHAR(45) NOT NULL,
  `***` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`***`)
)
ENGINE = InnoDB;

It crashes again, I really want to fix it.. Well I guess today its Google Digging day for me