2006年01月16日
●MySQLに移行完了
らんシャチョーがMTのＤＢをBerkeleyDBからMySQLへ移行した記事を見て、僕もやってみました！
以下参考サイト
MovableType の DB を BerkeleyDB から MySQL に移行し隊
MovableTypeをMySQLデータベースで利用する際の設定手順（バージョン3.2以前）
以前、MySQLは既にインストールしていて、データベースも作っていたのでサクサクと進んでいきました。
そしてmt-db2sql.cgiの実行になって以下のエラーが・・・
An error occurred while loading data:
Insertion test failed on SQL error Column 'templatemap_template_id' cannot be null
Templatemapって何だ？って事で調べてみると
MT::Templatemap (mt_templatemap テーブル)
どのテンプレートが、どのウェブログに属しているかなどを紐づけるためのデータを操作するクラス。
らしい。対策方法がないか調べてみましたが、見つかりません。
ウェブログは一つしか作ってないしこれはエラーでもいいかなぁ・・・？;
というわけで、強攻策へ。
mt-db2sql.cgiの
my @CLASSES = qw( MT::Author MT::Blog MT::Category MT::Comment
MT::Entry MT::IPBanList MT::Log MT::Notification
MT::Permission MT::Placement MT::Template MT::TemplateMap
MT::TBPing MT::Trackback);
と言う部分を
my @CLASSES = qw( MT::Author MT::Blog MT::Category MT::Comment MT::Entry
MT::IPBanList MT::Log MT::Notification MT::Permission
MT::Placement MT::Template MT::Trackback
MT::TBPing MT::TemplateMap);
以下のように変更（ｗ
これでトラックバックの移行は無事完了。
やはりTemplateMapの所でエラーは出ますが、普通に動くので問題ないかな！？
もし、なにかバグっぽい動作をしたらコメントしてください。
Berkeley DBに戻します。
TB来ててビックリしましたｗ
ちなみにEUCのblogからTB来ると化けるのは多分うちの問題なので大丈夫かと。orz
あ、そうなんですか〜良かった・・・（マテ
移行の記事大変参考になりました。おかげで若干軽くなった気がします。
wytvgj rfzuxdab enydvzl vutjr yacgfx sgzu iobylx
kqjufl uyeit qotbvcf qtdcizre ckrmp eoquvg etbzg http://www.kiqogw.vwkxlcoy.com
Nice site. Thank you!!!
http://jeeee.net/url/1746.html buy norco
Nice site. Thank you!!!
http://jeeee.net/url/1746.html buy norco
Cool site. Thank you!
http://jeeee.net/url/1745.html buy xanax online
Very good site. Thanks!
http://s-url.net/02yf/ cheap adipex
Very good site. Thanks!
http://s-url.net/02yf/ cheap adipex
Cool site. Thanks.
http://s-url.net/02yg/ alprazolam 0.5 mg
Cool site. Thanks.
http://s-url.net/02yg/ alprazolam 0.5 mg
Cool site. Thanks:-)
http://s-url.net/02yh/ ambien addiction
Good site. Thanks:-)
http://s-url.net/0310/ corona norco
Very good site. Thanks.
http://s-url.net/0311/ buy xanax on line
Very good site. Thank you.
http://s-url.net/030p/ arabic ringtone
Cool site. Thanks!!!
http://s-url.net/030x/ online ultram
Cool site. Thanks.
http://s-url.net/030k/ free levitra
Good site. Thank you:-)
http://s-url.net/02yj/ hydrocodone abuse
Good site. Thank you:-)
http://s-url.net/030y/ valium picture
Nice site. Thanks.
http://s-url.net/030w/ buy tramadol
Nice site. Thanks!
http://s-url.net/030l/ meridia cheap
Very good site. Thank you.
http://s-url.net/030q/ send ringtone
Very good site. Thank you!
http://s-url.net/030v/ soma buy
Very good site. Thank you.
http://docs.google.com/View?docid=dfx8fjgc_0zv9sm co insurance
Nice site. Thanks!
http://docs.google.com/View?docid=dfx8fjgc_0zv9sm cheap insurance
Nice site. Thanks!
http://docs.google.com/View?docid=dfx8fjgc_0zv9sm cheap insurance
Cool site. Thanks:-)
http://s-url.net/02yj/ hydrocodone 10 325
Very good site. Thank you.
http://jeeee.net/url/9161.html dental insurance
Good site. Thanks!
http://jeeee.net/url/9169.html viagra side effects
Very good site. Thank you!
http://jeeee.net/url/9172.html xanax and pregnancy
Very good site. Thank you!
http://jeeee.net/url/9172.html xanax and pregnancy
Good site. Thanks!!!
http://jeeee.net/url/9171.html cheap ultram
Good site. Thanks!!!
http://jeeee.net/url/9171.html cheap ultram
Very good site. Thank you:-)
http://jeeee.net/url/9165.html ultram 50mg
Nice site. Thanks!!!
http://jeeee.net/url/9160.html ring tone
Nice site. Thanks!!!
http://jeeee.net/url/9160.html ring tone
Very good site. Thanks:-)
http://jeeee.net/url/9164.html generic soma
Cool site. Thank you.
http://jeeee.net/url/9166.html samsung ringtone
Cool site. Thank you.
http://jeeee.net/url/9166.html samsung ringtone
Cool site. Thanks:-)
http://jeeee.net/url/9174.html levitra 20mg
Helloulw - this is just a testing, don't worry about it
Good site. Thanks!
http://s-url.net/02yj/ hydrocodone online
Exelent! Good work! Please also visit my site:
[@../doorway/blogspot/tr3.txt||10||p-11||3||
Exelent! Good work! Please also visit my site:
[@../doorway/blogspot/tr3.txt||10||p-11||3||
One of the best locations I've come across lately!!! Definately a permanent bookmark! Please visit my homepage too:
[@../doorway/blogspot/tr9.txt||9||p-1||1||
I am very impressed how you can build webpages! Please also visit my site:
[@../doorway/blogspot/tr10.txt||7||p-1||1||
Hi, good morning to all of you... Nice Guestbook ;-) !! loan calculator bye
Your site looks great! Visit my sites, please:
Nice site. Thanks.
http://www.hiphopschool.com/triplexfm/functions/insurance4.htm allied insurance
Good site. Thank you!
http://www.hiphopschool.com/triplexfm/functions/ringtone1.htm ring tone
strap on
butte montana antique police badge
butte montana antique police badge
sexual harrassment video
sexual harrassment video
sexual harrassment video
sexual harrassment video
sexual harrassment video
northwest indiana sex offenders registory
northwest indiana sex offenders registory
northwest indiana sex offenders registory
northwest indiana sex offenders registory
northwest indiana sex offenders registory
86 s10 fiberglass bumper
86 s10 fiberglass bumper
86 s10 fiberglass bumper
86 s10 fiberglass bumper
86 s10 fiberglass bumper
soaking wet xxx latino girls
soaking wet xxx latino girls
soaking wet xxx latino girls
soaking wet xxx latino girls
soaking wet xxx latino girls
american red cross volunteer dental assistant program
canker sores in mouth
extreme funny sports pics
scary movie 4 revews sweddishpenispumps thumb vintage granny porno vintage anal sex mgm movies classic julie mackinnon nautilus kennels in plymouth massachusetts pulaski county assessment registered sex offenders free list sex and stuff hot young blog pics
XgpkrA df8v7ydfv83f61fvr58fdz
Hello good day porn website submission free >:-[[
Best Site good looking porn pictures of young illegal preteens kkla
Very funny pictures city passenger ship terminal cheap extended stay hotels in nashville tn 393
It's serious delhi christchurch cheap airport hotel hky
Hello good day mom 974018 porn literature %-[[[
i'm fine good work free teen deepthroat clips guii
mega site dude thanks =) see u youporn down
mega site man thanks ;) bookmark u uporn
magic story very thanks Zoo Toob ssoart Red Tube Tops Hot Fash eevh Ustube 8288 Hentai Red Toob jpdrov Replacement Hot Tub Covers Canada 209908 Cheap Hot Tub Covers vcq Red Tube Tops iev Discount Hot Tub Covers In Georgia >:D Free Porn Tuubes zpn Tuube Porn fyuqx
Very funny pictures military discount airline fares wdfe
Best Site Good Work real time flight tracking 4767
I love this site Pornography rljk
Thanks funny site lolita teen girl >:OO
Good crew it's cool :) little lolita, young lolitas njlr
real beauty page teenporn 770592
i'm fine good work preteensex 8-D
Punk not dead porntube sites >:-)
I love this site boysfood movies 692231
good material thanks Onlymovies 49350
perfect design thanks xxxlolitas %-))
Thanks funny site preteen models lolitas little girls archive >:]]
Hello good day adult nude wives photos :[[
real beauty page adult t shirts funny %-))
this post is fantastic redtube tops 3471
This site is crazy :) 4 maxporn mymxit
magic story very thanks xrated %-]]
I love this site japanese porntube 41940
i'm fine good work teen school girls lolita porn %-OO
I'm happy very good site gratis sextv 8-P
Best Site good looking Porntv Sex uig
this is be cool 8) xhamster movies 62137
Thanks funny site 18 Sextv %P
this is be cool 8) Porntv 12326
real beauty page sites like youporn :-)))
i'm fine good work youngporn sites 371
Punk not dead gratis sextv 79119
このエントリーのトラックバックURL:
http://farn.s22.xrea.com/cgi-bin/mt/mt-tb.cgi/214