Kundencenter Datenbank mySQL dbadmin/en
Aus EUserv Wiki
(→Manage mySQL database) |
(→Starting a database web front-end) |
||
| Zeile 30: | Zeile 30: | ||
<br> | <br> | ||
<br> | <br> | ||
| - | 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 option. ("a maximum number of database in the rate, a maximum size of database in the rate, database quota max / set / used"). By clicking on "https://support.euserv.de/dbadmin" below "Datenbank-Webfronted" to access the corresponding web front-end. Alternatively, you can enter the URL directly in your browser or appeal as a | + | 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 option. ("a maximum number of database in the rate, a maximum size of database in the rate, database quota max / set / used"). By clicking on "https://support.euserv.de/dbadmin" below "Datenbank-Webfronted" to access the corresponding web front-end. Alternatively, you can enter the URL directly in your browser or appeal as a bookmark stored. |
<br> | <br> | ||
<br> | <br> | ||
| Zeile 38: | Zeile 38: | ||
<br> | <br> | ||
<br> | <br> | ||
| - | On the homepage of the web front-end database, you must first select the server from the drop down menu where your database is located. | + | On the homepage of the web front-end database, you must first select the server from the drop down menu where your database is located. On the overview page of your databases shows, 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 namely the server from the drop down menu, the login entry window is automatically open. Fill it out accordingly and confirm your entries by clicking on "Ok". |
<br> | <br> | ||
<br> | <br> | ||
| Zeile 46: | Zeile 46: | ||
<br> | <br> | ||
<br> | <br> | ||
| + | |||
=== Manage mySQL server === | === Manage mySQL server === | ||
| + | |||
After a successful login, you go to the homepage of the database web front-end. | After a successful login, you go to the homepage of the database web front-end. | ||
<br> | <br> | ||
| Zeile 57: | Zeile 59: | ||
You can reach this page of the database web front-end anytime with a click on the icon. | You can reach this page of the database web front-end anytime with a click on the icon. | ||
| - | By clicking on "Databases" | + | By clicking on "Databases" to get to the page of the mySQL database server where your database is stored. On this you can select different parameters about the databases of the mySQL server. |
<br> | <br> | ||
<br> | <br> | ||
| Zeile 65: | Zeile 67: | ||
<br> | <br> | ||
<br> | <br> | ||
| - | By clicking on "Export" | + | By clicking on "Export" to get to the export page of the mySQL server where your database is stored. On this you can export databases in the mySQL server. |
In addition, mark the field in the database (e.g. db111111_11). Then select the desired export file format. | In addition, mark the field in the database (e.g. db111111_11). Then select the desired export file format. | ||
<br> | <br> | ||
| Zeile 88: | Zeile 90: | ||
<br> | <br> | ||
<br> | <br> | ||
| - | By clicking on "Import" | + | By clicking on "Import" to get to the import page of the mySQL server where your database is stored. On this you can import databases in 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". | 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". | ||
<br> | <br> | ||
| Zeile 97: | Zeile 99: | ||
<br> | <br> | ||
<br> | <br> | ||
| - | By clicking on "SQL" | + | By clicking on "SQL" to get to the command page of the mySQL database. On this you can incorporate the SQL command in the database. You can store each entry in the field with a click on "Ok". |
<br> | <br> | ||
<br> | <br> | ||
| Zeile 105: | Zeile 107: | ||
<br> | <br> | ||
<br> | <br> | ||
| - | By clicking on "Show MySQL runtime information" | + | By clicking on "Show MySQL runtime information" to get to the status page of the mySQL server where your database is stored. On this you can select different parameters such as traffic, links, etc. of the mySQL server. |
<br> | <br> | ||
<br> | <br> | ||
| Zeile 113: | Zeile 115: | ||
<br> | <br> | ||
<br> | <br> | ||
| - | By clicking on "Show MySQL system variables" | + | By clicking on "Show MySQL system variables" to get to 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. |
<br> | <br> | ||
<br> | <br> | ||
| Zeile 121: | Zeile 123: | ||
<br> | <br> | ||
<br> | <br> | ||
| - | By clicking on "Processes" | + | By clicking on "Processes" to get to 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. |
<br> | <br> | ||
<br> | <br> | ||
| Zeile 129: | Zeile 131: | ||
<br> | <br> | ||
<br> | <br> | ||
| - | By clicking on "Character Sets and Collations" | + | By clicking on "Character Sets and Collations" to get to 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. |
<br> | <br> | ||
<br> | <br> | ||
| Zeile 137: | Zeile 139: | ||
<br> | <br> | ||
<br> | <br> | ||
| - | By clicking on "Storage Engines" | + | By clicking on "Storage Engines" to get to 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. |
<br> | <br> | ||
<br> | <br> | ||
| Zeile 164: | Zeile 166: | ||
<br> | <br> | ||
<br> | <br> | ||
| - | By clicking on "Search" | + | By clicking on "Search" to get to 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". | If this is not the case, a "Stopp" icon appears if you go with the mouse over the tab "Search". | ||
| Zeile 174: | Zeile 176: | ||
<br> | <br> | ||
<br> | <br> | ||
| - | By clicking on "Query" | + | By clicking on "Query" to get to 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". | If this is not the case, a "Stopp" icon appears if you go with the mouse over the tab "Query". | ||
| Zeile 184: | Zeile 186: | ||
<br> | <br> | ||
<br> | <br> | ||
| - | By clicking on "Export" | + | By clicking on "Export" to get to 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". | If this is not the case, a "Stopp" icon appears if you go with the mouse over the tab "Export". | ||
| Zeile 194: | Zeile 196: | ||
<br> | <br> | ||
<br> | <br> | ||
| - | By clicking on "Import" | + | By clicking on "Import" to get to the import page of the mySQL database. On this you can import the database. |
<br> | <br> | ||
<br> | <br> | ||
Version vom 13:23, 22. Nov. 2012
| Languages: |
Deutsch |
Using the database web front-end
Inhaltsverzeichnis |
Using the database web front-end
General
If you have an EUserv webspace plan, you have the possibility of using databases for your website and manage them via a web front-end.
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 front-end
In the EUserv customer service center, you have the possibility to manage the designed mySQL databases.
Choose your webspace contract for which you want to manage the mySQL databases.
Once you have selected your webspace contract, click on "mySQL".
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 option. ("a maximum number of database in the rate, a maximum size of database in the rate, database quota max / set / used"). By clicking on "https://support.euserv.de/dbadmin" below "Datenbank-Webfronted" to access the corresponding web front-end. Alternatively, you can enter the URL directly in your browser or appeal as a bookmark stored.
On the homepage of the web front-end database, you must first select the server from the drop down menu where your database is located. On the overview page of your databases shows, 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 namely the server from the drop down menu, the login entry window is automatically open. Fill it out accordingly and confirm your entries by clicking on "Ok".
Manage mySQL server
After a successful login, you go to the homepage of the database web front-end.
You can reach this page of the database web front-end anytime with a click on the icon.
By clicking on "Databases" to get to the page of the mySQL database server where your database is stored. On this you can select different parameters about the databases of the mySQL server.
By clicking on "Export" to get to the export page of the mySQL server where your database is stored. On this you can export databases in the mySQL server.
In addition, mark the field in the database (e.g. db111111_11). Then select the desired export file format.
You can still select the different options below, which you can download the database file if you want to be compressed, and with a click on "Go" to start the export. To download the file in the selected format, you must activate the check box "Save as file". You select the compression under it. If you have "Save as file" not activate, the file in the text format shown directly
in the database web front-end.
By clicking on "Import" to get to the import page of the mySQL server where your database is stored. On this you can import databases in 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".
By clicking on "SQL" to get to the command page of the mySQL database. On this you can incorporate the SQL command in the database. You can store each entry in the field with a click on "Ok".
By clicking on "Show MySQL runtime information" to get to the status page of the mySQL server where your database is stored. On this you can select different parameters such as traffic, links, etc. of the mySQL server.
By clicking on "Show MySQL system variables" to get to 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.
By clicking on "Processes" to get to 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.
By clicking on "Character Sets and Collations" to get to 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.
By clicking on "Storage Engines" to get to 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.
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.
On it you go to the structure page of the selected database. This is basically a summary page of the contents of that database. With "Create new table on database" you can now add new content to this database.
By clicking on "Search" to get to 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".
By clicking on "Query" to get to 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".
By clicking on "Export" to get to 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".
By clicking on "Import" to get to the import page of the mySQL database. On this you can import the database.
