Error in installing sample data 1.9.sql

[hadiDeveloper]

Hi

I use magento CE 1.9 on xampp 3.2.1 server, my OS is windows 7 64 bit

I want to import magento_sample_data_for_1.9.1.0.sql.zip to mysql, after 3 or 4 minutes the error appears

Error

SQL query:

CREATE TABLE `core_session` (
  `session_id` varchar(255) NOT NULL COMMENT 'Session Id',
  `session_expires` int(10) unsigned NOT NULL DEFAULT '0

MySQL said:

#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 ''0' at line 3

what should I do?

[devsite]

Does this line of code right?

`session_expires` int(10) unsigned NOT NULL DEFAULT '0

[hadiDeveloper]

Hi

Yes the code is right

[sherrie]

Just to clarify, your code isn't cutting off at '0 is it?

The full block where that is should look like this:

DROP TABLE IF EXISTS `core_session`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_session` (
  `session_id` varchar(255) NOT NULL COMMENT 'Session Id',
  `session_expires` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Date of Session Expiration',
  `session_data` mediumblob NOT NULL COMMENT 'Session Data',
  PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Database Sessions Storage';
/*!40101 SET character_set_client = @saved_cs_client */;

Also, did you have a fresh database when you installed the sample data? It needs to be imported before installing Magento.

[hadiDeveloper · Accepted solution]

Hi

tnx, the error was about partial import in phpmyadmin, when I uncheck this option and increase php timeout the script imported after 10 minutes successfuly

[sherrie]

Glad to hear it, thanks for reporting back @hadiDeveloper!