Home / server / Questions / 835042
Accepted
Gacek
Asked: 2017-02-27 13:24:01 +0800 CST

Mysql/Mariadb backup from non-bootable system

  • 772

My working server crashed, more precise, my HDD got bad sectors.
What is proper method to make a backup from non-working server and restore it later on newly installed server?

Any set of files I need to copy/replace?

backup mysql backup-restoration mariadb

1 Answers

  1. Best Answer

    You don't say which OS/Distro but in general

    • /etc/my.cnf
    • /etc/my.cnf.d/* (if it exists)
    • /var/lib/mysql/*

    You may want to take a look at the config files after you have copied them from the disk to check that the datadir is correct.

    • 2