Jira迁库-由Hsql迁到Mysql

目录

一、Jira版本与Mysql版本匹配问题

二、Mysql版本与mysql驱动版本匹配问题

三、以Jira6.4.11为例，介绍Jira迁库到Mysql5.6.44

0.安装VC++2010

1.安装Mysql

2.下载mysql驱动

3.备份jira系统的数据为xml格式

4.停掉Jira服务，修改数据库配置

5.恢复数据

6.验证

---

一、Jira版本与Mysql版本匹配问题

官网地址：https://confluence.atlassian.com/jira064/supported-platforms-720411857.html

Supported platforms for JIRA 6.4

	Supported platform(s)	Supported version(s)	Notes
Java platforms	Oracle JDK / JRE (formerly Sun JDK / JRE)	Java 7 Java 8	Java 8 offers significant advantages over Java 7. If you have a medium- to large-sized instance, we recommend using Java 8. Please see Java 8 improves JIRA application performance dramaticallyfor further info. There is a known issue with Java 1.8.0_25 and 1.8.0_31. We don't recommend running JIRA on these versions.
Operating systems	Microsoft Windows		JIRA is a pure Java-based application and should run on any supported operating system, provided that the JDK / JRE requirements are satisfied. Please see here for information on Anti-Virus in JIRA applications
	Linux / Solaris		JIRA is a pure Java-based application and should run on any supported operating system, provided that the JDK / JRE requirements are satisfied. Atlassian only officially supports JIRA running on x86 hardware and 64-bit derivatives of x86 hardware. If you are installing JIRA from an archive, you should create a dedicated user accounton the operating system to run JIRA, since JIRA runs as the user it is invoked under and therefore can potentially be abused. Although the JIRA Linux Installer is designed to install successfully on all 'flavours' of Linux, we only test the JIRA Linux Installer on CentOS Linux. If you encounter problems with the JIRA Linux Installer on your particular flavour of Linux, we recommend installing JIRA on Linux from an archive file. Network storage locations are not supported due to Lucene requirements (such as NFS mounts). Please see the IndexWriter docs for further info.
Virtualisation	VMware		Please read our Virtualizing JIRA (JIRA on VMware) guide for information on the required configuration of VMWare. We are unable to provide any supportfor VMWare itself. All of the operating systems listed in the 'Operating systems' rows above are supported for VMware.
Application servers