|
When I want to upload the SQL sample file, its getting interupted.
My installation is all done directly to the server.
I created my database using plesk.
Then opened Pphmyadmin.
I see there is a maximum upload limit. So its not uploading the files correctly.
I dunno if it shud work, but when I try to upload it within a compressed zip file, I’m getting these errors:
SQL-query:
CREATE TABLE `tag` ( `tag_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Tag Id', `name` varchar(255) DEFAULT NULL COMMENT 'Name', `status` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Status', `first_customer_id` int(10) unsigned DEFAULT NULL COMMENT 'First Customer Id', `first_store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'First Store Id', PRIMARY KEY (`tag_id`) USING BTREE, KEY `FK_TAG_FIRST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` (`first_customer_id`), KEY `FK_TAG_FIRST_STORE_ID_CORE_STORE_STORE_ID` (`first_store_id`), CONSTRAINT `FK_TAG_FIRST_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`first_store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE NO ACTION, CONSTRAINT `FK_TAG_FIRST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`first_customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE NO ACTION ) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='[...]
MySQL retourneerde: Documentatie
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE,
KEY `FK_TAG_FIRST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` (`first' at line 7
I also tried a different method, using a PHP uploader into MySQL.
There I’m also getting errors.
https://dl.dropbox.com/u/30478272/error.png
Is there something what I’m doing wrong?
Is there an alternative?
HELP!
|
