mysql - Having problem with importing the magento database -


When I'm trying to import the magento database, do not make me " The table ".

Below is an error; 

  # 1005 - Can not create table 'db123712_paper.catalog_category_product'   
 Can anyone help me on this, I posted several forums Have tried the solutions.  
 Thanks in advance  
 
 
 Enter the following content at the top of your import script,  
  SET @OLD_CHARACTER_SET_CLIENT = @@ CHARACTER_SET_CLIENT; SET @OLD_CHARACTER_SET_RESULTS = @@ CHARACTER_SET_RESULTS; SET @OLD_COLLATION_CONNECTION = @@ COLLATION_CONNECTION; Set name utf8; SET @OLD_UNIQUE_CHECKS = @@ UNIQUE_CHECKS, UNIQUE_CHECKS = 0; SET @OLD_FOREIGN_KEY_CHECKS = @@ FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS = 0; SET @old_SQL_MODE = @@ SQL_MODE, SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO'; SET @old_SQL_NOTES = @@ SQL_NOTES, SQL_NOTES = 0;   
 The following is your script  
  SET SQL_MODE = @ OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS = @ OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS = @ OLD_UNIQUE_CHECKS; SET CHARACTER_SET_CLIENT = @ OLD_CHARACTER_SET_CLIENT; SET CHARACTER_SET_RESULTS = @ OLD_CHARACTER_SET_RESULTS; SET COLLATION_CONNECTION = @ OLD_COLLATION_CONNECTION; Set SQL_NOTES = @ OLD_SQL_NOTES;

Comments

Post a Comment