#--------------------------------------------------------------------------------
バックアップデータベース作成
mysql -p -u root/chiroro

create database qfs11;
use qfs11;
grant all on qfs11.* to qfsuser@localhost identified by 'abc123';

qfsmailフォルダコピー
qfs.iniを開きqfsmail9をqfsmail10に置換

・qfsmailを起動してqfs10を選択し、DBを初期化。


■基本項目ｺﾋﾟｰ
delete from qfs11.dir;
delete from qfs11.state;
delete from qfs11.address;
delete from qfs11.ad_dir;

insert into qfs11.dir
select * from qfs10.dir;
insert into qfs11.state
select * from qfs10.state;
insert into qfs11.address
select * from qfs10.address;
insert into qfs11.ad_dir
select * from qfs10.ad_dir;

delete from mail;
delete from mailbody;

insert into qfs11.mail
select m_id,              /* メールID */
d_id,              /* ディレクトリID (ディレクトリテーブルのd_idとリンク */
flag,          /* フラグ */
s_id,          /* 状態ID */
mailfrom, /* 差出人 */
recipients,       /* 受取人 */
cc,               /* Cc */
bcc,              /* Bcc */
date,         /* 日付 */
subject,  /* 件名 */
priority,      /* 重要度 */
size,              /* サイズ */
regdate,      /* 受信日 */
replyto  /* ReplyTo */
 from qfs10.mail;

insert into qfs11.mailbody
select m_id,              /* メールID */
body from qfs10.mail;

insert into qfs11.attachment
select * from qfs10.attachment;
