Kundencenter Datenbank mySQL dbadmin/en

Aus EUserv Wiki

Wechseln zu: Navigation, Suche

Using the database web frontend

Inhaltsverzeichnis

Using the database web frontend

General

If you have an EUserv webspace plan, you have the possibility of using databases for your website and manage them via a web frontend.

A database stores large amounts of data efficiently, consistent and durable. In addition, a database provides the required subsets in different, demand representation forms for each user and their application programs.

Starting a database web frontend

In the EUserv customer service center, you have the possibility to manage the created mySQL databases.

Choose your webspace contract for which you want to manage the mySQL databases.

Datei:kc-vertrag-wählen_572x.png



Once you have selected your webspace contract, click on "mySQL".

Datei:mysql_db_kc_572x.png



Here you can manage the mySQL databases for your webspace plan. The overview page "DB-Accounts" shows you, how many databases are available in your plan, how the quota is set and how high the utilization of these options is. ("maximum number of database in the rate, maximum size of database in the rate, database quota max / set / used"). By clicking on "https://support.euserv.de/dbadmin" below "Datenbank-Webfronted" you have access to the corresponding web frontend. Alternatively, you can enter the URL directly in your browser.

Datei:mysql_db_angelegt_572x.png



On the startpage of the web frontend, you must first select the server from the drop down menu where your database is located. The overview page of your database shows you on which server the database is stored and which you want to edit (see above). On this page you can see the user's name and password for your databases. If you have selected the server from the drop down menu, the login window is open automatically. Enter your accordingly entries and confirm by clicking on "Ok".

Vergrößern



Manage mySQL server

After a successful login, you go to the startpage of the database web frontend.

Vergrößern



You can reach this page of the database web frontend anytime with a click on the icon.

By clicking on "Databases" you come on the page of the mySQL database server where your database is stored. On this page you can select different parameters about the databases of the mySQL server.

Vergrößern



By clicking on "Export" you come on the export page of the mySQL server where your database is stored. On this you can export databases from the mySQL server. In addition, mark the field in the database (e.g. db111111_11). Then select the desired export file format.

Vergrößern



You can select different options additionally. Below you have the possibility to download the database file and if you want to compress. To start the export, click on "Go". To download the file in the selected format, you must activate the check box "Save as file". The compression can be selected below. If you have not activate "Save as file", the file is shown in the text format directly in the database web frontend.

Vergrößern



Vergrößern



By clicking on "Import" you come on the import page of the mySQL server where your database is stored. On this page you can import databases to the mySQL server. Click on "Browse" to select your local file (e.g. db04.kundencontroller.de.sql) and confirm with "Öffnen". To start the import, click on the command button "Go".

Vergrößern



By clicking on "SQL" you come on the command page of the mySQL database. On this page you can integrate SQL command(s) in the database. You can store each entry in the white field with a click on "Ok".

Vergrößern



By clicking on "Show MySQL runtime information" you come on the status page of the mySQL server where your database is stored. On this page you can select different parameters such as traffic, connections, etc. of the mySQL server.

Vergrößern



By clicking on "Show MySQL system variables" you come on the variable page of the mySQL server where your database is stored. On this you can select different parameters about variables and settings of the mySQL server.

Vergrößern



By clicking on "Processes" you come on the process page of the mySQL server where your database is stored. On this you can select different parameters of running processes of the mySQL server.

Vergrößern



By clicking on "Character Sets and Collations" you come on the font page of the mySQL server where your database is stored. On this you can select different parameters about fonts and collations of the mySQL server.

Vergrößern



By clicking on "Storage Engines" you come on the table format page of the mySQL server where your database is stored. On this you can select different parameters about table formats of the mySQL server.

Vergrößern



Manage mySQL database

On the home page of the web front-end database you see the listed database on the left above. Please note that each database user's account can be created for only one database. With user db111111_11 you can create only one database db111111_11 (or if this happens automatically with the created account - you'll see here: https://www.euserv.com/wiki/index.php/Kundencenter_Datenbank_mySQL). For another database for your webspace (e.g. db111111_12) you must also create a new user (e.g. db111111_12). Select this by clicking on the name.

Vergrößern



On it you go to the structure page of the selected database. This is basically a summary page of the contents of this database. With "Create new table on database" you can now add new content to this database.

Vergrößern



By clicking on "Search" you come on the search page of the mySQL database. On this you can search for items in the database. This requires, that some entries in the database are available.

If this is not the case, a "Stopp" icon appears if you go with the mouse over the tab "Search".

Vergrößern



By clicking on "Query" you come on the query editor page of the mySQL database. On this you can enter SQL commands. This requires, that some entries in the database are available.

If this is not the case, a "Stopp" icon appears if you go with the mouse over the tab "Query".

Vergrößern



By clicking on "Export" you come on the export page of the mySQL database. On this you can export the database. This requires, that some entries in the database are available.

If this is not the case, a "Stopp" icon appears if you go with the mouse over the tab "Export".

Vergrößern



By clicking on "Import" you come on the import page of the mySQL database. On this you can import the database.

Vergrößern