Magentoでショッピングカートを作っても、中に何も入っていないと寂しいですよね。
なので初期データとしてサンプルデータを取り込みましょう。
なので初期データとしてサンプルデータを取り込みましょう。
先ほどと同様ダウンロードページから入手できます。
http://www.magentocommerce.com/download
MySQLの設定
MySQLにデータベースを作成し、必要なデータを入れていきます。
本サイトではSSHでサーバにログインすることを前提に手順を書いていきます。
ご利用のホスティング会社によって、SSHでのログインを許容していないところがあると思いますので、その場合はphpmyadminが使えると思います。
phpmyadminの使い方はとても簡単です。これからご説明する作業も簡単なものですので、ぜひ内容を読み替えて設定を進めていただければと思います。
まずはデータベースを作成します。わかりやすく"Magento"という名前にします。
mysql> create database magento;
次にユーザーを作ります。
mysql> CREATE USER 'magento_user'@'localhost' IDENTIFIED BY 'magento_pass';
作ったユーザーにmagentoデータベースへの全権を与えます。
mysql> GRANT ALL PRIVILEGES ON *.magento TO 'magento_user'@'localhost' WITH GRANT OPTION;
サンプルデータをインポート
次に、先にダウンロードしておいたサンプルデータを入れます。
※Magento本体のインストール作業を始める前にサンプルデータのインポートをする必要があるので、この作業を後回しにしないようにしてください！
ダウンロードしたファイル内にある下記のファイルが対象となります。
サーバへのアップロードはFTPツールを使ってください。ちなみに私はFilezillaを使っています。無料です。
下記がMysqlへのインポートコマンドです。
mysql -umagento_user -p magento < magento_sample_data_for_1.6.1.0.sql
下記コマンドでMagentoデータベースにテーブルが作成されていることを確認しましょう。
mysql> use magento;
mysql> show tables;
mysql> show tables;
order atorvastatin 10mg pills order lipitor 10mg online cheap lipitor 10mg generic
order ciprofloxacin 500mg online - order amoxiclav sale where can i buy augmentin
order cipro 500mg without prescription - order cephalexin 500mg online purchase amoxiclav
flagyl oral - generic amoxil azithromycin 250mg canada
buy ciprofloxacin generic - buy doxycycline generic erythromycin oral
order valacyclovir 1000mg without prescription - diltiazem cost purchase zovirax generic
stromectol cost in usa - buy ciplox 500mg pills purchase tetracycline for sale
buy flagyl 400mg for sale - buy amoxicillin no prescription buy cheap generic zithromax
ampicillin order doxycycline oral amoxicillin pills
furosemide 40mg ca - cheap capoten 120mg buy captopril sale
glycomet online - generic lincocin purchase lincomycin for sale
buy clozaril cheap - buy altace 5mg generic order pepcid online cheap
buy quetiapine generic - fluvoxamine without prescription eskalith for sale
buy clomipramine 25mg generic - buy cymbalta without prescription doxepin online order
atarax 25mg canada - buy sarafem 40mg for sale buy endep generic
buy augmentin pills - purchase linezolid sale buy cipro 500mg
order amoxicillin without prescription - buy axetil generic cheap cipro 500mg
buy cleocin 150mg without prescription - order suprax 100mg pill buy chloramphenicol tablets
order zithromax 500mg online cheap - ofloxacin online buy ciprofloxacin 500mg tablet
generic ivermectin online - ivermectin 6mg for humans for sale buy cefaclor capsules for sale
ventolin inhalator cost - purchase allegra for sale theophylline generic
desloratadine pills - triamcinolone buy online albuterol price
depo-medrol us - loratadine online astelin 10 ml us
buy micronase 5mg online cheap - brand glucotrol 5mg forxiga pills
order prandin 1mg pills - empagliflozin price generic jardiance 25mg
glucophage 1000mg tablet - precose 25mg us order generic acarbose 25mg
terbinafine pills - buy griseofulvin sale griseofulvin oral
order rybelsus 14 mg pills - order semaglutide 14mg generic buy DDAVP cheap
purchase ketoconazole online - buy generic butenafine over the counter itraconazole 100 mg price
buy generic famciclovir 250mg - buy acyclovir generic buy valaciclovir 1000mg pills
lanoxin online - order generic digoxin 250 mg lasix 40mg drug
order microzide for sale - amlodipine 10mg uk pill zebeta
metoprolol price - micardis oral buy adalat without a prescription
buy nitroglycerin online cheap - combipres without prescription buy generic diovan 160mg
crestor roger - ezetimibe online bottom caduet buy interval
zocor forgive - lopid intention atorvastatin week
viagra professional online country - eriacta wooden levitra oral jelly cross
priligy funny - udenafil rack cialis with dapoxetine sensation
cialis soft tabs younger - cialis super active pills bloody1 viagra oral jelly glimpse
cenforce potter - cenforce lee brand viagra online connection
acne treatment communication - acne medication chocolate acne treatment narrow
asthma medication dream - asthma medication stage asthma treatment heat
uti medication effect - uti antibiotics mere uti antibiotics thorough
prostatitis treatment dart - prostatitis pills market prostatitis treatment into
valtrex online contrary - valacyclovir creak valtrex online chicken
loratadine quiver - loratadine link loratadine medication bang
priligy jail - priligy recollect priligy marsh
loratadine trial - claritin pills private claritin pills severe
ascorbic acid include - ascorbic acid champion ascorbic acid gasp
promethazine beg - promethazine right promethazine owl
biaxin american - cytotec pills bronze cytotec fred
fludrocortisone wither - esomeprazole officer lansoprazole pills positive
aciphex online - order metoclopramide for sale motilium brand
buy bisacodyl 5 mg - liv52 20mg price liv52 cost
purchase cotrimoxazole - keppra 1000mg us buy tobra 5mg generic
order zovirax without prescription - desogestrel 0.075mg over the counter duphaston 10 mg generic
buy forxiga 10mg - sinequan 25mg without prescription where can i buy acarbose
fulvicin 250 mg usa - order dipyridamole 100mg generic lopid 300 mg price
buy dimenhydrinate medication - cost dimenhydrinate 50 mg pill actonel 35mg
enalapril medication - generic xalatan buy zovirax cheap
buy generic monograph for sale - buy generic pletal buy pletal for sale
feldene without prescription - buy feldene 20 mg online cheap order rivastigmine 3mg pills
nootropil online order - buy piracetam 800mg sale order sinemet 10mg pills
buy generic hydrea - order trecator sc sale order robaxin 500mg pill
buy generic depakote for sale - purchase acetazolamide without prescription buy topiramate 200mg pill
buy generic disopyramide phosphate for sale - pregabalin 150mg drug buy chlorpromazine 100mg
order flexeril 15mg online - how to buy enalapril buy vasotec 10mg for sale
zofran 4mg generic - ondansetron online buy buy requip 2mg generic
ascorbic acid 500mg tablet - order isosorbide dinitrate online cheap purchase compro online
purchase durex gel online - how to order durex condoms where can i buy zovirax
minoxidil sale - proscar us oral finpecia
leflunomide 10mg uk - risedronate medication order cartidin without prescription
tenormin 50mg over the counter - buy coreg 25mg online how to get coreg without a prescription
buy calan 240mg generic - buy valsartan 160mg buy tenoretic tablets
how to buy atorlip - enalapril for sale online buy bystolic cheap
purchase gasex generic - order gasex generic diabecon online order
noroxin brand - purchase flutamide for sale purchase confido generic
speman order - cheap speman for sale finasteride canada
buy finax sale - finasteride for sale buy alfuzosin 10 mg online
buy hytrin 5mg pill - buy dapoxetine 60mg online priligy online buy
buy oxcarbazepine 600mg - oxcarbazepine drug buy levothyroxine without a prescription
purchase cyclosporine sale - buy generic imusporin over the counter gloperba usa
buy cheap duphalac - cheap mentat generic buy generic betahistine online
buy calcort tablets - buy brimonidine online how to buy alphagan
generic besifloxacin - sildamax generic buy sildamax generic
purchase benemid online cheap - buy benemid 500 mg pills tegretol 200mg cheap
order colospa for sale - etoricoxib 60mg cheap order generic cilostazol
celebrex 200mg brand - urispas over the counter buy indocin generic
voltaren price - cambia generic order aspirin 75 mg online cheap
rumalaya online - shallaki online order elavil 10mg without prescription
buy pyridostigmine 60 mg generic - order sumatriptan 50mg online azathioprine online buy
cheap voveran pill - nimotop for sale online buy nimotop medication
lioresal oral - cost piroxicam 20 mg piroxicam 20 mg brand
cyproheptadine pill - buy generic tizanidine tizanidine 2mg pill
accutane 20mg price - purchase absorica sale deltasone 10mg pill
buy cefdinir 300mg for sale - clindamycin gel clindamycin sale
permethrin online - oral acticin buy generic tretinoin over the counter
metronidazole order online - buy generic metronidazole 200mg cost cenforce 100mg
purchase betamethasone generic - cheap monobenzone buy benoquin sale
buy augmentin 375mg sale - order augmentin 1000mg online synthroid canada
buy cleocin 150mg for sale - order cleocin 300mg for sale indocin brand
order crotamiton for sale - aczone drug buy aczone online cheap
buy cheap generic zyban - order xenical 120mg generic buy generic shuddha guggulu
order modafinil 200mg generic - how to buy promethazine melatonin uk
capecitabine where to buy - buy danazol 100mg pills order danocrine 100 mg sale
norethindrone 5 mg generic - buy aygestin 5 mg generic buy yasmin pills
fosamax order - generic nolvadex 10mg medroxyprogesterone cheap
buy yasmin cheap - letrozole 2.5mg generic anastrozole oral
シルデナフィル処方 - シアリス - 50mg/100mg シアリス - 50mg/100mg
プレドニン処方 - гѓ—гѓ¬гѓ‰гѓ‹гѓі е‰ЇдЅњз”Ё г‚ўг‚ёг‚№гѓгѓћг‚¤г‚·гѓі жµ·е¤–йЂљиІ©
гѓ—гѓ¬гѓ‰гѓ‹гѓійЂљиІ© - г‚ўг‚ュテイン通販で買えますか г‚ўг‚ュテイン и–¬е±ЂгЃ§иІ·гЃ€г‚‹
order crixivan generic - indinavir order online emulgel where to order
valif ought - valif army sinemet cost
modafinil brand - buy provigil epivir pill
brand phenergan - order ciplox 500mg generic cost lincomycin 500 mg
deltasone order - order capoten 25mg generic captopril for sale
order isotretinoin 10mg generic - dexamethasone buy online linezolid 600 mg pills
amoxil uk - diovan price oral combivent
Gu Min, who stepped into the virgo erectile dysfunction Cialis In Canada Over The Counter imperial city through the palace gate, where can i buy propecia online Behandlingsrekommendationer för barn
zithromax 500mg without prescription - buy generic nebivolol over the counter buy generic bystolic online
order omnacortil 40mg online cheap - order progesterone pill oral progesterone
buy generic gabapentin - buy anafranil generic buy itraconazole 100 mg for sale
lasix cost - buy furosemide generic betamethasone 20gm usa
cost acticlate - order albuterol pill buy glipizide generic
augmentin 1000mg tablet - nizoral ca cymbalta 20mg drug
augmentin pills - cymbalta 20mg ca duloxetine ca
generic tizanidine - hydrochlorothiazide 25mg without prescription microzide for sale
viagra 50mg pills for men - oral cialis cialis 40mg for sale
cialis 40mg us - buy generic tadalafil 5mg viagra 50mg brand
buy cheap cenforce - purchase cenforce generic order glucophage for sale
generic prilosec 20mg - atenolol usa buy tenormin 50mg sale
medrol over the counter - buy aristocort generic triamcinolone 10mg over the counter
desloratadine 5mg pills - oral claritin 10mg priligy 30mg usa
purchase cytotec pills - buy cytotec cheap diltiazem 180mg usa
brand acyclovir 800mg - zyloprim ca rosuvastatin 10mg canada
buy domperidone pills for sale - buy flexeril 15mg sale cyclobenzaprine oral
buy motilium paypal - cost cyclobenzaprine 15mg buy cyclobenzaprine 15mg online
buy inderal 10mg pill - methotrexate price oral methotrexate 2.5mg
cost warfarin - generic warfarin order generic cozaar
levofloxacin 500mg sale - levofloxacin brand ranitidine online order
purchase mobic - mobic 7.5mg tablet flomax canada
where to buy cheap clomiphene pill cost of cheap clomid without rx where can i buy cheap clomiphene how to get clomiphene pill how to buy clomid pill can i get clomid without rx how can i get cheap clomiphene without dr prescription
This is the kind of criticism I in fact appreciate.
This website really has all of the tidings and facts I needed about this participant and didn’t positive who to ask.
buy propranolol tablets - inderal 10mg canada brand methotrexate 2.5mg
amoxil over the counter - cheap amoxicillin pill order ipratropium 100mcg sale
azithromycin generic - tindamax 500mg cheap order bystolic 5mg
order esomeprazole 20mg pills - https://anexamate.com/ buy nexium 20mg generic
coumadin ca - anticoagulant buy generic hyzaar for sale
brand mobic - swelling buy meloxicam pills for sale
cheap erectile dysfunction pills - fast ed to take non prescription erection pills
purchase fluconazole generic - https://gpdifluca.com/# fluconazole order
order cenforce 100mg sale - site cenforce 50mg drug
do you need a prescription for cialis - https://ciltadgn.com/ generic tadalafil cost
tadalafil dapoxetine tablets india - cialis 5mg how long does it take to work u.s. pharmacy prices for cialis
ranitidine pill - https://aranitidine.com/ ranitidine 300mg oral
order viagra online overnight delivery - https://strongvpls.com/# viagra sale durban
The depth in this serving is exceptional. lasix for sale online
The thoroughness in this piece is noteworthy. click
The thoroughness in this section is noteworthy. https://ursxdol.com/get-metformin-pills/
More peace pieces like this would create the интернет better. https://prohnrg.com/product/atenolol-50-mg-online/
Greetings! Jolly useful suggestion within this article! It’s the scarcely changes which choice make the largest changes. Thanks a lot towards sharing!
https://doxycyclinege.com/pro/esomeprazole/
This is the gentle of literature I in fact appreciate. http://bbs.51pinzhi.cn/home.php?mod=space&uid=7059376
buy cheap generic dapagliflozin - site dapagliflozin 10 mg cost
purchase orlistat sale - site buy orlistat pills for sale
More posts like this would create the online space more useful. https://www.forum-joyingauto.com/member.php?action=profile&uid=49504
You can shelter yourself and your dearest by being wary when buying medicine online. Some pharmacy websites manipulate legally and offer convenience, secretiveness, rate savings and safeguards over the extent of purchasing medicines. buy in TerbinaPharmacy https://terbinafines.com/product/arimidex.html arimidex
The thoroughness in this draft is noteworthy. TerbinaPharmacy
Thanks for sharing. It’s first quality.