Strict Standards: Declaration of action_plugin_blog::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/blog/action.php on line 13

Strict Standards: Declaration of action_plugin_indexmenu::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/indexmenu/action.php on line 13

Strict Standards: Declaration of action_plugin_importoldchangelog::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/importoldchangelog/action.php on line 8

Strict Standards: Declaration of action_plugin_importoldindex::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/importoldindex/action.php on line 8

Strict Standards: Declaration of action_plugin_include::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/include/action.php on line 19

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 208

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 211

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 421

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 594

Strict Standards: Declaration of cache_instructions::retrieveCache() should be compatible with cache::retrieveCache($clean = true) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/cache.php on line 291

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/auth.php on line 154

Strict Standards: Only variables should be passed by reference in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/doku.php on line 73
mpを本番サーバへ引っ越し [開発チーム]

mpを本番サーバへ引っ越し

開発環境のバックアップ

DBのバックアップ

PostgreSQL から MySQL へ移行なので「-d」のinsert文形式で出力

pg_dump -d admin > admin_091016.sql
pg_dump -d account1 > account1_091016.sql
pg_dump -d account2 > account2_091016.sql
pg_dump -d account5 > account5_091016.sql

圧縮

tar cvzf mp_db_091016.tar.gz *

ダンプの加工

MySQL に入るように加工

  • 上の方の「set」関連削除
  • 「timestamp without time zone DEFAULT now()」を「datetime」へ置換
  • 「.*OWNER TO zero;$」を空白へ置換
  • テーブル定義書に、manage_master、cookie が存在しない
  • product_master not null だと入らないので、すべてのNULLデータを空文字に変更
  • product_postage_master の ppm_area_48 のカラムとデータを削除しました(要確認)
  • test なんとかとか、テストっぽいのは削除しました
  • web_dir, web_file は定義書にない
  • site_master の型を少しいじりました

リストア

svn へログイン

fgm.fideli.com

fgm_we1へログイン

ssh fgm_web1
mysql -h fgm_mysql1 -p admin < admin_schema_091016.sql
mysql -h fgm_mysql1 -p admin < admin_data_091016.sql
mysql -h fgm_mysql1 -p account1 < account1_schema_091016.sql
mysql -h fgm_mysql1 -p account1 < account1_data_091016.sql

ZendFramework と Smarty

ZendFramework と Smarty を入れる

wget http://framework.zend.com/releases/ZendFramework-1.9.4/ZendFramework-1.9.4.tar.gz
tar xvzf ZendFramework-1.9.4.tar.gz
wget http://www.smarty.net/do_download.php?download_file=Smarty-2.6.26.tar.gz
tar xvzf Smarty-2.6.26.tar.gz

account1 のドメイン設定

select am_uniqnum, am_domain from account_master where am_uniqnum = 1;
update account_master set am_domain = 'fgm1.fideli.com' where am_uniqnum = 1;

カラムが大文字になっていたので修正

ちょっと間違いました。 admin, account1 両方やる

DROP
    TABLE IF EXISTS cookie;
CREATE
    TABLE cookie(
        id CHARACTER(32) NOT NULL
        ,modified INTEGER
        ,lifetime INTEGER
        ,data text
        ,PRIMARY KEY (id)
    ) ENGINE = NDBCLUSTER;
DROP
    TABLE IF EXISTS session;
CREATE
    TABLE session (
        id CHARACTER(100) NOT NULL
        ,modified INTEGER
        ,lifetime INTEGER
        ,data text
        ,PRIMARY KEY (id)
    ) ENGINE = NDBCLUSTER;

テンプレートのコンパイルディレクトリ作成

fgm_web1, fgm_web2 の両方に「/var/www/templates_c」を作成

mkdir /var/www/templates_c
chown www-data.www-data /var/www/templates_c/

000.default.conf

apacheの設定変更

Alias /upload /image_data
AllowOverride All

mod_rewrite

mod_rewrite の有効化

a2enmod rewrite

完了後、apache再起動

mpを本番サーバへ引っ越し.txt · 最終更新: 2010/07/27 15:47 (外部編集)
www.chimeric.de Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0

Strict Standards: Only variables should be passed by reference in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/doku.php on line 81