Solved

Copy mysql database files to different server

Posted on 2011-02-21
6
479 Views
Last Modified: 2012-05-11
Hi,

I was using Ubuntu as my test server and for some reason it will not start again. Anyway I am still able to read all the files through another partition installed with Ubuntu. I need to copy my mysql databases but so far I have not been able. I have tried copying the .frm, myd and myi files from folder /var/bin/mysql in the corrupted partition to the same folder in the newly installed partition. The thing is that I cannot access the database from mysql server. What else do I need to/can do?
0
Comment
Question by:degaray
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
6 Comments
 
LVL 4

Author Comment

by:degaray
ID: 34947875
anyone?
0
 
LVL 4

Accepted Solution

by:
degaray earned 500 total points
ID: 34948220
I got it! It was a matter of file permissions. I just copied all the files and gave mysql user permissions to them. Done!
0
 
LVL 21
ID: 34948720
Great job!

Thank you for sharing your solution. I am sure many will benefit. I know I did.
0
Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

 
LVL 4

Author Comment

by:degaray
ID: 35098772
Can you cancel the question please?
0
 
LVL 4

Author Comment

by:degaray
ID: 35098816
TheHiTechCoach I cannot ask other questions, may I ask you to cancel your comment? I requested that my question be taken as the best answer, but now I have to wait and I need to make another question.
0
 
LVL 4

Author Comment

by:degaray
ID: 35098821
test
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question