MySQL backup full instance I am new to MySQL after using Postgres for long time, I wonder if there's an equivalent way to backup the data like pg_basebackup in MySQL or the only option is dump?
The equivalent backup tool for MySQL is Percona XtraBackup.
This does not do a dump like mysqldump, it makes a physical copy of the tablespace files without blocking clients using the database. The documentation is pretty good quality.