Hi Patrick,
The error says a permissions problem. Did you change the ownership/group
to mysql:mysql, to the mentioned files, after you restored them?
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +61 8 8408 4273
**** _/ _/ _/_/_/ **** Mobile: +61 417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: Patrick Aljord [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 15 November 2006 9:40 AM
To: mysql@lists.mysql.com
Subject: can I recover a database from db files?
Hey all,
I host my app on a friend server who make backup every night, well
yesterday he installed another distro so I asked him for my db backup
and it turns out the only backup he did was the whole hard drive. So
he just sent me a tarball of my database directory containing:
ads_categories.MYD,ads_categories.MYI,ads.frm,ads.MYD,ads.MYI,categories
.frm,categories.MYD,categories.MYI,db.opt,regions.frm,regions.MYD,region
s.MYI.
I tried to create a database called mydb on my computer (debian etch)
and just copied all the files to the place /var/lib/mysql/mydb/
then when I try to do a select * from categories, I get:
ERROR 1017 (HY000): Can't find file: './mydb/categories.frm' (errno: 13)
is there any way to get my db back?
thanx in advance
Pat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
