I want to backup mysql databases to another new server. I don't want to use mysql replication and mysqldump for backup as they are using higher cpu and higher i/o on server. I tried mysqlhotcopy to send databases files to another server into /var/lib/mysql/database but after backup new server shows empty database. Help me friends to find solution. Is there any way to send database raw files using rsync or scp and get recovered database ?
SnapOverflow
We can rsync mysql database folder /var/lib/mysql to another server. Mysql versions should be same and server should be shutdown.