The Hepsia hosting Control Panel includes a full-featured database administration graphical user interface, which will grant you absolute command over your databases. You can easily create brand new MySQL and PostgreSQL databases and administer them via the phpMyAdmin and phpPgAdmin tools respectively.
An Easy-to-Use Interface
With the Database Manager user interface, you can set up a new database in seconds – just specify its name and that’s all. You will see a list of all your DBs and their corresponding sizes. You will be able to alter passwords, to create backups and to even log into the phpMyAdmin and phpPgAdmin database management tools.
Simple Database Backups
It is very important to make regular backups of your databases to protect your website content and to avoid any accidental loss of data. With the Database Manager user interface, creating a database backup file is very easy. Just press the Backup button next to the database you wish to back up and you will be immediately taken to the File Manager from where you can download your newly created database backup file.
MySQL and PgSQL Databases
The number of PgSQL and/or MySQL databases that you can set up varies depending on the web hosting plan that you have with us. While MySQL is a very famous database management system employed by millions of users all over the globe, PostgreSQL is looked upon as being a more innovative database management system and is chiefly used by technically knowledgeable website owners. You can administer your MySQL databases via the phpMyAdmin tool, while PostgreSQL databases can be administered via the phpPgAdmin software tool.
InnoDB is the leading database engine for MySQL, which is aimed at protecting users’ data and at increasing multi-user concurrency and performance. When you need to create a new DB table, simply log into the Hepsia Control Panel-integrated phpMyAdmin database management tool and select the InnoDB database engine from the list of available engines.
Hepsia’s Database Manager section also comprises comprehensive statistics about your DBs, including the number of hourly database requests. This will give you an idea of how much load is created over a specific period.