Shopping Cart
There are no more items in your cart
- Tecnoacquisti.com
- Prestashop Tutorial
Click
PrestaShop offers built-in tools to interact with the database directly from the back-end, without the need to access external software such as phpMyAdmin.
These tools are available in two sections:
1. Advanced Parameters → Database → SQL Manager
How to access and use the SQL Manager
The SQL Manager allows you to run custom database queries directly from the PrestaShop administration interface.
- Go to Advanced Parameters → Database → SQL Manager.
- Click on "Add a new query" to write and execute SQL commands.
- You can save queries for future use by making them accessible directly from the same section.
- Saved queries can be quickly executed with one click.
Benefits of the SQL Manager
Ease of use:
Allows you to run queries without accessing external tools or the server directly.Security:
Requires no additional credentials, as it uses admin back-end permissions.Predefined and reusable queries:
You can save frequent SQL queries (e.g., check stock status or recent orders) for future use.Controlled Access:
Only administrators with the appropriate permissions can use this feature, reducing the risk of unauthorized access.
Limitations of the SQL Manager
Limited functionality:
Not designed to handle complex operations such as full database backups or structural changes to tables.Restricted access:
Some queries may not work, especially if they require higher permissions on the database.Simplified interface:
Does not offer advanced tools for graphical data visualization or table editing.
2. Advanced Parameters → Database → DB Backup
Database Backup
This section allows you to make a full copy of the database for security or migration purposes.
How to make the backup
- Go to Advanced Parameters → Database → DB Backup.
- Click on "Generate a new backup." PrestaShop will create a
.sqlfile containing a complete copy of the database. - You can download the backups directly from the administrative panel.
Benefits of DB Backup
Simplicity:
No need to access the server or external tools to generate the backup.Automation and security:
PrestaShop automatically saves backups to a secure directory on the server. You can also configure permissions to access only authorized users.Portability:
Backup files can be easily imported to another PrestaShop installation or to a different server.
DB Backup Limitations
Database only:
Backup does not include site files (images, forms, etc.). You must perform a separate backup for files via FTP or other means.Disk space:
Generating frequent backups can take up server space, so you need to monitor available space regularly.No advanced configuration:
Does not allow advanced configuration (e.g., exclude tables or limit the number of rows per table).
Comparison: SQL Manager vs DB Backup
| Feature | SQL Manager | DB Backup |
|---|---|---|
| Features | Execution of custom queries | Creating full backups |
| Purpose | Data analysis, specific control | Data security and restoration |
| Technical level required | Medium (writing SQL queries) | Low (click and download) |
| Inclusion of site files | No | No |
| Possibility of customization | High (tailored queries) | Low |
Practical advice
- Use the SQL Manager for quick analysis or to get specific database information (e.g., quantities in stock, open orders).
- Use DB Backup regularly to safeguard data, especially before significant updates or changes to the site.
- Back up site files as well (via FTP or hosting tools) to have a complete copy of your e-commerce.
Author: Loris Modena
SENIOR DEVELOPER
Per Ind Loris Modena owner of Arte e Informatica, began working in the computer industry in 1989 as a systems engineer in charge of maintenance and installation of computer systems. He starts programming for the web in 1997 dealing with CGI programming in PERL and later moving to programming in PHP and JavaScript. During this period he approaches the Open source world and Linux server management.