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

Magento

eCommerce Software for Online Growth

Magento Forum

   
The definitive ‘How do I import sample data’ thread? (Magento 1.0)
 
Creative Arc
Jr. Member
 
Total Posts:  9
Joined:  2008-01-22
 

So far, I haven’t found definitive instructions for installing the sample data.

What is the sequence?

* Create db
* Run sql script for sample data
* Run installer?

I’ve seen threads for older versions of magento that suggested running the installer after the sample data is loaded, but I had problems with the installer not ‘kicking in’

If there is a FAQ/Wiki for this, please point me in the right direction.

 Signature 

Creative Arc
Minneapolis Web Design

 
Magento Community Magento Community
Magento Community
Magento Community
 
Crucial
Guru
 
Avatar
Total Posts:  543
Joined:  2007-11-07
Phoenix, AZ
 

Well you can do it either way, the problem is, if you run the SQL import after it’s installed, it resets some information (like admin username and password). So the way you listed it is how I’ve been doing it:

1. Create database.
2. Import SQL sample data.
3. Run installer.

 Signature 

Crucial Web Hosting
Magento hosting in shared, semi-dedicated, and dedicated configurations. Demo store.
Dedicated Containers come with Varien’s professional support services for Magento.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Creative Arc
Jr. Member
 
Total Posts:  9
Joined:  2008-01-22
 
Crucial - 01 April 2008 05:04 PM

Well you can do it either way, the problem is, if you run the SQL import after it’s installed, it resets some information (like admin username and password). So the way you listed it is how I’ve been doing it:

1. Create database.
2. Import SQL sample data.
3. Run installer.

That’s what I’ve been doing. However, I can’t invoke the installer. It simply redirects to the Document Root (/)

Is there a particular URL that is needed for the installer? /index.php/install/wizard or something similar?

 Signature 

Creative Arc
Minneapolis Web Design

 
Magento Community Magento Community
Magento Community
Magento Community
 
gooBall
Jr. Member
 
Avatar
Total Posts:  2
Joined:  2008-04-02
 
Creative Arc - 01 April 2008 07:00 PM

Crucial - 01 April 2008 05:04 PM
Well you can do it either way, the problem is, if you run the SQL import after it’s installed, it resets some information (like admin username and password). So the way you listed it is how I’ve been doing it:

1. Create database.
2. Import SQL sample data.
3. Run installer.

That’s what I’ve been doing. However, I can’t invoke the installer. It simply redirects to the Document Root (/)

Is there a particular URL that is needed for the installer? /index.php/install/wizard or something similar?

I had a similar problem, so I just deleted all the files then:

1. Extracted the sample data archive
2. Copied the contents to my web server magento directory
3. Extracted the main magento directories and files
4. Copied all into the magento directory.
5. Fired up phpmyadmin and dropped the magento DB
6. Created a new magento db and imported the sample data sql file into it
7. Ran the magento installer
8. Shiny new magento store is up and running…

Hope this helps…

 
Magento Community Magento Community
Magento Community
Magento Community
 
Creative Arc
Jr. Member
 
Total Posts:  9
Joined:  2008-01-22
 
gooBall - 02 April 2008 04:47 AM

I had a similar problem, so I just deleted all the files then:

1. Extracted the sample data archive
2. Copied the contents to my web server magento directory
3. Extracted the main magento directories and files
4. Copied all into the magento directory.
5. Fired up phpmyadmin and dropped the magento DB
6. Created a new magento db and imported the sample data sql file into it
7. Ran the magento installer
8. Shiny new magento store is up and running…

Hope this helps…

Can’t hurt to try. Seems to be a very roundabout way of installing sample data, but I can live with it.

 Signature 

Creative Arc
Minneapolis Web Design

 
Magento Community Magento Community
Magento Community
Magento Community
 
Crucial
Guru
 
Avatar
Total Posts:  543
Joined:  2007-11-07
Phoenix, AZ
 

It’s a little easier to do in SSH too. You can copy the entire list of commands and just paste it in. The last command, which imports the SQL dump, will ask for the password fo the database user. Make sure you replace DBUSER and DBNAME before pasting.

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 open up your browser and run through the install.

Edit: Had to take code view off, it cut off halfway through.

 Signature 

Crucial Web Hosting
Magento hosting in shared, semi-dedicated, and dedicated configurations. Demo store.
Dedicated Containers come with Varien’s professional support services for Magento.

 
Magento Community Magento Community
Magento Community
Magento Community
 
roshangmail
Jr. Member
 
Avatar
Total Posts:  28
Joined:  2008-05-18
 

5 easy steps to import the sample data in already installed magento :
1
rename the location {root}/media
eg _media

2
upload the sample data file called media
{root}/media

eg {root}/media after upload

3 then create a new database as sample_database_magento
import sample sql.txt file on this database(sample_database_magento)

4.go to location {root}\app\etc\local.xml

Rename local.xml as ___local.xml or anything u want.

5.then browse the url http://www.yourdomain.com
it will go for the installer
and install magento but rember when u give the database name give sample_database_magento

and you are done:p

this is done and tested with version Magento ver. 1.0.19870 :d:p
please dont thank me if you feel like thanking me then post some new post which is meaningful and a good help to programers;)

 Signature 

Want to be a good programer But eva succed!!! :s

 
Magento Community Magento Community
Magento Community
Magento Community
 
SimpleHelix.com
Guru
 
Avatar
Total Posts:  426
Joined:  2007-08-31
Los Angeles, CA
 

Or if any of you are looking for an added convenience, we have implemented a sample data loader directly on our Magento 1-click Installer.

Anyone wanting the easiest and the fastest way to setup magento, give us a try.

 Signature 

SimpleHELIX.com, LLC
A World-Class Magento Web Hosting company - Providing scalable, reliable, and secure enterprise hosting solutions
The creators of super-fast performance hosting. Find out more @ http://www.simpleHELIX.com

 
Magento Community Magento Community
Magento Community
Magento Community
 
TolputtKeeton
Jr. Member
 
Total Posts:  19
Joined:  2008-09-28
 

Hi Guys,

I had all the sample data loaded and my store was working fine....UNTILL i decided to delete the products and now i have an error on the page ‘null’ is null or not an object also if i add a product it always sets it at out of stock which is wrong

my site is here

So i really dont want to mess it up or brake it anymore

Is there a way to reimport all the sample data so that my store stays the same but it puts all the sample products back in??

Please help me ive been submitting posts for 2 days now and no one seems to reply.

heres an image of the error

Image Attachments
errors.gif
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
 
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
53175 users|804 users currently online|107198 forum posts