MySQL Forums
Forum List  »  Other Migration

Migration :DB windows to linux case sensitive Issue
Posted by: arun MG
Date: October 29, 2014 06:37AM

Hi ALL

I am a new to mysql database.i have googled and managed to get some basic information to migrate DB from windows to linux

My current DB is working on windows and I planned to change it to linux(CentOS)

I have done these all steps.


1. mysqldump --routines --user=root --password=**** -h 127.0.0.1 dbname > f:\dbnamebac.sql (on Windows machine)

// (DB restoring on linux machine)

step 2 onwards done on linux machine

Before restoring make change in my.cnf -- lower_case_table_names=1

2. create database dbmane;

3. grant all privileges on dbname.* to root@localhost identified by 'mypassword';

4. grant all privileges on dbname.* to root@'%' identified by 'mypassword';

Also tried lower_case_table_names=2 but againg getting error that seems to case sensitive issue. Table_User*** does not exists is the error.

Please help with this issue.Is there any thing need to done beyond this.

Options: ReplyQuote


Subject
Views
Written By
Posted
Migration :DB windows to linux case sensitive Issue
4220
October 29, 2014 06:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.