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:

--
-- 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...

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

The following is from the phpmyadmin documentation:

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';
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.