database issue

Permalink July 12, 2011 at 6:23 AM

I am trying to move my database from its local location to its new server. It keeps giving me this error. Does anyone can help. I am just a designer...
thank a lot

"Error
SQL query:
-- -- Base de données: `pergame` -- -- -------------------------------------------------------- -- -- Structure de la 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:
#1005 - Can't create table 'pergame.AreaGroupBlockTypes' (errno: -1) (<a href="server_engines.php?engine=InnoDB&page=Status&token=1a58da88c67aa9916e6a9f13c9c7b1df">Details...</a>)"

smenegassi replied on Jul 12, 2011 at 12:23 pm Permalink Reply

Well. I erased the database on the server and create a new one with a different name. I went for a walk, bought some chocolates and came back to my computer. I cleaned for the X time the cache of the site, and uploaded the database again. It worked !
I don't understand why, what is always not so good. But anyway it is better than staying stocked with a problem. Now I can go forwards the next problem. This is my first site with Concrete5.
thanks a lot