Are you trying to backup an AbanteCart database? We can help you.

AbanteCart is a free eCommerce application which supports MySQL database.

At Bobcares, we often get requests from our customers to do back up and restore AbanteCart databases as part of our Server Management Services.

Today, let’s get into the details on how our Support Engineers create back up and restore AbanteCart databases and fix errors.

How we back up an AbanteCart database

Here, let’s see how our Support Engineers do back up and restore AbanteCart databases.

1. Initially, we login to the AbanteCart admin panel.

2. Then, we go to Go to Systems >> Data >> Backup/Restore option

3. Next, we select the databases which want to back up and click the Backup Now button.

4. Once the backup process finished, we will get a success message. So, we can check the available backup in the section admin panel >> System >> Logs >> Install/Upgrade History.

5. Also, to restore a backup, browse the backup and click the Restore button.

This is how we back up and restore the databases in AbanteCart

back up an AbanteCart database – Related errors and fixes

At Bobcares, where we have more than a decade of expertise in managing servers, we see many customers face problems while taking the backup and restoring the same.

Now, let’s see the major reasons for this AbanteCart related errors and how our Support Engineers fix the top errors.

Problem with PHP parameters

Recently, one of our customers had problems while backup an AbanteCart site. While taking the backup, he received an error like,

Error: cannot to pack /home/user/public_html/online-store/admin/system/backup/manual_backup.tar.gz

On checking, our Support Engineers found that time for executing PHP-script exceeded the limit. So, we increased the execution time parameter in php.ini directives and fixed the error.

Sometimes, it may also happen due to when memory for PHP is not enough. At that time, we’ll tweak the PHP memory value in the php.ini file.

Bad table prefix

Similarly, many customers may experience errors while upgrading the  AbanteCart store. During the upgrade process (within the Admin Panel), customers may get the following error.

Error: Can't create sql dump of database during backup.

As part of the upgrade process, there will be a backup process. But, tables in the SQL upgrade file have an “ac_” as a prefix. Customers may forget to replace it with their own prefix. Then, it creates a problem while taking the backup.

So, our Support Engineers will assist the customers on the upgrade process and backup process.

[Need assistance to fix AbanteCart related errors? We’ll help you.]

Conclusion

In short, while we backup an AbanteCart database we might face errors due to misconfigurations like change in table prefix or insufficient PHP memory value. Today, we saw how our Support Engineers fixed these errors.