Solved

MySQL Datafiles On CentOS 7

Posted on 2016-10-03
5
19 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
  • 3
5 Comments
 
LVL 61

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 61

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 61

Expert Comment

by:gheist
ID: 41881884
Thats life
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

930 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now