Solved

MySQL Datafiles On CentOS 7

Posted on 2016-10-03
5
27 Views
Last Modified: 2016-11-10
Hello guys,
For data restore reasons i wanna know exact data files location and there filename extention.

Which files are then sufficient to restore a mysql database on onother Linux Machine?

Please Help
0
Comment
Question by:mos1234
[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
  • 3
5 Comments
 
LVL 62

Expert Comment

by:gheist
ID: 41828485
/var/lib/mysql/*
There are multiple files in there.
File backup is only valid if mysqld is completely stopped.
Normally you would want to pipe mysqldump output to backup system pipe.
0
 

Author Comment

by:mos1234
ID: 41834334
does it mean that if MySQL is running and the hardware crashes theres no chance for recovery from files retrieved someway from the storage?.....
0
 
LVL 62

Assisted Solution

by:gheist
gheist earned 250 total points (awarded by participants)
ID: 41834482
You can make transaction-accurate replica and make backups with or without shutdown from that.
Bonus - it can be used as read-only database too.

Why - you make mysqldump backups. Image backups will not work with any open database.
0
 
LVL 25

Accepted Solution

by:
Tomas Helgi Johannsson earned 250 total points (awarded by participants)
ID: 41852175
Hi!

All data that has been commit-ed to disk would be recoverable if the files are accessible and not corrupted after you reboot and/or mount the disk where the database is located.
You would need to recover all /var/lib/mysql/ directory to a new location and start mysql on that location. If you get a successfull startup then you could do mysqldump (backup) of the data to be restored on a "clean" and fully functional server.
What I recommend is that you have a master-slave / replication setup for disaster recovery as well as backups to minimize recovery time on your database especially on mission critical databases.

Regards,
     Tomas Helgi
0
 
LVL 62

Expert Comment

by:gheist
ID: 41881884
Thats life
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
I want to echo out my field names with its values into a table 10 43
How to fix Datetime in MySQL? 4 76
mysql query for sum() 3 61
Unwanted output from my query 5 53
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

751 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