Results 1 to 3 of 3
Enjoy an ad free experience by logging in. Not a member yet? Register.
MySQL Messedup after backup restore..
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
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?
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?Should you be sitting wondering,
Which Batman is the best,
There's only one true answer my friend,
It's Adam Bloody West!
The Fifth Continent
I'll have a good look around and hope I can find my data back in older backups..
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;