[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Copy mysql database files to different server

Posted on 2011-02-21
6
Medium Priority
?
492 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
  • 5
6 Comments
 
LVL 4

Author Comment

by:degaray
ID: 34947875
anyone?
0
 
LVL 4

Accepted Solution

by:
degaray earned 2000 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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month18 days, 4 hours left to enroll

829 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