How do I backup MySQL in Linux?

1. Copying from the mysql directory By default, MySQL databases on servers that use Linux are stored in the following directory: /var/lib/mysql/ If you shut down the mysqld service first, you can copy your databases to an example /backup directory using the following command: cp –Rp /var/lib/mysql/*.* /backup The –R switch for the cp command means recursive, which you… Continue reading How do I backup MySQL in Linux?