473,385 Members | 1,707 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Drive failed now mounted as slave how to recover db's??

I had a server lose a drive. This customer didnt back his database. I
mounted old failing drive as a slave and can see .frm .MYI & .MYD But if I
copy them to /var/lib/mysql/db_name it says .frm doesnt exist ???? How do I
fix this????
--
Eric Haskins
RackSPEED.Net
WebHosting from $4.99/month
Dedicated Servers
Multiple UpStream Providers
Jul 19 '05 #1
4 1940
Since no one answered, I'll see if I can help.

First, charge outrageous amounts of money for this. If someone doesn't
back up his data, too bad for him. It's a linux system, how hard is it
to set up a cron job?!? Anyway...

I just copied a database without any problems (I thought it would be
more difficult).

Are you sure the destination files, including the directory, have the
correct owner, group, and permissions?

- Mark

Eric Haskins wrote:
I had a server lose a drive. This customer didnt back his database. I
mounted old failing drive as a slave and can see .frm .MYI & .MYD But if I
copy them to /var/lib/mysql/db_name it says .frm doesnt exist ???? How do I
fix this????


Jul 19 '05 #2
Since no one answered, I'll see if I can help.

First, charge outrageous amounts of money for this. If someone doesn't
back up his data, too bad for him. It's a linux system, how hard is it
to set up a cron job?!? Anyway...

I just copied a database without any problems (I thought it would be
more difficult).

Are you sure the destination files, including the directory, have the
correct owner, group, and permissions?

- Mark

Eric Haskins wrote:
I had a server lose a drive. This customer didnt back his database. I
mounted old failing drive as a slave and can see .frm .MYI & .MYD But if I
copy them to /var/lib/mysql/db_name it says .frm doesnt exist ???? How do I
fix this????


Jul 19 '05 #3
Try some recovery software
"Eric Haskins" <ho********@rackspeed.net> wrote in message
news:vU***************@nwrddc01.gnilink.net...
I had a server lose a drive. This customer didnt back his database. I
mounted old failing drive as a slave and can see .frm .MYI & .MYD But if I copy them to /var/lib/mysql/db_name it says .frm doesnt exist ???? How do I fix this????
--
Eric Haskins
RackSPEED.Net
WebHosting from $4.99/month
Dedicated Servers
Multiple UpStream Providers

Jul 19 '05 #4
Try some recovery software
"Eric Haskins" <ho********@rackspeed.net> wrote in message
news:vU***************@nwrddc01.gnilink.net...
I had a server lose a drive. This customer didnt back his database. I
mounted old failing drive as a slave and can see .frm .MYI & .MYD But if I copy them to /var/lib/mysql/db_name it says .frm doesnt exist ???? How do I fix this????
--
Eric Haskins
RackSPEED.Net
WebHosting from $4.99/month
Dedicated Servers
Multiple UpStream Providers

Jul 19 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: John Yasaitis | last post by:
I seem to have replication set up correctly to only replicate one database named vmail.* Except when I try to update a table in vmail.* the changes do not replicate to the slave. Authentication...
0
by: Eric Haskins | last post by:
I had a server lose a drive. This customer didnt back his database. I mounted old failing drive as a slave and can see .frm .MYI & .MYD But if I copy them to /var/lib/mysql/db_name it says .frm...
3
by: Sander Smeenk | last post by:
Hello! I'm trying to set up replication between two servers and even though I did everything according to the documentation, the slave keeps failing to connect to the master like this: |...
0
by: Rajesh Kapur | last post by:
I have a master slave configuration on linux machines running MySQL 4.0.21. Once every hour, a process deletes about 9000 rows and re-inserts fresh data on the master. The master process completes...
0
by: Mike | last post by:
Hello, We are using mysql v4.0.24 on Linux machines. I'm trying to set up replication with a master and only one slave database. The syncronization seems to work well, the relay file on slave...
5
by: q2face | last post by:
Dear group: I have removed my hard drive from my laptop (which is now toast) and have managed to recover nearly all the data from it by installing the drive into my desktop. I was hoping to...
3
by: Christopher Mouton | last post by:
We regularly make drive images of our entire server and store it at a backup site. To be honest I have never fully understood how the imaging programs deal with open files. My question is will the...
2
by: Chesne | last post by:
I have been using a 3gb and an 80gb hard drives with the 3 gb being set as the master and the 80gb as the slave. (80gb Seagate ST380011A) I now wish to discard the 3gb and use the 80gb on its...
1
by: Gatormike | last post by:
We have a 4 year old Dell desktop that functions as the file server in our very simple (2 other pc's plus the "server") XP network. On the Dell we have our Quickbooks company file in a shared folder...
3
by: shardy | last post by:
Hello, I am trying to create a code repository for myself and am having trouble linking to files. Basically, the web server computer has drives from several other computers nfs mounted to it --...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.