Improve company productivity with a Business Account.Sign Up

x
?
Solved

Copy mysql database files to different server

Posted on 2011-02-21
6
Medium Priority
?
494 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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
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 Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

584 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