The Hepsia web hosting Control Panel features a fully featured database administration graphical user interface, which will grant you total authority over your DBs. You can easily set up new MySQL and PgSQL DBs and administer their content through the phpMyAdmin and phpPgAdmin software tools respectively.
An Easy-to-Use Interface
With the Database Manager interface, you can set up a brand new DB in a matter of seconds - simply fill in its name and that's all. You will see a list of all your DBs and their corresponding sizes. You will be able to edit passwords, to create database backups and to even log in to the phpMyAdmin and phpPgAdmin software tools.
Simple Database Backups
It is very essential to create routine backups of your DBs to protect your web site content and to prevent any unexpected loss of data. With the Database Manager user interface, creating a database backup file is extremely easy. Simply press the Backup button next to the database you would like to back up and you will be immediately taken to the File Manager section from where you can download your freshly created database backup file.
MySQL and PgSQL Databases
The number of PostgreSQL and/or MySQL DBs that you can create varies based on the web hosting package that you have ordered. While MySQL is a very famous database management system employed by millions of individuals all around the world, PostgreSQL is regarded as being a more advanced database management system and is chiefly employed by technically advanced webmasters. You can administer your MySQL databases via the phpMyAdmin tool, whereas PgSQL databases can be administered through the phpPgAdmin tool.
InnoDB is the leading storage engine for the MySQL database management system, which is aimed at protecting user data and at increasing multiuser concurrency and performance. When you wish to create a new DB table, simply log in to the Hepsia web hosting Control Panel-incorporated phpMyAdmin database administration tool and pick the InnoDB storage engine from the list of available database engines.
Hepsia's Database Manager also contains thorough stats about your databases, including the number of hourly queries. This will give you a clue about how much load is generated over a certain period.