No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

OceanStor 9000 V5 7.0.0 SystemReporter Upgrade Guide

Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
Upgrading the Database

Upgrading the Database

This chapter describes how to upgrade MySQL database to GaussDB database. While the database is upgrading, the data in the original database are also replicated to new database.

Prerequisite

Before upgrading the database, ensure that the MySQL and GaussDB database services have been started.

Procedure

  1. Decompress the installation package of the new tool, Under tool decompression Directory\Runtime\bin, execute convertMysql2gaussdb.bat.
  2. Enter the user name, password, and port of MySQL and GaussDB when prompted to copy data from MySQL to GaussDB.

    Do not close the command window during data replication. Otherwise, the upgrade will experience an exception.

    The following shows an example:

    NOTE:

    After all data is copied from MySQL to GaussDB, MySQL will no longer be used. You

    can uninstall MySQL.

    If the execution fails, perform the following operations:

    • Check whether the user names, passwords, and port numbers of the two databases are correct.
    • Check whether the two database processes are in the running state. (Start the task manager to check whether the mysql and gaussdb processes exist.)
    • Check whether the decompressed folder name contains space characters. If a space character exists, the upgrade fails.
    • Check whether the decompression path is too long. It is recommended that you place the decompression path in the root directory.

  3. After the execution succeeds, "The convert progress is finished." is displayed in the dialog box, as shown in the following figure:

Follow-up Procedure

  • After the GaussDB database is upgraded, the MySQL database cannot be used any longer. You can uninstall it.If you want to uninstall it, perform the following steps.Otherwise, skip the following section.
  • To uninstall a MySQL database completely:
    1. In the system where the SystemReporter is installed, choose Control Panel > Programs > Programs and Features > MySQL server > Uninstall.
    2. Delete the installation path of MySQL.
    3. Run regedit.exe to open the registry, as shown in the following figure:
    4. Delete the HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL folder.
    5. Delete the HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL folder (if no such folder exists, you do not need to delete it).
    6. Delete all files under C:\ProgramData\MySQL in Disk C. You can view programData files only after you set them to be displayed for they are hidden by default.

    7. Delete environment variables. Windows Server 2008 is used as an example, right-click My Computer and choose Properties from the shortcut menu. In the dialog box that is displayed, click Advanced System Settings and select the Advanced tab. Click Environment Variables. Double-click Path under System variables and delete MySQL installation directory\bin, as shown in the following figure.

    8. Restart the computer to completely uninstall the MySQL database

Translation
Download
Updated: 2019-02-26

Document ID: EDOC1100067899

Views: 1275

Downloads: 0

Average rating:
This Document Applies to these Products
Related Documents
Related Version
Share
Previous Next