Migration :DB windows to linux case sensitive Issue

[arun MG]

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.