Forums

Help!!! MySQL error on install – what does this mean?

Permalink
Hello, I really hope someone can help. I'm trying to move a site from my HD to the hosted server and when adding the sql database through phpmyadmin I get the below error. I'm totally stumped and have NO idea what it means. Help!

Error
SQL query:

--
-- Database: `callan`
--
-- --------------------------------------------------------
--
-- Table structure for table `AreaGroupBlockTypes`
--
CREATE TABLE `AreaGroupBlockTypes` (

`cID` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
`arHandle` VARCHAR( 255 ) NOT NULL ,
`gID` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
`uID` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
`btID` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY ( `cID` , `arHandle` , `gID` , `uID` , `btID` )
) ENGINE = INNODB DEFAULT CHARSET = utf8;

MySQL said:

#1050 - Table 'AreaGroupBlockTypes' already exists
 
mesuva replied on at Permalink Best Answer Reply
mesuva
I believe you can take that error message literally - the script is trying to create a new table in the database, but that table already exists.

Do you already have an existing database you are trying to update? If so, you'll need to 'drop' (delete) the tables and try your script again.

Alternatively, when you generate your dump file from your source database, you should have the option to include drop statements. These extra statements take care of deleting any tables that already exist.

Not to panic you, but are you sure you are running this script against the right database? This error shouldn't occur if you have a brand new (blank) database you are importing data into.
DanK replied on at Permalink Reply
Thanks mesuva, I set it to include the drop statements and it worked!

Thank you so much, I really hadn't a clue what to do next.