Frequently asked questions
There are several things you can do to administer your database with us, depending on what you want to do.
- Activate databases
- Change password
- Backup/download database
- Drop/delete/erase databases
- Restore databases from backup
- Administration from your own computer
- Administration with the
mysqlcommand in Unix shell
- Administration with phpMyAdmin (NOT recommended)
- TLS connections (SSL)
Please note that you do not have administrator/system privileges for our MySQL servers. Certain things are therefore restricted. If the MySQL documentation shows that your action requires system privileges, you do not have access. For instance, you may not choose the name(s) for your database(s), or create additional users with access to your database(s).
When you have activated a MySQL database, you may also change its password. Follow the same steps as when activating your database. Your password is ordinarily updated in the database within 10-20 minutes.
Restore databases from backup
To restore a database from backup, use the same program you used to backup with. There may be significant differences between how different software handles backup.
Exception: if you backup with
mysqldump, you cannot use it to restore. You may use other software, e.g. by running the backup file as a regular SQL script.
Note! This is a risky procedure! Backup your database first!
Via the control panel
- Login as usual in the controlpanel at www.domainnameshop.com/login.
- Select the domain from "My domains".
- Select the "Webhotel" tab.
- Select "View/change" on the MySQL line.
- Click the icon with the lightning () rightmost on the line with the relevant database.
With a database administration tool
Using your favorite database administration tool, you may use the command
drop database DATABASENAME;which will remove your entire database. If you do not disconnect and immediately perform
create database DATABASENAME;the database will be recreated as empty. As a last resort, you may also change your database password , this will recreate any missing database.
Note! Our control panel for databases cannot discover changes you perform via other programs for database administration. If you e.g.
drop database without recreating the database yourself, our control panel will still believe that the database exists, and show you its information. But if you change your password via the control panel, the database will be recreated within 10-20 minutes.
Administration from your own computer
There is a lot of database administration software that you can install on your own computer, here are some of them:
- MySQL Workbench (MacOS, Windows, Linux) - see the FAQ entry for backups for some information on usage
- Sequel Pro (MacOS)
- EMS SQL Manager (Windows)
- NaviCat (MacOS, Windows, Linux)
- HeidiSQL (Windows)
Administration with the
mysql command in Unix shell
This is for advanced users only.
mysql command is available on our login server for Unix shell,
login.domeneshop.no, enabling you to manage
Administration with phpMyAdmin (NOT recommended)
We DO NOT recommend that you use phpMyAdmin, neither as a plugin to Joomla or WordPress, nor as a separate program. Use software on your own computer instead.
We have not installed phpMyAdmin, and the reason for this and that we do not recommend it, is that the installation is complicated, and that it needs frequent updates to handle security vulnerabilities.
If you still want to use phpMyAdmin, ensure that you download it from phpMyAdmin, and that you join the phpMyAdmin news mailing list so that you update phpMyAdmin immediately when a new version is available.
TLS connections (SSL)
As of late July 2018, we offer TLS connections to MariaDB 10.3 databases, and from December 2018 to MySQL 5.7 databases. External connections must go via TLS. There are also additional limits on the number of external connections.
Other database servers do not support TLS.