MySQL Forums
Forum List  »  Other Migration

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

arun MG Wrote:
> 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 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.

Sorry for the missed 5th step

5. mysql --user=root --password=mypass -h dbname < D:\dbname.sql

Options: ReplyQuote

Written By
Re: Migration :DB windows to linux case sensitive Issue
October 29, 2014 06:47AM

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.