Zohaib-fk Posted April 12, 2019 Share Posted April 12, 2019 (edited) Hi All, Greetings of the day. The module helps to integrate Database Management Tool Adminer in the back-office. This helps to run SQL queries, and 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 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 table Change name, engine, collation, auto_increment, and comment of 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 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 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 formats 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 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 customization and theme change do not affect. - 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 customization 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/ Pay any amount as per your choice to get the multi-languages,multi-shops, and multi-shop-groups feature in the free addon Download Module and Documentation File. readme_en.pdf sfkdbmanage.zip Edited December 20, 2023 by Zohaib-fk Post Updated for screenshot & new features information (see edit history) 1 Link to comment Share on other sites More sharing options...
SMA17 Posted June 26, 2019 Share Posted June 26, 2019 Not Work to download Link to comment Share on other sites More sharing options...
Zohaib-fk Posted July 1, 2019 Author Share Posted July 1, 2019 Hi, Greetings of the day. Please watch YouTube demo video on our channel. Please elaborate more about the problem. Have a nice day. Link to comment Share on other sites More sharing options...
SMA17 Posted July 2, 2019 Share Posted July 2, 2019 (edited) Can we import database from 1.6 shop to 1.7 shop? Edited July 2, 2019 by SMA17 (see edit history) Link to comment Share on other sites More sharing options...
Zohaib-fk Posted November 6, 2019 Author Share Posted November 6, 2019 (edited) Hi, Greetings of the day. We will need a database migration tool for moving from version 1.6 to 1.7. I think modules related to PrestaShop upgrade can help to upgrade the database and files from version 1.6 to 1.7 Have a nice day. Edited November 6, 2019 by Zohaib-fk (see edit history) Link to comment Share on other sites More sharing options...
Xordiet Posted November 26, 2019 Share Posted November 26, 2019 Hi Zohaib-fk, When I try to install into a PrestaShop 1.7.1.1, i receive this error: Compile Error: Cannot declare class Sfkdbmanage, because the name is already in use Regards Link to comment Share on other sites More sharing options...
Jose Lorenzini Posted February 26, 2020 Share Posted February 26, 2020 Hello Shahab thanks for this module , i cant download the documentation file , can you update the link? thanks Link to comment Share on other sites More sharing options...
Zohaib-fk Posted May 30, 2020 Author Share Posted May 30, 2020 Hello, Greetings of the day. My files attachment quota ( file attachment limit ) was finished therefore I was not able to upload the documentation PDF. Now Attached the PDF file. Have a nice day. Link to comment Share on other sites More sharing options...
TomekThePunk Posted April 15 Share Posted April 15 Hi 🙂 Your module is awesome. You've saved my a** a couple of times xD But now I have a little problem. After migrating to another server, your module stopped working. I reinstalled it. Upon entering, it shows a 403 Forbidden Access to this resource on the server is denied. Have you encountered anything like this before? with regards Tomek Link to comment Share on other sites More sharing options...
TomekThePunk Posted April 18 Share Posted April 18 Ok, I found the reason. The problem is Imunifi 360 malware scanner on server. I added the module to exceptions and it started working. Link to comment Share on other sites More sharing options...
Matt-PS Posted April 26 Share Posted April 26 Hi, the admin page of the module returns this "Forbidden You don't have permission to access this resource." My user is superAdmin, do you know what could be the issue ? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now