![]() Use the mysql command to restore a database from the command line So, to avoid data loss, the above-mentioned files should not be deleted. frm file that stores a schema and a definition of the table. my.cnf file that stores MySQL configuration settings. ![]() MySQL creates many files that are used to back up the data, structure, and indexes of MySQL databases. In addition, data backup helps keep data up-to-date and allows you to restore it at any time in the state you back it up before the data was damaged. Through this process, you can ensure data consistency in your databases and be sure that nothing critical happens to your data and it won’t be lost irrevocably. For these reasons, it is recommended to make a backup on a regular basis. There may be situations when data gets lost or corrupted, for example, when users accidentally deleted or overwrote data.
0 Comments
Leave a Reply. |