Database management in the Hestia CP control panel

Hestia CP is one of the most popular, simple, and user-friendly control panels for server management. With its help, you can add new sites, work with email and databases, configure Cron tasks, manage updates, use the file manager, and add SSL certificates.

Creating a Database

To create a database on the server, go to the DB section and click Add DB.

Fill in the database creation form fields: specify the database name, database username, and password.

Managing Database via PhpMyAdmin

Go to database management in PhpMyAdmin by logging in with the credentials obtained when creating the database.

Importing a Database

Select the database name into which the existing database will be uploaded, and go to the Import tab. Select a database file on your computer in the format bd.sql or an archived file with extensions: bd.sql.gzip, bd.sql.bzip2, or bd.sql.zip.

Click the Go button.

Increasing File Upload Limit

By default, PhpMyAdmin settings have a DB file upload limit of 2,048 KiB.

You can bypass it in two ways:

• Archive the database file using archivers that add the extensions mentioned above (gzip, bzip2, zip).

• Edit the php.ini file and change the following parameters:

  • post_max_size = 8M — change to the required value, for example 10M.
  • upload_max_filesize = 2M — also change to 10M.

Editing php.ini via Control Panel

To edit the php.ini file, go to the Settings tab, select the Apache2 web server item, and click the Edit button.

Then click the Configure PHP button.

Parameter Description

• post_max_size — maximum size of data in bytes that can be sent via POST method. Generally, it should be larger than upload_max_filesize and smaller than memory_limit. Byte value labels are used: K (kilo), M (mega), and G (giga). For example, 10M.

• upload_max_filesize — limit on the maximum size of a file uploaded to the server. Specified in megabytes.

Save the changes.

---