53
If you have cpanel, go to 'backup' and simply click the database you want to backup from the list on the page. You get a gzip download to your local machine. To restore this database, you click the restore database function (on the same page) and browse for the database you downloaded on your LM. Upload it as it is. The backup and restore functions are completely compatible to restore the DB without errors (even large databases) Yo dont need to make any setting in cpanel or change anything.
Ive used it many times, no problems of catches. On restore, always allow the screen to load completely. Dont be in a hurry to click on. It can take several seconds or minutes on a large database.