Re: MySQL corrupting database everytime it starts

[Nekrose DeCuir]

I can't replace the database.. it gives this error when trying to replace a simple DB for a Minecraft authentication server using ComputerCraft.

SQL query:




--
-- Database: `Minecraft`
--

-- --------------------------------------------------------

--
-- Table structure for table `Users`
--

CREATE TABLE IF NOT EXISTS `Users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(40) NOT NULL,
  `password` varchar(512) NOT NULL,
  `accesslevel` int(11) NOT NULL,
  `DateCreated` datetime NOT NULL,
  `LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
MySQL said: Documentation

#1813 - Tablespace for table '`minecraft`.`users`' exists. Please DISCARD the tablespace before IMPORT.

also, the ONLY configuration i did to the server at all, was add "lower_case_table_names = 2" to turn off lowercase table names. i also did this on the production server and it works perfectly. its the default XAMPP config with just that one line in the MySQL config. i also, ran the security script to put a password on the database.. but all that did is put a password on the root and pma users.. i'm pretty sure that was all it did to the database.