The Hepsia web hosting Control Panel features a full-featured database administration user interface, which will give you full authority over your DBs. You can easily set up brand new MySQL and PgSQL databases and administer their content via the phpMyAdmin and phpPgAdmin database management tools respectively.
An Easy-to-Use Interface
With the Database Manager graphical user interface, you can set up a brand new DB in a matter of seconds – simply fill in its name and that’s it. You will notice a list of all your databases and their corresponding sizes. You will be able to modify passwords, to create database backup files and to even log into the phpMyAdmin and phpPgAdmin software tools.
Simple Database Backups
It is very essential to make frequent backups of your databases to secure your web site content and to refrain from any unexpected data loss. With the Database Manager, creating a database backup file is extremely easy. Just push the Backup button next to the database you want to back up and you will be instantly taken to the File Manager from where you can download your newly created backup file.
MySQL and PgSQL Databases
The number of PgSQL and/or MySQL databases that you can create varies depending on the hosting package that you have chosen. While MySQL is a very famous database management system employed by millions of individuals all around the globe, PostgreSQL is thought of as being a more innovative database management system and is mainly utilized by technically knowledgeable web site owners. You can manage your MySQL DBs through the phpMyAdmin tool, whereas PostgreSQL DBs can be administered through the phpPgAdmin tool.
InnoDB is the leading transactional storage engine for MySQL, which is aimed at protecting user data and at enhancing multi-user concurrency and performance. When you need to create a new database table, just log into the Hepsia web hosting Control Panel-incorporated phpMyAdmin database management tool and pick the InnoDB storage engine from the list of available database engines.
Hepsia’s Database Manager also includes detailed stats about your databases, including the amount of hourly database queries. This will give you an idea of how much load is created over a specific period.