MySQL

MySQL backup converting all data to lowercase

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2008

Posts: 1

Reputation: Rushyo is an unknown quantity at this point

Solved Threads: 0

Rushyo

Offline

Newbie Poster

MySQL backup converting all data to lowercase

Dec 22nd, 2008

I took a backup of a database a while ago and I'm having trouble with running it on a new (Windows 2003) server through phpmyadmin 3.

Whenever I execute it the resulting tables, fields and data are all converted to lowercase!

If I use phpmyadmin to create them it works as intended, but there's 30 or so tables populated with tons of data.

I am running a close-to-stock install of MySQL 5.0.51a and a highly modified Apache 2.0.63 setup.

Any help will be greatly appreciated. Snippet below:

 Help with Code Tags 
 SQL Syntax (Toggle Plain Text) 
--
-- Table structure for table `Agendas`
--
 
CREATE TABLE IF NOT EXISTS `Agendas` (
  `AgendaID` INT(11) NOT NULL AUTO_INCREMENT,
  `Name` VARCHAR(255) NOT NULL DEFAULT '',
  PRIMARY KEY  (`AgendaID`)
) AUTO_INCREMENT=11 ;
 
--
-- Dumping data for table `Agendas`
--
 
INSERT INTO `Agendas` (`AgendaID`, `Name`) VALUES
(1, 'Isolationist'),
(2, 'Nationalist'),
(3, 'Liberal'),
(4, 'Conservative'),
(5, 'Moderate'),
(6, 'Socialist'),
(7, 'Fascist'),
(8, 'Tribal'),
(9, 'Mercantile'),
(10, 'Theocratic');
 
-- etc, etc...
--
-- Table structure for table `Agendas`
--

CREATE TABLE IF NOT EXISTS `Agendas` (
  `AgendaID` int(11) NOT NULL auto_increment,
  `Name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`AgendaID`)
) AUTO_INCREMENT=11 ;

--
-- Dumping data for table `Agendas`
--

INSERT INTO `Agendas` (`AgendaID`, `Name`) VALUES
(1, 'Isolationist'),
(2, 'Nationalist'),
(3, 'Liberal'),
(4, 'Conservative'),
(5, 'Moderate'),
(6, 'Socialist'),
(7, 'Fascist'),
(8, 'Tribal'),
(9, 'Mercantile'),
(10, 'Theocratic');

-- etc, etc...

•

Join Date: Jul 2006

Posts: 883

Reputation: pritaeas will become famous soon enough

Solved Threads: 142

pritaeas

Offline

Practically a Posting Shark

Re: MySQL backup converting all data to lowercase

Dec 30th, 2008

How are you importing the backup ? Are you using phpmyadmin for this or mysql (command-line) ?

The following is from the phpmyadmin documentation:

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
1.23 I'm running MySQL on a Win32 machine. Each time I create a new table the table and field names are changed to lowercase!
 
This happens because the MySQL directive lower_case_table_names defaults to 1 (ON) in the Win32 version of MySQL. You can change this behavior by simply changing the directive to 0 (OFF):
Just edit your my.ini file that should be located in your Windows directory and add the following line to the group [mysqld]:
set-variable = lower_case_table_names=0Next, save the file and restart the MySQL service. You can always check the value of this directive using the query
SHOW VARIABLES LIKE 'lower_case_table_names';
 
1.23 I'm running MySQL on a Win32 machine. Each time I create a new table the table and field names are changed to lowercase!

This happens because the MySQL directive lower_case_table_names defaults to 1 (ON) in the Win32 version of MySQL. You can change this behavior by simply changing the directive to 0 (OFF):
Just edit your my.ini file that should be located in your Windows directory and add the following line to the group [mysqld]:
set-variable = lower_case_table_names=0Next, save the file and restart the MySQL service. You can always check the value of this directive using the query
SHOW VARIABLES LIKE 'lower_case_table_names';