2. 次にMagento サンプルデータを入手!

Magentoでショッピングカートを作っても、中に何も入っていないと寂しいですよね。
なので初期データとしてサンプルデータを取り込みましょう。

先ほどと同様ダウンロードページから入手できます。
http://www.magentocommerce.com/download

2013-11-05 18_01_29-Open Source Ecommerce Software & Solutions _ Magento

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本体のインストール作業を始める前にサンプルデータのインポートをする必要があるので、この作業を後回しにしないようにしてください!

ダウンロードしたファイル内にある下記のファイルが対象となります。
2013-11-05 18_10_37-magento1

サーバへのアップロードはFTPツールを使ってください。ちなみに私はFilezillaを使っています。無料です。

下記がMysqlへのインポートコマンドです。

mysql -umagento_user -p magento < magento_sample_data_for_1.6.1.0.sql

下記コマンドでMagentoデータベースにテーブルが作成されていることを確認しましょう。

mysql> use magento;
mysql> show tables;


  1. Usqclb より:

    order atorvastatin 10mg pills order lipitor 10mg online cheap lipitor 10mg generic

  2. Jgzqoo より:

    order ciprofloxacin 500mg online - order amoxiclav sale where can i buy augmentin

  3. Wruhzh より:

    order cipro 500mg without prescription - order cephalexin 500mg online purchase amoxiclav

  4. Wixvqo より:

    flagyl oral - generic amoxil azithromycin 250mg canada

  5. Vlqyut より:

    buy ciprofloxacin generic - buy doxycycline generic erythromycin oral

  6. Bqxvpd より:

    order valacyclovir 1000mg without prescription - diltiazem cost purchase zovirax generic

  7. Upfytt より:

    stromectol cost in usa - buy ciplox 500mg pills purchase tetracycline for sale

  8. Qmdhcl より:

    buy flagyl 400mg for sale - buy amoxicillin no prescription buy cheap generic zithromax

  9. Qzcjzq より:

    ampicillin order doxycycline oral amoxicillin pills

  10. Zonvlj より:

    furosemide 40mg ca - cheap capoten 120mg buy captopril sale

  11. Ncfriq より:

    glycomet online - generic lincocin purchase lincomycin for sale

  12. Vyoicc より:

    buy clozaril cheap - buy altace 5mg generic order pepcid online cheap

  13. Nrtvzf より:

    buy quetiapine generic - fluvoxamine without prescription eskalith for sale

  14. Ethkmp より:

    buy clomipramine 25mg generic - buy cymbalta without prescription doxepin online order

  15. Kqnexd より:

    atarax 25mg canada - buy sarafem 40mg for sale buy endep generic

  16. Iltuoq より:

    buy augmentin pills - purchase linezolid sale buy cipro 500mg

  17. Ifrmhb より:

    order amoxicillin without prescription - buy axetil generic cheap cipro 500mg

  18. Epujnm より:

    buy cleocin 150mg without prescription - order suprax 100mg pill buy chloramphenicol tablets

  19. Viaqud より:

    order zithromax 500mg online cheap - ofloxacin online buy ciprofloxacin 500mg tablet

  20. Jqqexk より:

    generic ivermectin online - ivermectin 6mg for humans for sale buy cefaclor capsules for sale

  21. Olnawz より:

    ventolin inhalator cost - purchase allegra for sale theophylline generic

  22. Mpaxfl より:

    desloratadine pills - triamcinolone buy online albuterol price

  23. Teyixg より:

    depo-medrol us - loratadine online astelin 10 ml us

  24. Fcsefd より:

    buy micronase 5mg online cheap - brand glucotrol 5mg forxiga pills

  25. Gzznin より:

    order prandin 1mg pills - empagliflozin price generic jardiance 25mg

  26. Kipuwz より:

    glucophage 1000mg tablet - precose 25mg us order generic acarbose 25mg

  27. Bhjqrv より:

    terbinafine pills - buy griseofulvin sale griseofulvin oral

  28. Vixnsn より:

    order rybelsus 14 mg pills - order semaglutide 14mg generic buy DDAVP cheap

  29. Uuimkz より:

    purchase ketoconazole online - buy generic butenafine over the counter itraconazole 100 mg price

  30. Aasfrp より:

    buy generic famciclovir 250mg - buy acyclovir generic buy valaciclovir 1000mg pills

  31. Titzrl より:

    lanoxin online - order generic digoxin 250 mg lasix 40mg drug

  32. Zyqyco より:

    order microzide for sale - amlodipine 10mg uk pill zebeta

  33. Cvvaec より:

    metoprolol price - micardis oral buy adalat without a prescription

  34. Aqcqez より:

    buy nitroglycerin online cheap - combipres without prescription buy generic diovan 160mg

  35. Acywnd より:

    crestor roger - ezetimibe online bottom caduet buy interval

  36. Olzlac より:

    zocor forgive - lopid intention atorvastatin week

  37. Cicnvl より:

    viagra professional online country - eriacta wooden levitra oral jelly cross

  38. Wyqkpn より:

    priligy funny - udenafil rack cialis with dapoxetine sensation

  39. Iwezfj より:

    cialis soft tabs younger - cialis super active pills bloody1 viagra oral jelly glimpse

  40. Imxlno より:

    cenforce potter - cenforce lee brand viagra online connection

  41. Zcffnl より:

    acne treatment communication - acne medication chocolate acne treatment narrow

  42. Pzwjsz より:

    asthma medication dream - asthma medication stage asthma treatment heat

  43. Qeqsgk より:

    uti medication effect - uti antibiotics mere uti antibiotics thorough

  44. Khlvcl より:

    prostatitis treatment dart - prostatitis pills market prostatitis treatment into

  45. Ymcwtj より:

    valtrex online contrary - valacyclovir creak valtrex online chicken

  46. Rccseu より:

    loratadine quiver - loratadine link loratadine medication bang

  47. Skbjux より:

    priligy jail - priligy recollect priligy marsh

  48. Bwwknf より:

    loratadine trial - claritin pills private claritin pills severe

  49. Iriovh より:

    ascorbic acid include - ascorbic acid champion ascorbic acid gasp

  50. Jogxyx より:

    promethazine beg - promethazine right promethazine owl

  51. Xdxsep より:

    biaxin american - cytotec pills bronze cytotec fred

  52. Sgezbc より:

    fludrocortisone wither - esomeprazole officer lansoprazole pills positive

  53. Kczrmk より:

    aciphex online - order metoclopramide for sale motilium brand

  54. Thiubo より:

    buy bisacodyl 5 mg - liv52 20mg price liv52 cost

  55. Plasrb より:

    purchase cotrimoxazole - keppra 1000mg us buy tobra 5mg generic

  56. Gicqnc より:

    order zovirax without prescription - desogestrel 0.075mg over the counter duphaston 10 mg generic

  57. Dyjira より:

    buy forxiga 10mg - sinequan 25mg without prescription where can i buy acarbose

  58. Aojwme より:

    fulvicin 250 mg usa - order dipyridamole 100mg generic lopid 300 mg price

  59. Cvaimt より:

    buy dimenhydrinate medication - cost dimenhydrinate 50 mg pill actonel 35mg

  60. Hizmax より:

    enalapril medication - generic xalatan buy zovirax cheap

  61. Sdoxta より:

    buy generic monograph for sale - buy generic pletal buy pletal for sale

  62. Tmvjqy より:

    feldene without prescription - buy feldene 20 mg online cheap order rivastigmine 3mg pills

  63. Ssydps より:

    nootropil online order - buy piracetam 800mg sale order sinemet 10mg pills

  64. Bdybfd より:

    buy generic hydrea - order trecator sc sale order robaxin 500mg pill

  65. Bwzhap より:

    buy generic depakote for sale - purchase acetazolamide without prescription buy topiramate 200mg pill

  66. Orjdjv より:

    buy generic disopyramide phosphate for sale - pregabalin 150mg drug buy chlorpromazine 100mg

  67. Wxtrpa より:

    order flexeril 15mg online - how to buy enalapril buy vasotec 10mg for sale

  68. Wkselc より:

    zofran 4mg generic - ondansetron online buy buy requip 2mg generic

  69. Prevrz より:

    ascorbic acid 500mg tablet - order isosorbide dinitrate online cheap purchase compro online

  70. Ltpopd より:

    purchase durex gel online - how to order durex condoms where can i buy zovirax

  71. Gwtxdh より:

    minoxidil sale - proscar us oral finpecia

  72. Nxjkco より:

    leflunomide 10mg uk - risedronate medication order cartidin without prescription

  73. Czrihr より:

    tenormin 50mg over the counter - buy coreg 25mg online how to get coreg without a prescription

  74. Tiyykr より:

    buy calan 240mg generic - buy valsartan 160mg buy tenoretic tablets

  75. Loubsr より:

    how to buy atorlip - enalapril for sale online buy bystolic cheap

  76. Ybgpzq より:

    purchase gasex generic - order gasex generic diabecon online order

  77. Mwvlgv より:

    noroxin brand - purchase flutamide for sale purchase confido generic

  78. Lvvxqx より:

    speman order - cheap speman for sale finasteride canada

  79. Gwoatx より:

    buy finax sale - finasteride for sale buy alfuzosin 10 mg online

  80. Hrskmi より:

    buy hytrin 5mg pill - buy dapoxetine 60mg online priligy online buy

  81. Gkwixk より:

    buy oxcarbazepine 600mg - oxcarbazepine drug buy levothyroxine without a prescription

  82. Qotrgi より:

    purchase cyclosporine sale - buy generic imusporin over the counter gloperba usa

  83. Amxhlw より:

    buy cheap duphalac - cheap mentat generic buy generic betahistine online

  84. Pejaad より:

    buy calcort tablets - buy brimonidine online how to buy alphagan

  85. Xrfeik より:

    generic besifloxacin - sildamax generic buy sildamax generic

  86. Wsldmm より:

    purchase benemid online cheap - buy benemid 500 mg pills tegretol 200mg cheap

  87. Xjrpca より:

    order colospa for sale - etoricoxib 60mg cheap order generic cilostazol

  88. Buidzd より:

    celebrex 200mg brand - urispas over the counter buy indocin generic

  89. Qscgwq より:

    voltaren price - cambia generic order aspirin 75 mg online cheap

  90. Jatetz より:

    rumalaya online - shallaki online order elavil 10mg without prescription

  91. Oylehz より:

    buy pyridostigmine 60 mg generic - order sumatriptan 50mg online azathioprine online buy

  92. Tskanq より:

    cheap voveran pill - nimotop for sale online buy nimotop medication

  93. Kxdibf より:

    lioresal oral - cost piroxicam 20 mg piroxicam 20 mg brand

  94. Vsvrxc より:

    cyproheptadine pill - buy generic tizanidine tizanidine 2mg pill

  95. Zwoswg より:

    accutane 20mg price - purchase absorica sale deltasone 10mg pill

  96. Xryjpb より:

    buy cefdinir 300mg for sale - clindamycin gel clindamycin sale

  97. Jzubnd より:

    permethrin online - oral acticin buy generic tretinoin over the counter

  98. Hpfkft より:

    metronidazole order online - buy generic metronidazole 200mg cost cenforce 100mg

  99. Aqytmy より:

    purchase betamethasone generic - cheap monobenzone buy benoquin sale

  100. Qjrgbp より:

    buy augmentin 375mg sale - order augmentin 1000mg online synthroid canada

  101. Ybmlng より:

    buy cleocin 150mg for sale - order cleocin 300mg for sale indocin brand

  102. Drjbop より:

    order crotamiton for sale - aczone drug buy aczone online cheap

  103. Auhasr より:

    buy cheap generic zyban - order xenical 120mg generic buy generic shuddha guggulu

  104. Zjncpc より:

    order modafinil 200mg generic - how to buy promethazine melatonin uk

  105. Urarws より:

    capecitabine where to buy - buy danazol 100mg pills order danocrine 100 mg sale

  106. Dszxzf より:

    norethindrone 5 mg generic - buy aygestin 5 mg generic buy yasmin pills

  107. Mqmfth より:

    fosamax order - generic nolvadex 10mg medroxyprogesterone cheap

  108. Gficsf より:

    buy yasmin cheap - letrozole 2.5mg generic anastrozole oral

  109. Dpojbo より:

    シルデナフィル処方 - シアリス - 50mg/100mg シアリス - 50mg/100mg

  110. Zukzbz より:

    プレドニン処方 - プレドニン 副作用 アジスロマイシン 海外通販

  111. Zfgbql より:

    プレドニン通販 - アキュテイン通販で買えますか アキュテイン 薬局で買える

  112. Omsztm より:

    order crixivan generic - indinavir order online emulgel where to order

  113. Ddktkz より:

    valif ought - valif army sinemet cost

  114. Knlgfk より:

    modafinil brand - buy provigil epivir pill

  115. Wkbngp より:

    brand phenergan - order ciplox 500mg generic cost lincomycin 500 mg

  116. Gjbugh より:

    deltasone order - order capoten 25mg generic captopril for sale

  117. Rrucmg より:

    order isotretinoin 10mg generic - dexamethasone buy online linezolid 600 mg pills

  118. Oqocin より:

    amoxil uk - diovan price oral combivent

  119. 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

  120. Ybkzfd より:

    zithromax 500mg without prescription - buy generic nebivolol over the counter buy generic bystolic online

  121. Wcwggt より:

    order omnacortil 40mg online cheap - order progesterone pill oral progesterone

  122. Sopqxl より:

    buy generic gabapentin - buy anafranil generic buy itraconazole 100 mg for sale

  123. Kfyrii より:

    lasix cost - buy furosemide generic betamethasone 20gm usa

  124. Babmjv より:

    cost acticlate - order albuterol pill buy glipizide generic

  125. Drjhll より:

    augmentin 1000mg tablet - nizoral ca cymbalta 20mg drug

  126. Nnseww より:

    augmentin pills - cymbalta 20mg ca duloxetine ca

  127. Izpsus より:

    viagra 50mg pills for men - oral cialis cialis 40mg for sale

  128. Uneegx より:

    cialis 40mg us - buy generic tadalafil 5mg viagra 50mg brand

  129. Obfdax より:

    buy cheap cenforce - purchase cenforce generic order glucophage for sale

  130. Phnuwc より:

    generic prilosec 20mg - atenolol usa buy tenormin 50mg sale

  131. Yzoiea より:

    medrol over the counter - buy aristocort generic triamcinolone 10mg over the counter

  132. Ennlta より:

    desloratadine 5mg pills - oral claritin 10mg priligy 30mg usa

  133. Bfewxs より:

    purchase cytotec pills - buy cytotec cheap diltiazem 180mg usa

  134. Xbqmzi より:

    brand acyclovir 800mg - zyloprim ca rosuvastatin 10mg canada

  135. Atnbpa より:

    buy domperidone pills for sale - buy flexeril 15mg sale cyclobenzaprine oral

  136. Oftrme より:

    buy motilium paypal - cost cyclobenzaprine 15mg buy cyclobenzaprine 15mg online

  137. Vvptlr より:

    buy inderal 10mg pill - methotrexate price oral methotrexate 2.5mg

  138. Rtwrjf より:

    cost warfarin - generic warfarin order generic cozaar

  139. Faimsv より:

    levofloxacin 500mg sale - levofloxacin brand ranitidine online order

  140. Kpgbmw より:

    purchase mobic - mobic 7.5mg tablet flomax canada

  141. knjcx より:

    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

  142. This is the kind of criticism I in fact appreciate.

  143. This website really has all of the tidings and facts I needed about this participant and didn’t positive who to ask.

  144. g0i9z より:

    buy propranolol tablets - inderal 10mg canada brand methotrexate 2.5mg

  145. p6nzj より:

    amoxil over the counter - cheap amoxicillin pill order ipratropium 100mcg sale

  146. sdhk2 より:

    azithromycin generic - tindamax 500mg cheap order bystolic 5mg

  147. vfv8k より:

    order esomeprazole 20mg pills - https://anexamate.com/ buy nexium 20mg generic

  148. uim88 より:

    coumadin ca - anticoagulant buy generic hyzaar for sale

  149. tuvj6 より:

    brand mobic - swelling buy meloxicam pills for sale

  150. dhse5 より:

    cheap erectile dysfunction pills - fast ed to take non prescription erection pills

  151. z8tza より:

    purchase fluconazole generic - https://gpdifluca.com/# fluconazole order

  152. h11qv より:

    order cenforce 100mg sale - site cenforce 50mg drug

  153. ubowk より:

    do you need a prescription for cialis - https://ciltadgn.com/ generic tadalafil cost

  154. 6kob6 より:

    tadalafil dapoxetine tablets india - cialis 5mg how long does it take to work u.s. pharmacy prices for cialis

  155. ConnieSag より:

    ranitidine pill - https://aranitidine.com/ ranitidine 300mg oral

  156. o347s より:

    order viagra online overnight delivery - https://strongvpls.com/# viagra sale durban

  157. sirup より:

    The depth in this serving is exceptional. lasix for sale online

  158. ConnieSag より:

    The thoroughness in this piece is noteworthy. click

  159. ConnieSag より:

    The thoroughness in this section is noteworthy. https://ursxdol.com/get-metformin-pills/

  160. byuq8 より:

    More peace pieces like this would create the интернет better. https://prohnrg.com/product/atenolol-50-mg-online/

  161. ConnieSag より:

    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/

  162. ConnieSag より:

    This is the gentle of literature I in fact appreciate. http://bbs.51pinzhi.cn/home.php?mod=space&uid=7059376

  163. ConnieSag より:

    buy cheap generic dapagliflozin - site dapagliflozin 10 mg cost

  164. ConnieSag より:

    purchase orlistat sale - site buy orlistat pills for sale

  165. ConnieSag より:

    More posts like this would create the online space more useful. https://www.forum-joyingauto.com/member.php?action=profile&uid=49504

  166. CymrBeaut より:

    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

  167. gs5ms より:

    The thoroughness in this draft is noteworthy. TerbinaPharmacy

  168. Thanks for sharing. It’s first quality.

comment

メールアドレスが公開されることはありません。 が付いている欄は必須項目です

© 2025 みる米技術部 Powered by AFFINGER5