Frequently asked questions

Back
How do I manage my MySQL database?

There are several things you can do to administer your database with us, depending on what you want to do.

  1. Activate databases
  2. Change password
  3. Backup/download database
  4. Drop/delete/erase databases
  5. Restore databases from backup
  6. Administration from your own computer
  7. Administration with the mysql command in Unix shell
  8. Administration with phpMyAdmin (NOT recommended)

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).


Change password

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.


Drop/delete/erase databases

Note! This is a risky procedure! Backup your database first!

Via the control panel

  1. Login as usual in the controlpanel at www.domainnameshop.com/login.
  2. Select the domain from "My domains".
  3. Select the "Webhotel" tab.
  4. Select "View/change" on the MySQL line.
  5. Click the icon with the lightning (Erase database) 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:


Administration with the mysql command in Unix shell

This is for advanced users only.

The mysql command is available on our login server for Unix shell, login.domeneshop.no, enabling you to manage the database.


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.


See also:

Keyword:  

Index

© 2017 Domeneshop AS · About us · Terms & Conditions · About cookies