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