昔のWordpress2.2ぐらいより前からアップグレードしてきた場合、MySQLのDB内のコードがUTF-8でも、ちゃんとUTF-8ではいってなくてphpMyAdminとかでも化けちゃうやつの解消。 また、wp-config.php内で define('DB_CHARSET', 'utf8'); とデフォルトの状態でも化けないようにする。 要は、昔、「SET NAMES ‘utf8’ 」といれておかないといけなかったのだけどいれてなくてlatin1で挿入されているデータベースの変換方法です。MySQLはよくわからんのでもっといいやり方あるかも データベースのDUMP mysqldump -u DB_USER -p'DB_PASSWORD' DB_NAME --default-character-set=latin1 > mysql.dmp DUMPしたバックアップファイルの上の10行目付
タグ
- すべて
- flash (6)
- .NET (2)
- .htaccess (1)
- 1000speakers (2)
- 2ch (4)
- 64bit (1)
- ARToolkit (1)
- Animal (1)
- Bespin (1)
- CouchDB (4)
- EC (3)
- FizzBuzz (1)
- Funnel (5)
- Interface (2)
- JumpShip (1)
- LT (1)
- MODx (1)
- MeeGo (1)
- New Generation Chronicle (1)
- Nu (1)
- Objective-J (1)
- OpenLaszlo (1)
- Parallel Studio (1)
- Plagger (1)
- SQS (1)
- Synergy (1)
- TOEFL (1)
- Titanium (6)
- XS (3)
- Zend Framework (2)
- actionscript (68)
- addon (11)
- adobe (3)
- adwords (1)
- agile (13)
- ai (6)
- aipo (3)
- air (38)
- ajax (64)
- alert (1)
- algorithm (13)
- alias (1)
- amazon (20)
- amazon ec2 (4)
- amazonec2 (5)
- amazons3 (1)
- ameblo (1)
- america (1)
- amf (1)
- analytics (1)
- andorid (2)
- android (28)
- apache (64)
- apache solr (2)
- api (23)
- apolon (1)
- apple (4)
- arduino (4)
- art (11)
- atompub (1)
- auth (1)
- aws (1)
- backup (2)
- baidu (1)
- barcode (1)
- bgm (1)
- binary (1)
- bios (2)
- bison (1)
- blender (4)
- blog (17)
- bookmarklet (3)
- boost (1)
- bossen (3)
- business (224)
- c (24)
- c# (3)
- c++ (37)
- cable (1)
- cache (1)
- cairo (1)
- caja (2)
- cakephp (10)
- calendar (2)
- canonical (1)
- career (1)
- cassandra (2)
- casting (1)
- centos (19)
- centos5 (1)
- cgi (2)
- chumby (5)
- clojure (1)
- cloud computing (11)
- cloudcomputing (6)
- cm (1)
- cms (20)
- codepad (1)
- codereview (2)
- command (6)
- communication (7)
- community (3)
- config (1)
- cook (5)
- cooking (2)
- cookpad (2)
- copyright (1)
- courier-imap (1)
- crossdomain (1)
- csrf (1)
- css (61)
- curl (7)
- curl_multi (1)
- cybertech (1)
- cybozu (2)
- cygwin (1)
- d-bus (1)
- daemon (3)
- dankogai (2)
- data (3)
- database (9)
- dbm (1)
- debug (1)
- delegate (1)
- delphi (2)
- design (122)
- desktop (2)
- dictionary (2)
- dig (1)
- dj (1)
- django (3)
- dns (3)
- docomo (1)
- dom (1)
- dom storage (1)
- domain (1)
- dovecot (1)
- drizzle (1)
- dropbox (6)
- dynamic language runtime (1)
- e4x (1)
- eTicket (1)
- eaccelerator (1)
- eccube (2)
- eclipse (3)
- eco (1)
- economist (1)
- economy (1)
- emacs (5)
- engineer (7)
- english (19)
- entertainment (1)
- erlang (11)
- eucalyptus (2)
- event (20)
- evernote (1)
- excel (2)
- extension (1)
- facebook (10)
- fashion (1)
- ffmpeg (4)
- firefox (57)
- flash (87)
- flashdevelop (4)
- flashlite (1)
- flex (25)
- flexigrid (1)
- fms (2)
- font (16)
- food (1)
- form (3)
- framework (3)
- free (9)
- friend connect (1)
- ftp (1)
- gainer (23)
- game (2)
- gc (2)
- gd (1)
- geek (6)
- gem (1)
- generator (2)
- geomapapp (1)
- gimp (2)
- git (14)
- github (5)
- google (64)
- google app engine (25)
- google maps (1)
- googlechrome (1)
- grails (1)
- greasemonkey (7)
- groonga (2)
- groupon (2)
- guid (1)
- hack (5)
- hacker (3)
- hadoop (18)
- haskell (12)
- hatena (15)
- hbase (1)
- hinemos (1)
- hits (1)
- homepage (1)
- hosting (1)
- hotel (1)
- htaccess (3)
- html (17)
- html5 (7)
- http (8)
- httpd (2)
- human (1)
- ical (1)
- icon (8)
- ide (3)
- idea (5)
- ie (1)
- iknow (1)
- im (2)
- image (3)
- imap (2)
- install (4)
- internet (2)
- ip (1)
- ipa (5)
- iphone (36)
- ipod (1)
- iptables (1)
- ipv4 (1)
- ipv6 (3)
- irc (1)
- isp (1)
- it (16)
- japan (5)
- java (10)
- javafx (1)
- javascript (131)
- jetpack (1)
- jog note (1)
- jquery (61)
- jruby (1)
- js (21)
- json (15)
- jsonp (6)
- kizasi (2)
- kml (1)
- kosa japan (3)
- kumofs (1)
- kvs (1)
- lab (13)
- lambda (1)
- lan (1)
- language (3)
- latex (2)
- lego (1)
- lexer (1)
- library (11)
- libxml (1)
- license (2)
- life (7)
- lifehack (6)
- lightbox (2)
- lighttpd (1)
- lime (1)
- linux (33)
- lithium (5)
- livedoor (4)
- loadvars (1)
- local (1)
- log (2)
- logo (1)
- lolipop (1)
- lovecall (1)
- lpo (1)
- lua (1)
- luxio (2)
- mac (2)
- macbook (1)
- mail (4)
- management (2)
- map (2)
- marketing (7)
- mashup (7)
- material (3)
- media (2)
- medical (1)
- meeting (1)
- memcached (18)
- memory (2)
- merapi (1)
- merb (3)
- mercurial (1)
- messagepack (2)
- metal (1)
- mindmap (1)
- mixi (15)
- mobile (41)
- mod_chxj (1)
- mod_dosdetector (1)
- mod_layout (4)
- mod_perl (1)
- mod_reproxy (1)
- mod_rewrite (1)
- module (2)
- money (4)
- mongodb (10)
- monit (3)
- monitor (1)
- mono (1)
- moonlinx (1)
- mootools (1)
- mosh (2)
- motion (1)
- movabletype (2)
- movie (3)
- moxy (2)
- mozilla (4)
- msn (1)
- mula (1)
- multitouch (1)
- music (5)
- mxml (2)
- myspace (1)
- mysql (37)
- nativeclient (3)
- naver (1)
- netbeans (1)
- network (6)
- news (18)
- nginx (1)
- ninja (1)
- noren (1)
- nosql (4)
- note pc (3)
- o3d (1)
- oauth (12)
- objective-c (4)
- ocaml (3)
- odbc (1)
- omake (2)
- oop (2)
- oosah (1)
- opencv (1)
- opengl (2)
- openid (7)
- openpear (4)
- openpne (2)
- opensocial (5)
- opensource (2)
- openssl (1)
- opensuse (1)
- openvpn (1)
- openvz (11)
- oracle (21)
- oss (34)
- page (2)
- papervision3d (15)
- parser (2)
- pc (12)
- pear (16)
- pecl (4)
- performance (6)
- perl (28)
- pfi (2)
- photo (2)
- photoshop (7)
- php (165)
- place (2)
- plugin (14)
- postfix (3)
- presentation (9)
- processing (32)
- procmail (2)
- program (5)
- programming (29)
- progression (22)
- project (6)
- proxy (8)
- puppet (2)
- python (21)
- q4m (7)
- qiita (2)
- qmail (4)
- quota (5)
- rails (9)
- recipe (4)
- ria (4)
- router (3)
- rpm (2)
- rss (2)
- rtm (2)
- ruby (110)
- ruby on rails (83)
- safari (2)
- scala (4)
- science (2)
- screen (4)
- search (3)
- security (13)
- self (97)
- senna (5)
- seo (26)
- server (62)
- service (21)
- session (2)
- sh (2)
- shibuya.pm (2)
- shop (3)
- silverlight (12)
- skype (5)
- sns (7)
- soap (2)
- social (2)
- software (7)
- sony (2)
- sound (3)
- sql (6)
- sqlite (7)
- squid (8)
- ssd (3)
- ssh (5)
- ssl (16)
- storage (4)
- subversion (6)
- suexec (9)
- suphp (5)
- svn (3)
- symfony (31)
- template (2)
- test (7)
- thunderbird (4)
- tips (11)
- tokyo cabinet (2)
- tokyo tyrant (3)
- tokyocabinet (8)
- tokyotyrant (4)
- tool (209)
- topcoder (7)
- trac (4)
- tuning (2)
- tutorial (5)
- twitter (38)
- ubiquity (2)
- ubuntu (5)
- usability (17)
- validate (2)
- venture (3)
- vi (2)
- vim (27)
- vimperator (4)
- virtuozzo (2)
- vj (5)
- vmware (2)
- vps (8)
- web (18)
- webalizer (2)
- webapi (6)
- webdesign (2)
- webkit (2)
- webservice (12)
- webサービス (5)
- wii (2)
- wiki (2)
- windows (9)
- word (2)
- wordpress (18)
- work (5)
- xen (10)
- xml (2)
- yahoo (16)
- yapc (2)
- yum (4)
- zsh (9)
- はてな (2)
- まとめ (3)
- クラウド (2)
- サイト売買 (8)
- セキュリティ (2)
- プロバイダ (2)
- 不動産 (7)
- 企画書 (2)
- 化粧品 (3)
- 就職 (3)
- 投資 (2)
- 携帯 (2)
- 日本アジア投資 (3)
- 未踏 (3)
- 検索 (7)
- 正規表現 (2)
- 法律 (2)
- 監視 (17)
- 素材 (2)
- 起業 (6)
- 退職 (4)
- business (224)
- tool (209)
- php (165)
- javascript (131)
- design (122)
- ruby (110)
- self (97)
- flash (87)
- ruby on rails (83)
- actionscript (68)
centos5に関するcamelmasaのブックマーク (1)
-
camelmasa 2008/10/25
- openvz
- centos5
リンク -
1
公式Twitter
- @HatenaBookmark
リリース、障害情報などのサービスのお知らせ
- @hatebu
最新の人気エントリーの配信
処理を実行中です
キーボードショートカット一覧
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
設定を変更しましたx