LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 06-04-2006, 11:19 PM   #1
Niceman2005
Member
 
Registered: Nov 2004
Distribution: Fedora Core 2
Posts: 330

Rep: Reputation: 30
lowercase windows mysql tables became uppercase import to linux


Dear friends,

When I dump a mysql database from windows machine and then import the database in a Linux machine the letters for the tables became UPPERCASE in the linux machine. (the source was a windoes machine and the tables were lowercase..)

So the problem now is howcome the tables name turned from lowercase into uppercase after imported into linux machine...
any specific configuration i had done incorrectly?

Thanks for taking time helping...

Regards
Y
 
Old 06-05-2006, 09:24 PM   #2
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 7.7 (?), Centos 8.1
Posts: 17,818

Rep: Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558
Check the dump file at each stage of the creation/txfr. Note that MSWin does not distinguish case, whereas Linux (Unix) does.
 
Old 06-06-2006, 03:18 AM   #3
Niceman2005
Member
 
Registered: Nov 2004
Distribution: Fedora Core 2
Posts: 330

Original Poster
Rep: Reputation: 30
thanks chrism!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
UPPERCASE to lowercase command? pk21 Linux - General 4 06-12-2007 11:26 AM
Uppercase filenames showing in lowercase rvoigt Linux - General 1 02-21-2006 12:07 AM
Converting Uppercase to Lowercase AMMullan Linux - Software 6 10-18-2005 08:32 PM
samba replaces Uppercase char in filenames to lowercase srikz Red Hat 1 10-26-2004 04:47 AM
Converting lowercase to uppercase noodle123 Programming 1 05-17-2002 03:12 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:36 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration