- Since backup restoration takes a very long time, it is recommended to start the restoration process inside a screen session so that even if you lose connectivity to the server, the restoration will continue.
- Sometimes, there can be failures during restoration. If you pass the --force option to MySQL, restoration will continue:
shell> (echo "SET SQL_LOG_BIN=0;";cat /backups/full_backup.sql) | mysql -u <user> -p -h <remote_hostname> -f