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
Solved

Copy mysql database files to different server

Posted on 2011-02-21
6
469 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 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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.

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

Suggested Solutions

Title # Comments Views Activity
showing numeric numbers 2 38
MySQL Error Code 2 25
mysql db 3 69
Giant ibd file for our biggest table on mysql 2 17
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

840 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