Hi All,
Greetings of the day.
The module helps to integrate the Database Management Tool Adminer in the back office.
This helps to run SQL queries, perform database backups, and perform various jobs such as
SELECT/INSERT/UPDATE/DELETE database tables and columns
in tables. Also, get information and search data in different tables and databases.
It is a fully functional database administration panel available in many databases. It works
with very huge/big database sizes in GB, for example, a 4 GB database.
The most frequently used operations are supported by the user interface (managing
databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the
ability to directly execute any SQL statement.
Features
- Create, drop and alter tables
- Delete, edit and add fields as well as manage keys on fields
- Execute any SQL statement
- Query your databases
- Manage privileges
- Export data into various formats
- Back up and restore your databases
- Connect to a database server with a username and password
- Select an existing database or create a new one
- List fields, indexes, foreign keys and triggers of the table
- Change the name, engine, collation, auto_increment, and comment of the table
- Alter name, type, collation, comment and default values of columns
- Add and drop tables and columns
- Create, alter, drop and search by indexes, including full-text
- Create, alter, drop and link lists by foreign keys
- Create, alter, drop and select from views
- Create, alter, drop and call stored procedures and functions
- Create, alter and drop triggers
- List data in tables with search, aggregate, sort and limit results
- Insert new records, update and delete the existing ones
- Supports all data types and blobs through file transfer
- Execute any SQL command from a text field or a file
- Export table structure, data, views, routines, and databases to SQL or CSV
- Print database schema connected by foreign keys
- Show processes and kill them
- Display users and rights and change them
- Display variables with links to documentation
- Manage events and table partitions (MySQL 5.1)
- Schemas, sequences, user types (PostgreSQL)
- Easy to install and use.
- Nice graphical user interface to perform various database operations on multiple databases.
- Security using a login and password screen.
- Cross-platform works on all Windows and Linux distributions.
- Help you interact with your MySQL database easily and effortlessly.
- Web-Based, which means you can access from any computer
- Local resources aren’t used when connecting
- Simplicity.
- Compatible with PrestaShop 1.6.x,1.7.x.8.x.x,9.x.x
Benefits to Merchants
- It has a user friendly and intuitive user interface with a little learning curve, meaning that people can use and get used to the functions easily and quickly.
- It allows users to perform most of the MySQL functions, including managing databases, running MySQL queries, executing SQL statements, managing users and permissions, and many more.
- It can import data and export data from and to different formats.
- It is able to alter the stored data into any other format with the help of predefined functions.
Installation
Step 1: Upload the module zip file from the back-office Module & Services menu tab. Module Manager area using the upload button. After the successful installation module menu, the link will appear in the left menu or top menu in the back-office more area.
Step 2: Install the module using the install button.
Step 3: Visit the module management page from the back-office “More” area (section) in the left menu in the back-office.
Step 4: The module installation process is very easy. How the module configuration works can be seen in a demo instance.
Step 5: Please visit our demo instance for module configuration and usage demo.
Step 6: Please watch our demo video on our YouTube Channel for module configuration and usage demo.
– Module works without making any change in the existing PrestaShop file, so that existing customisation and theme changes are not affected.
– We provide free technical and feature support in installation and configuration, as well as access to updates available for this product.
– Free support on installation, configuration, and customisation as per store requirements, for example, new hook addition on your store.
Other :
Please leave your valuable feedback after using the module on this post.
This will help to increase self-confidence, improve service, and enhance the module as per requirements to make it better for different online stores.
Our Website URL => https://www.presta-addons-modules.com/en/
Download Module and Documentation File.
Please note module will send an email to the developer with only the website link to know the module was installed successfully and is working fine. This is to know the module is working fine and will improve enhancements as per requirements in future. Customer’s success is our satisfaction.