The backup functionality in AbanteCart is primarily designed for restoring your store’s data within the same hosting environment or for recovery purposes. When it comes to migrating your website to a new hosting provider, a full database backup is essential, as it ensures all the data, including products, customers, and settings, is retained.

To answer your questions:

Backup of data in the admin: This is useful for partial recovery or troubleshooting within the same server. For example, if you want to restore specific data without affecting your entire site, this option can be helpful.

Dump.sql: This file contains a copy of your database and can be used with tools like phpMyAdmin to import your data into the new hosting environment. It’s not a standalone solution—you’ll need to configure your new host (e.g., set up a database, update configuration files) before importing it.

For a smooth migration:

Use CPanel or phpMyAdmin to create a full backup of your database.
Download your entire website files via FTP.
Upload the files and database to your new host, then update the configuration file (e.g., database credentials) to reflect the new setup.