The Hepsia web hosting Control Panel features a fully featured database administration user interface, which will give you full authority over your databases. You can effortlessly set up brand new MySQL and PostgreSQL databases and manage their content through the phpMyAdmin and phpPgAdmin software tools respectively.
An Easy-to-Use Interface
With the Database Manager, you can set up a brand new database in a matter of seconds - just specify its name and that's it. You will see a list of all your DBs and their corresponding sizes. You will be able to modify passwords, to create backup files and to even log in to the phpMyAdmin and phpPgAdmin tools.
Simple Database Backups
It is quite important to make routine backups of your DBs to secure your web site content and to steer clear of any incidental loss of data. With the Database Manager graphical user interface, creating a database backup is very easy. Just press the Backup button next to the database you want to back up and you will be immediately taken to the File Manager section 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 differs depending on the web hosting plan that you have selected. While MySQL is a very popular database management system utilized by 1 000 000's of users all around the globe, PostgreSQL is regarded as being a more innovative database management system and is mainly utilized by technically accomplished website owners. 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 MySQL, which is aimed at securing user data and at enhancing multi-user concurrency and performance. When you want to create a new database table, simply log in to the Hepsia hosting Control Panel-incorporated phpMyAdmin database administration tool and choose the InnoDB database engine from the list of available storage engines.
Hepsia's Database Manager section also comprises comprehensive stats about your DBs, including the number of hourly queries. This will give you an idea of how much load is created during a particular time period.