Call-back icon  Sales: Call 877.832.5289 (N America)|310.295.4144 (International)

Magento

eCommerce Software for Online Growth

Magento Forum

   
Page 2 of 2
How to install sample data 1.0
 
Panxpress
Jr. Member
 
Total Posts:  6
Joined:  2008-04-03
 

@Crucial

You instructions worked great. Sorry for the late reply smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
jcollier
Jr. Member
 
Total Posts:  2
Joined:  2008-03-28
 

So, this is what worked for me.  (local host - apache on WinXP)

Download Sample Files for v1.0
http://www.magentocommerce.com/downloads/assets/1.0/magento-sample-data-1.0.zip

Copy Installation files to root dir.
Copy media folder from Sample Files to root dir.

Execute Sample File .sql script first.  Then, navigate to and run installation through browser.

It works, but you can’t use table prefixes for your database.

 
Magento Community Magento Community
Magento Community
Magento Community
 
glaDiator
Member
 
Total Posts:  56
Joined:  2008-03-17
 

Here is the steps to install magento with the sample data ....

1) download sample data & extract it.
2) Extract magento.
3) create a db for magento.
4) Execute the SQL file that is given within the sample data.
5) Replace the media folder by the media folder that is given within the sample data.
5) Now point your browser to your magento directory & it will take u through some steps to complete the installation.

Note : If u r installing it locally than always try to use 127.0.0.1 instead of localhost

 Signature 

GlaDiator
cracking my head in the wrold of open source

 
Magento Community Magento Community
Magento Community
Magento Community
 
casterdon
Jr. Member
 
Total Posts:  22
Joined:  2007-10-16
 

GlaDiator, that worked perfectly, Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Ralph68
Jr. Member
 
Total Posts:  2
Joined:  2008-04-30
 

I’m getting the attached error message after apply sample-data.sql.

magento & sample data v1.0.19700.
1&1;Linux Home Package

1) download sample data & extract it.
2) Extract magento.
3) create a new db for magento.
4) Execute the SQL file that is given within the sample data.
5) Getting attached error message.

Image Attachments
SampleDataError.jpg
 
Magento Community Magento Community
Magento Community
Magento Community
 
kandip
Jr. Member
 
Total Posts:  28
Joined:  2008-04-09
 

@Ralph

it seems like u extracted the sample sql into the database after u installed magento.  u need to extract the sample sql into the database before u install magento.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Ralph68
Jr. Member
 
Total Posts:  2
Joined:  2008-04-30
 

kandip, I extracted the sample-data.sql to a new, clean db before installing magento.

 
Magento Community Magento Community
Magento Community
Magento Community
 
magpieradio
Jr. Member
 
Total Posts:  30
Joined:  2008-04-27
 

I’ve followed eeach step very carefully and everything at the command line
went smoothly.

In the browser the page is now blank white;

index.php/admin/extensions_local/

 
Magento Community Magento Community
Magento Community
Magento Community
 
pauly
Jr. Member
 
Total Posts:  1
Joined:  2008-06-12
 
Crucial - 03 April 2008 07:20 PM

@Panxpress:

It used to be on the download page, but you can get it from here:

http://www.magentocommerce.com/downloads/assets/1.0/magento-sample-data-1.0.tar.gz

Or, just run the following in SSH. Copy and paste the entire thing, but make sure you replace DBUSER and DBNAME first. After the last command you’ll have to enter the password for the database user.

wget http://www.magentocommerce.com/downloads/assets/1.0/magento-1.0.tar.gz
wget http://www.magentocommerce.com/downloads/assets/1.0/magento-sample-data-1.0.tar.gz
tar -zxvf magento-1.0.tar.gz
tar -zxvf magento-sample-data-1.0.tar.gz
mv magento-sample-data-1.0/media/* magento/media/
mv magento-sample-data-1.0/magento_sample_data_for_1.0.sql magento/data.sql
cd magento
chmod o+w var var/.htaccess app/etc
chmod -R o+w media
mysql -u DBUSER -p DBNAME < data.sql


Then just run through the web-based install, shouldn’t take longer than 5 minutes total.

I found this method really helpful so have decided to post the following which I used successfully and has up to date data as of 13/06/08 as well as a small change in the last line for those of us using Dreamhost. Dreamhost wont allow connection to mysql databases without using your database hostname (mysql.domain.com or similar).

Good Luck!

wget http://www.magentocommerce.com/downloads/assets/1.0.19870/magento-1.0.19870.2.tar.gz
wget http://www.magentocommerce.com/downloads/assets/1.0.19870/magento-sample-data-1.0.19870.tar.gz
tar -zxvf magento-1.0.19870.2.tar.gz
tar -zxvf magento-sample-data-1.0.19870.tar.gz
mv magento-sample-data-1.0.19870/media/* magento/media/
mv magento-sample-data-1.0.19870/magento_sample_data_for_1.0.19870.sql magento/data.sql
cd magento
chmod o+w var var/.htaccess app/etc
chmod -R o+w media
mysql -h DBURL -u DBUSERNAME -p DBNAME < data.sql

 
Magento Community Magento Community
Magento Community
Magento Community
 
emmedi1962
Jr. Member
 
Total Posts:  8
Joined:  2008-09-22
 

I tried twice without success.

I use a Lunarpages hosting account that accomodates my empty version of Magento without any problem.

But when I tried to install the sample data version I run into problems.

1) First trial

Everything went fine but I got an error page when I accessed the frontend. The images seem to be there randomly. (category yes, some product yes, but not the principal ones).
However, backend didn’t work, I couldn’t click on the different tabs, basically I couldn’t do anything.

2) Second trial

Same situation, but I noticed I had the “media” folder with sample data in the wrong position (root instead of inside the Magento folder). I moved it and everything stopped working and I just got a Firefox error stating there is probably a cookie somewhere.

I am reinstalling for the 3rd time but I am worried I am missing something. I cannot use SSH so I have to use FTP and the CPANEL utilities.

Any clue?

 Signature 

Marco

“A Magento newbie already converted into an evangelist”

 
Magento Community Magento Community
Magento Community
Magento Community
 
emmedi1962
Jr. Member
 
Total Posts:  8
Joined:  2008-09-22
 

Third installation, same problem.

a) On the backend the top menu isn’t clickable

b) The frontend has the pictures, but gives me a error when accessing a page

I suspect the SQL data of the sample data is causing the mess, because I installed an empty Magento without problem.

What do you think?

 Signature 

Marco

“A Magento newbie already converted into an evangelist”

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
Page 2 of 2
 
Sales: Call 877.832.5289 (North America) 310.295.4144 (International)
© Copyright 2008 Varien. Magento, eCommerce software, is a trademark of Irubin Consulting Inc. DBA Varien
Privacy Policy|Terms of Service
Magento Community Count
52171 users|979 users currently online|105395 forum posts