In order for this backup to have clean data in it, you will need to shut down your mysql daemon while making the backu If you are server is a RedHat- or CentOS-like operating system using vendor-supplied RPMs for the MySQL packages (and default paths in your my.cnf), the following set of commands ought to do this for you: