Mysql如何实现从Windows转移到Linux

发布时间：2023-08-21 14:51:33 所属栏目：MySql教程来源：

导读：本文主要给大家介绍Mysql如何实现从Windows迁移到Linux，其所涉及的东西，从理论知识来获悉，有很多书籍、文献可供大家参考，从现实意义角度出发，亿速云累计多年的实践经验可分享给大家。

最近有个项目从Window

本文主要给大家介绍Mysql如何实现从Windows迁移到Linux，其所涉及的东西，从理论知识来获悉，有很多书籍、文献可供大家参考，从现实意义角度出发，亿速云累计多年的实践经验可分享给大家。

最近有个项目从Windows上迁移到Linux上，数据库在迁移成功，但是项目无法启动

[BPM] 2018-09-23 17:04:52 ERROR [localhost-startStop-1] ContextLoader.initWebApplicationContext(307) | Context initialization failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sysUserSyncService': Injection of resource dependencies failed; nested e

xception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sysUserService': Injection of resource dependencies failed;

nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'bpmNodeUserService': Injection of resource dependenc

ies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'bpmNodeUserCalculationSelector' defined

in class path resource [conf/app-beans.xml]: Cannot resolve reference to bean 'sameNodeCalculationDepartment' while setting bean property 'bpmNodeUserCalculatio

n' with key [TypedStringValue: value [sameNodeDepartment], target type [null]]; nested exception is org.springframework.beans.factory.BeanCreationException: Err

or creating bean with name 'sameNodeCalculationDepartment': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.Bea

nCreationException: Error creating bean with name 'taskOpinionService': Injection of resource dependencies failed; nested exception is org.springframework.beans

.factory.BeanCreationException: Error creating bean with name 'bpmService': Injection of resource dependencies failed; nested exception is org.springframework.b

eans.factory.BeanCreationException: Error creating bean with name 'proce***unService': Injection of resource dependencies failed; nested exception is org.spring

framework.beans.factory.BeanCreationException: Error creating bean with name 'taskSignDataService': Injection of resource dependencies failed; nested exception

is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; neste

d exception is org.activiti.engine.ActivitiException: no activiti tables in db. set <property name="databaseSchemaUpdate" to value="true" or value="create-drop"

(use create-drop for testing only!) in bean processEngineConfiguration in activiti.cfg.xml for automatic schema creation

        at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:307)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)

        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)

        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)

        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)

        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)

        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:609)

        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)

        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:469)

        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383)

Mysql如何实现从Windows迁移到Linux

.....省略.....

但是该Linux上的项目连接Windows上的数据库，并没有这个错误，所以确定问题所在是Linux的数据库有问题，经过几番研究，发现问题所在！

Mysql在Windows下默认对大小写不敏感，但在Linux下默认区分大小写的！！

所以在配置文件上添加lower_case_table_names=1，重启Mysql，再重启项目，成功！

（编辑：聊城站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!