Aus EUserv Wiki

Version vom 17:47, 6. Nov. 2015 (Quelltext anzeigen) Svtr1 (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „{{Languages|Guide_mySQL-Datenbank-Transfer}} Kategorie:Server '''''MySQL database transfer''''' __TOC__ <div style= "font-size: 1.571em;"> '''MySQL database t…“) ← Zum vorherigen Versionsunterschied		Version vom 17:49, 6. Nov. 2015 (Quelltext anzeigen) Root (Diskussion | Beiträge) Zum nächsten Versionsunterschied →
Zeile 6:		Zeile 6:
	'''MySQL database transfer'''		'''MySQL database transfer'''
	</div>		</div>
		+
	=General=		=General=

---

Version vom 17:49, 6. Nov. 2015

MySQL database transfer

Inhaltsverzeichnis 1 General 2 Preparation 3 Implementation 3.1 Exporting the data of the old database 3.2 Importing the data to the new database

General

The following wiki guide describes the process of transferring your mySQL database to a mySQL Pro database.

Preparation

In order to transfer your existing database to a mySQL Pro database, you will need your user credentials. Please proceed as follows:

• Log in to the customer panel at https://support.euserv.de with your username and password.
• Choose the corresponding contract.

• Click on "mySQL" under "Database".

• You will need your user data from the respective database (This includes database name/ server name, admin user and admin password).

Implementation

To perform a transfer of your database, the following steps are required:

• Exporting the data of you old database
• Importing your data to the new database

Exporting the data of the old database

• Log in to the database webfrontend at https://support.euserv.de/dbadmin with your user data.
• Under "Server:" select the corresponding database server.
• Enter your admin user and admin password when prompted

• Select the corresponding database and click on "Export".

• Click on "Send" and "OK" to create the SQL file.

Please note: You have to export your raw data only and not the SQL commands for creating the database.

Importing the data to the new database

• Choose the corresponding contract.

• Click on "mySQL" under "Database".

• You will need your relevant database credentials (This includes database name/ server name, admin user and admin password).

• Log in to the database webfrontend at https://support.euserv.de/dbadmin with your user credentials.

• Choose the corresponding database and click "Import".

• Choose the corresponding SQL file which you have exported earlier by clicking on "Select file".
• Finally click on "OK".

You have now successfully imported your data to the new database.

Finally, you'll have to adjust the database connection parameters in your software. This includes the database name, the database user and the database password.