<div>
/var/lib/mysql/*<br />
There are multiple files in there.<br />
File backup is only valid if mysqld is completely stopped.<br />
Normally you would want to pipe mysqldump output to backup system pipe.
</div>


/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.

<div>
does it mean that if MySQL is running and the hardware crashes theres no chance for recovery from files retrieved someway from the storage?.....
</div>


does it mean that if MySQL is running and the hardware crashes theres no chance for recovery from files retrieved someway from the storage?.....

<div>
<div class="content wysiwyg-content">
Hello guys,<br />
For data restore reasons i wanna know exact data files location and there filename extention.<br />
<br />
Which files are then sufficient to restore a mysql database on onother Linux Machine?<br />
<br />
Please Help
</div>
</div>


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

MySQL Datafiles On CentOS 7

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.