Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Sample database for magento_sample_data_for_0.7.15480.sql
 
tehgamecat
Jr. Member
 
Total Posts:  27
Joined:  2007-09-12
 

Seriously guys, sort it out. You have this great product but you are doing some really dumb things.

MAKE THINGS SIMPLE

If I have installed a site with this new hurrendous installer (again more of the same over complications) I then take a look at the sql for the sample pack and it overwrites everything....are you nuts? Why on earth would I want to overwrite everything. I want to add the catalogue and relevant settings (shock) not have some new admin login and a whole host of other garbage.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Moshe
Magento Team
 
Avatar
Total Posts:  1770
Joined:  2007-08-07
Los Angeles
 

1. Download compressed SQL and media files
2. Unpack the downloaded file.
3. Import SQL file into your database
4. Run installation wizard, using the database you’ve just unpacked SQL file into.

Please point where it is too complicated for you.

 
Magento Community Magento Community
Magento Community
Magento Community
 
tehgamecat
Jr. Member
 
Total Posts:  27
Joined:  2007-09-12
 
Moshe - 30 January 2008 09:47 AM

1. Download compressed SQL and media files
2. Unpack the downloaded file.
3. Import SQL file into your database
4. Run installation wizard, using the database you’ve just unpacked SQL file into.

Please point where it is too complicated for you.

You tell me whats too complicated for you, reading my post or putting together a sql file with just product data in it? You’ll spend more time reading my post and replying. So please make a sql file with jsut product data in it rather than forcing people to overwrite their installed database.

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Moshe
Magento Team
 
Avatar
Total Posts:  1770
Joined:  2007-08-07
Los Angeles
 

Sample data includes not just product data.

It includes:
1. EAV Entities
2. EAV Attributes
2. Categories
3. Products
4. Association of products with categories
5. Association of products and superproducts
6. Website and store configuration to accomodate store_id values in data.

The sample data is provided as a complete setup to ensure data integrity between components.

So, “putting together a sql file with just product data in it” will not benefit you much.

 
Magento Community Magento Community
Magento Community
Magento Community
 
tehgamecat
Jr. Member
 
Total Posts:  27
Joined:  2007-09-12
 

So to import products and store information to display them means you have to drop every table?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Moshe
Magento Team
 
Avatar
Total Posts:  1770
Joined:  2007-08-07
Los Angeles
 

To make it simple, yes.

Sample product data package is made for people that just starting their experience with Magento and wish to play around with pre-populated data.

When we will have a facility to import into existing database structure ALL the mentioned components, sample data package will be made as an Extension.

 
Magento Community Magento Community
Magento Community
Magento Community
 
tehgamecat
Jr. Member
 
Total Posts:  27
Joined:  2007-09-12
 

I am quite lost. It seems there is no clear line between site building, design, admin and products. I cannot believe this to be the case as my experience has been quite the contrary. I think this is just laziness.

 
Magento Community Magento Community
Magento Community
Magento Community
 
joolsr
Sr. Member
 
Total Posts:  99
Joined:  2008-01-16
 

I’m having lots of problems trying to get the SQLfor the sample data in. I get an error saying that the max time has been reached 300 seconds (to run the sql script), but if I try to chop up the SQL into smaller chunks I sometimes get errors probably because of relationships inconsistencies. I’m using PHPMyadmin to do this.

What’s your advice on the easiest way to do this ? Using Ubuntu Linux 7.10, 1GB Ram.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Moshe
Magento Team
 
Avatar
Total Posts:  1770
Joined:  2007-08-07
Los Angeles
 

@joolsr: see here: http://www.magentocommerce.com/boards/viewthread/2921/#t11804

 
Magento Community Magento Community
Magento Community
Magento Community
 
tehgamecat
Jr. Member
 
Total Posts:  27
Joined:  2007-09-12
 

Thats almost a certainly a php max execution time problem, ask your host to increase this, or if you have access to the php.ini you can do this yourself.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Baybee
Member
 
Total Posts:  61
Joined:  2008-01-22
 

Ok… this is my 3rd try to import the sample data.  I’ve reinstalled 3 times now… For some reason, if I try to import the whole SQL file, it errors out, so I decided to do it “manually” bit by bit! 

Now… I am getting the following error:

MySQL said: Documentation
#1005 - Can’t create table ‘./my_database/catalog_category_entity.frm’

Getting that error after trying to run the following SQL query copied from the SQL sample data file:

--
-- Table structure for table `catalog_category_entity`
--

DROP TABLE IF EXISTS `catalog_category_entity`;
CREATE TABLE `catalog_category_entity` (
`entity_id` int(10) unsigned NOT NULL auto_increment,
`entity_type_id` smallint(8) unsigned NOT NULL default ‘0’,
`attribute_set_id` smallint(5) unsigned NOT NULL default ‘0’,
`parent_id` int(10) unsigned NOT NULL default ‘0’,
`store_id` smallint(5) unsigned NOT NULL default ‘0’,
`created_at` datetime NOT NULL default ‘0000-00-00 00:00:00’,
`updated_at` datetime NOT NULL default ‘0000-00-00 00:00:00’,
`is_active` tinyint(1) unsigned NOT NULL default ‘1’,
PRIMARY KEY (`entity_id`),
KEY `FK_catalog_category_ENTITY_ENTITY_TYPE` (`entity_type_id`),
KEY `FK_catalog_category_ENTITY_STORE` (`store_id`),
CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_TREE_NODE` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_tree` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Category Entityies’;

 
Magento Community Magento Community
Magento Community
Magento Community
 
mykel
Jr. Member
 
Avatar
Total Posts:  6
Joined:  2007-12-04
Pune
 

I had the same problem, installing the sql database on phpMyadmin (Timed out).

Downstanding my solution which was working on my xampp 1.6.5 installation:

Open the sql file in PSPad or any other webeditor. Remove the the table usa_postcode and save it into another file incl. head and footcodes.  This only table of the full database (2668 KB) takes around 1,5 MB of the original sql file. The file which is left got reduced to only a size of around 1,2 MB, which was uploading without any problems.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Baybee
Member
 
Total Posts:  61
Joined:  2008-01-22
 

Thank you very much!  Worked like a champ!  Appreciate your help there!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top