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