MySQL 5 and MySQL 8.6 migration

I don't want to reinstall software such as MySQL5 and MyEclipse8.6, So I copied the installation directory directly to the new computer. In order to run it, I made the following operations. Environment: Win7 prerequisites: Java environment configuration I. MySQL5 www.2cto.com 1. Copy the entire MySQL directory (including data files, for example, if the directory is % MYSQL_PATH % 2, modify the MySQL configuration file to edit my. ini configuration file (% MYSQL_PATH % directory), modify the values of the following parameters accordingly. Basedir: MySQL installation directory, that is, % MYSQL_PATH % datadir: Database folder. Each database has a corresponding innodb_data_home_dir: data folder, which contains files such as ibdata1, stores all data.
2. Create a MySQL service. Double-click bin \ mysqld.exe to run mysql. However, to create a service, you can find two methods on the Internet: Method 1: as an administrator, enter the % MYSQL_PATH % \ bin directory through the command line, and run the following command mysqld -- install MySQL to write mysqld -- install MySQL -- defaults-file = "% MYSQL_PATH % \ my. ini "but I didn't create it successfully. method 2 can be used as the administrator, run the following command SC create MySQL binpath = "% MYSQL_PATH % \ bin \ mysqld.exe" type = share start = auto displayname = "MySQL" depend = TCPIP www.2cto.com II. MyEclipse8.61. copy the entire directory. 2. modify the configuration file. If the copied directory is different from the directory on the old computer, modify the configuration file, change the directory configuration in all the configuration files related to the folder path in the MyEclipse directory to the corresponding value. I need to change the following configuration files: myeclipse. iniconfiguration \ config. iniconfiguration \. settings \ org. eclipse. ui. ide. prefs (this changes the workspace directory) configuration \ org. eclipse. equinox. simpleconfigurator \ bundles. infoconfiguration \ org. eclipse. equinox. source \ source.info by Jiang kunpeng