Contents Domains and hosting Subdomains, PHP, SSL and firewall Registering a domain Transferring a domain to us Mail Databases Applications SFTP access File manager Cron jobs Payments and plans Support and the AI assistant

Databases

Databases are MySQL/MariaDB. They run on the same server as your websites.

Creating a database

  1. Open "Hosting" → "Databases" and click "Add database".
  2. Enter a short name: lowercase Latin letters and digits. The full name gets a prefix for your account, for example db12_shop. The form shows the prefix.
  3. Enter a password.

Each database has its own user, with the same name as the database and the password you set. The user has full rights on its own database only. The database is ready within a minute.

How many databases you can have depends on your hosting plan.

Connecting from your website

In your application's settings (for example wp-config.php for WordPress), enter:
Server (host) localhost
Database the full name, for example db12_shop
User the same as the database name
Password the password set when creating it

Databases accept connections only from the websites on the same server. There is no remote access, for example from your own computer.

Managing and importing: phpMyAdmin

Open "Hosting" → "Databases" and click "phpMyAdmin" (or "Hosting" → "phpMyAdmin"). It opens in a new tab, already logged in - no password. Its address is on your hosting's server, for example https://web1.taugate.com/<account>/phpMyAdmin/.

  • It shows all of the hosting account's databases - the ones of applications installed from the panel too. Other customers' databases aren't visible.
  • You can browse and change tables and data, run SQL queries, export and import.
  • Import: a file of up to 32 MB. An SQL dump compressed as .gz or .zip is accepted too - that's how larger databases fit. For even larger ones, contact us.
  • New databases aren't made in phpMyAdmin - add them in the panel (how many depends on the plan).

The login lasts while you work in phpMyAdmin; after that it is opened again from the panel. A suspended hosting has no phpMyAdmin.

Most applications (WordPress, Joomla, PrestaShop and others) create their tables themselves when installed.

Backups

Every night we back up each database and keep the last 7 days. The backups are in the hosting's backups folder (/backups/<date>/databases/<database>.sql.xz - over SFTP and in the file manager, see File manager) and can be downloaded. To restore from a backup, use the hosting's "Backups" page (see File manager): the database's content is replaced entirely with that of the chosen day.

Deleting a database can't be undone: its data is deleted too.