Support / Databases

Databases

• Creating databases
• Accessing databases via web interface
• Importing databases
• Using database server locally
• Remote database access
• Database troubleshooting

Creating databases

All databases should be created via cPanel hosting control panel, phpMyAdmin / phpPgAdmin will not allow you to create a database!

Accessing databases via web interface

It's possible to work with databases at our servers using special web tools, such as «phpMyAdmin» (MySQL databases) and «phpPgAdmin» (PostgreSQL databases).

Importing databases

You may import a MySQL database via «phpMyAdmin» (PostgreSQL — via «phpPgAdmin»). These tools allow you to import a database up to 50 Mb in size. If there's a need to import a larger database, please follow the tutorial below:

Using database server locally

To use a local database server (for example, to connect your website to it) you should use the following hostnames:

• MySQL database — mysql:3306
• PostgreSQL database — localhost:5432

Remote database access

To configure a remote access to the MySQL daabase server, you must add your server's IP address to the list of allowed remote hosts. Please follow the tutorial below to do so:

For accessing remotely a PostgreSQL database server, no actions are required.

To use a database server remotely, please use the following hosts:

• MySQL database — sql3.nano.lv:3306
• PostgreSQL database — your_server_id.nano.lv:5432 (e.g. if24.nano.lv:5432)

• MySQL database — sql4.nano.lv:3306

Database troubleshooting

• Problems connecting to the database

  Please check you database name, username and password, and database server hostname.

  The most commonly seen mistake — use of «localhost» database host instead of «mysql» when working with MySQL. We do not guarantee anything if you've managed to get a working database via «localhost».!

• Database throws out an error "Table .... is marked as crashed and should be repaired"

  To fix up this problem, please follow this tutorial:

  How to fix crashed MySQL table