(1)
[root@life sql]# cat parttb.sql
INSERT INTO `parttb` VALUES (1, 'kmvsc', '教務處', '', 1);
INSERT INTO `parttb` VALUES (2, 'kmvsd', '學務處', '', 2);
INSERT INTO `parttb` VALUES (3, 'kmvse', '總務處', '', 4);
INSERT INTO `parttb` VALUES (4, 'kmvsf', '實習處', '', 5);
INSERT INTO `parttb` VALUES (5, 'kmvsg', '輔導室', '', 6);
INSERT INTO `parttb` VALUES (6, 'kmvsh', '教官室', '', 7);
INSERT INTO `parttb` VALUES (7, 'kmvsi', '圖書館', '', 0);
INSERT INTO `parttb` VALUES (8, 'kmvsj', '人事室', '', 9);
INSERT INTO `parttb` VALUES (9, 'kmvsk', '會計室', '', 10);
INSERT INTO `parttb` VALUES (10, 'kmvscc', '電腦中心', '', 3);
INSERT INTO `parttb` VALUES (17, 'kmvsi1', '圖書館主任', '', 25);
INSERT INTO `parttb` VALUES (11, 'kmvsca', '教學組', '', 0);
INSERT INTO `parttb` VALUES (12, 'kmvscb', '註冊組', '', 17);
INSERT INTO `parttb` VALUES (13, 'kmvscd', '設備組', '', 0);
INSERT INTO `parttb` VALUES (14, 'kmvsce', '高中職社區化', '', 0);
INSERT INTO `parttb` VALUES (19, 'kmvscf', '特教組', '', 27);
INSERT INTO `parttb` VALUES (16, 'kmvsc1', '教務主任', '', 0);
INSERT INTO `parttb` VALUES (18, 'kmvsia', '資訊媒體組', '', 26);
INSERT INTO `parttb` VALUES (20, 'kmvscfe', '實研組', '', 28);
INSERT INTO `parttb` VALUES (21, 'kmvsemw', '文書組', '', 29);
INSERT INTO `parttb` VALUES (23, 'kmvsea', '出納組', '', 11);
INSERT INTO `parttb` VALUES (24, 'kmvscx', '均質化', '', 30);
[root@life sql]#
(2)
[root@life sql]# mysql -uroot -p
mysql> use anndb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+-----------------+
| Tables_in_anndb |
+-----------------+
| anntb |
| parttb |
| sessions |
| titletb |
| usertb |
+-----------------+
5 rows in set (0.00 sec)
mysql> select * from anntb;
ERROR 1146 (42S02): Table 'anndb.anntb' doesn't exist
mysql> select * from parttb;
Empty set (0.00 sec)
mysql> select * from anntb;
ERROR 1146 (42S02): Table 'anndb.anntb' doesn't exist
mysql> select * from sessions;
Empty set (0.00 sec)
mysql> select * from titletb;
Empty set (0.00 sec)
mysql> select * from usertb;
Empty set (0.00 sec)
mysql>
(3)
Database changed
mysql> INSERT INTO `parttb` VALUES (1, 'kmvsc', '教務處', '', 1);
Query OK, 1 row affected, 1 warning (0.08 sec)
mysql> INSERT INTO `parttb` VALUES (2, 'kmvsd', '學務處', '', 2);
Query OK, 1 row affected, 1 warning (0.06 sec)
mysql> INSERT INTO `parttb` VALUES (3, 'kmvse', '總務處', '', 4);
Query OK, 1 row affected, 1 warning (0.03 sec)
mysql> INSERT INTO `parttb` VALUES (4, 'kmvsf', '實習處', '', 5);
Query OK, 1 row affected, 1 warning (0.04 sec)
mysql> INSERT INTO `parttb` VALUES (5, 'kmvsg', '輔導室', '', 6);
Query OK, 1 row affected, 1 warning (0.03 sec)
mysql> INSERT INTO `parttb` VALUES (6, 'kmvsh', '教官室', '', 7);
Query OK, 1 row affected, 1 warning (0.03 sec)
mysql> INSERT INTO `parttb` VALUES (7, 'kmvsi', '圖書館', '', 0);
Query OK, 1 row affected, 1 warning (0.14 sec)
mysql> INSERT INTO `parttb` VALUES (8, 'kmvsj', '人事室', '', 9);
Query OK, 1 row affected, 1 warning (0.03 sec)
mysql> INSERT INTO `parttb` VALUES (9, 'kmvsk', '會計室', '', 10);
Query OK, 1 row affected, 1 warning (0.03 sec)
mysql> INSERT INTO `parttb` VALUES (10, 'kmvscc', '電腦中心', '', 3);
Query OK, 1 row affected, 1 warning (0.03 sec)
mysql> INSERT INTO `parttb` VALUES (17, 'kmvsi1', '圖書館主任', '', 25);
Query OK, 1 row affected, 1 warning (0.03 sec)
mysql> INSERT INTO `parttb` VALUES (11, 'kmvsca', '教學組', '', 0);
Query OK, 1 row affected, 1 warning (0.03 sec)
mysql> INSERT INTO `parttb` VALUES (12, 'kmvscb', '註冊組', '', 17);
Query OK, 1 row affected, 1 warning (0.03 sec)
mysql> INSERT INTO `parttb` VALUES (13, 'kmvscd', '設備組', '', 0);
Query OK, 1 row affected, 1 warning (0.03 sec)
mysql> INSERT INTO `parttb` VALUES (14, 'kmvsce', '高中職社區化', '', 0);
Query OK, 1 row affected, 1 warning (0.03 sec)
mysql> INSERT INTO `parttb` VALUES (19, 'kmvscf', '特教組', '', 27);
Query OK, 1 row affected, 1 warning (0.04 sec)
mysql> INSERT INTO `parttb` VALUES (16, 'kmvsc1', '教務主任', '', 0);
Query OK, 1 row affected, 1 warning (0.03 sec)
mysql> INSERT INTO `parttb` VALUES (18, 'kmvsia', '資訊媒體組', '', 26);
Query OK, 1 row affected, 1 warning (0.03 sec)
mysql> INSERT INTO `parttb` VALUES (20, 'kmvscfe', '實研組', '', 28);
Query OK, 1 row affected, 1 warning (0.04 sec)
mysql> INSERT INTO `parttb` VALUES (21, 'kmvsemw', '文書組', '', 29);
Query OK, 1 row affected, 1 warning (0.03 sec)
mysql> INSERT INTO `parttb` VALUES (23, 'kmvsea', '出納組', '', 11);
Query OK, 1 row affected, 1 warning (0.03 sec)
mysql> INSERT INTO `parttb` VALUES (24, 'kmvscx', '均質化', '', 30);
Query OK, 1 row affected, 1 warning (0.04 sec)
mysql> select * from parttb;
+--------+---------+----------+-----------+---------+
| partid | pid | partname | partident | rootuid |
+--------+---------+----------+-----------+---------+
| 1 | kmvsc | ??? | | 1 |
| 2 | kmvsd | ??? | | 2 |
| 3 | kmvse | ??? | | 4 |
| 4 | kmvsf | ??? | | 5 |
| 5 | kmvsg | ??? | | 6 |
| 6 | kmvsh | ??? | | 7 |
| 7 | kmvsi | ??? | | 0 |
| 8 | kmvsj | ??? | | 9 |
| 9 | kmvsk | ??? | | 10 |
| 10 | kmvscc | ???? | | 3 |
| 11 | kmvsca | ??? | | 0 |
| 12 | kmvscb | ??? | | 17 |
| 13 | kmvscd | ??? | | 0 |
| 14 | kmvsce | ?????? | | 0 |
| 16 | kmvsc1 | ???? | | 0 |
| 17 | kmvsi1 | ????? | | 25 |
| 18 | kmvsia | ????? | | 26 |
| 19 | kmvscf | ??? | | 27 |
| 20 | kmvscfe | ??? | | 28 |
| 21 | kmvsemw | ??? | | 29 |
| 23 | kmvsea | ??? | | 11 |
| 24 | kmvscx | ??? | | 30 |
+--------+---------+----------+-----------+---------+
22 rows in set (0.00 sec)
(4)
[root@life2 ~]# tar xvzf ann-1.47_utf8.tar.gz
http://anngo.co.cc/
[root@life2 ~]# mv ann /usr/local/apache2/htdocs
[root@life2 apache2]# cd /usr/local/apache2/htdocs
[root@life2 htdocs]# ls
ann index.html index.php
[root@life2 htdocs]#
[root@life2 htdocs]# cd /usr/local/apache2/htdocs/ann/
[root@life2 ann]# chmod -R 1777 files
[root@life2 ann]# mv conf/config.inc.php- conf/config.inc.php
[root@life2 ann]# mv conf/mysite.inc.php- conf/mysite.inc.php
(5)
[root@life2 ann]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.5.23 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create database anndb;
Query OK, 1 row affected (0.00 sec)
mysql> grant all privileges on anndb.* to ann@localhost identified by 'w10023';
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
[root@life2 ann]#
[root@life2 ann]# mysql -u ann -p anndb < sql/mysql.sql
Enter password:
[root@life2 ann]#
(6)
※ 請注意 php.ini 中的 file_uploads 選項應為 On
[root@life2 ann]# cd /tmp
[root@life2 tmp]# ln -s /var/lib/mysql/mysql.sock mysql.sock
[root@life2 tmp]#
(7)
[root@life2 tmp]# cd /usr/local/apache2/htdocs/ann/conf
[root@life2 conf]# ls
config.inc.php defconf.inc.php index.php mysite.inc.php
[root@life2 conf]# vi config.inc.php
[root@life2 conf]#
(8)
[root@life2 conf]# vi usertb.sql
[root@life2 conf]# mysql -u ann -p anndb < usertb.sql
Enter password:
[root@life2 conf]# cat usertb.sql
INSERT INTO `usertb` VALUES (1, 'e60c6e4e69a7c26bef8024f60f44243c', 1, 0x6b6d7673636d, '教務處', 0x636478766533, '', '');
INSERT INTO `usertb` VALUES (2, '33f97e180e3322d64ab9e560d44b40f1', 2, 0x6b6d7673646d, '學務處', 0x646573666333, '', '');
INSERT INTO `usertb` VALUES (3, '7c2703b8852390257bd2293bfde7d59c', 10, 0x6b6d767363636d, '電腦中心', 0x6161313233343536, '', '');
INSERT INTO `usertb` VALUES (4, '5aa947fd1b217ac6d7208500860b5df3', 3, 0x6b6d7673656d, '總務處', 0x333334373337, '', '');
INSERT INTO `usertb` VALUES (5, '258f29d084232300a20e9b92004555a1', 4, 0x6b6d7673666d, '實習處', 0x667276646734, '', '');
INSERT INTO `usertb` VALUES (6, '94c5a38d9be147c864d5cdc2f51fb7a6', 5, 0x6b6d7673676d, '輔導室', 0x673574666862, '', '');
INSERT INTO `usertb` VALUES (7, '2458bff6e5b5b5cbf4ba66e4562b6efb', 6, 0x6b6d767368, '教官室', 0x686a6736796e, '', '');
INSERT INTO `usertb` VALUES (8, '261fb87121de65166d4c0b9144957597', 7, 0x6b6d7673696d, '圖書館主任', 0x69756f386b2c, '', '');
INSERT INTO `usertb` VALUES (9, '9fb552a8e38b9fc060b001482dfaa87f', 8, 0x6b6d76736a6d, '人事室', 0x71617a383532, '', '');
INSERT INTO `usertb` VALUES (10, '1249baab963864e564b8d7398504ca72', 9, 0x6b6d76736b6d, '會計室', 0x6b2c38696a6c, '', '');
INSERT INTO `usertb` VALUES (11, '54c86d00685d59ef5fa20ea7294d6820', 23, 0x6b6d76736561, '出納組', 0x6162636431323334, '', '');
INSERT INTO `usertb` VALUES (20, '0d4cb329320a0576b583fc1b06921d02', 13, 0x6b6d76736364, '設備組', 0x636478766533, 'kmvscd@mail.kmvs.km.edu.tw', '');
INSERT INTO `usertb` VALUES (17, '4a2213d0c1f2eee7441848b4185363a4', 12, 0x6b6d76736362, '註冊組 ', 0x636478766533, 'kmvscb@mail.kmvs.km.edu.tw', '');
INSERT INTO `usertb` VALUES (15, '4bc29abe8cbd16c4ecbddeb6b3285ed4', 11, 0x6b6d76736361, '教學組', 0x636478766533, 'kmvsca@mail.kmvs.km.edu.tw', '');
INSERT INTO `usertb` VALUES (18, '8a37ed713d4371c091b4dc54a3e5764b', 14, 0x6b6d76736365, '社區化承辦人', 0x636478766533, 'kmvsce@mail.kmvs.km.edu.tw', '');
INSERT INTO `usertb` VALUES (27, '803bea24733ad78df6f5bb4bc29ddb6b', 19, 0x6b6d76736366, '特教組', 0x373133, '', '');
INSERT INTO `usertb` VALUES (21, '276fefe248107ac8d14dbd70c96a6e9d', 1, 0x6b6d76736331, '教務主任', 0x636478766533, 'kmvsc@mail.kmvs.km.edu.tw', '');
INSERT INTO `usertb` VALUES (22, 'a3f249de517604909397c90a71f4351f', 16, 0x6b6d76736331, '教務主任', 0x636478766533, 'kmvsc@mail.kmvs.km.edu.tw', '');
INSERT INTO `usertb` VALUES (23, '39031c71d752cd18668d489d7a83803a', 4, 0x6b6d76736c64, '電機科', 0x6b6d76736c6439393939, 'kmvsld@mail.kmvs.km.edu.tw', 'kmvsld@yahoo.com.tw');
INSERT INTO `usertb` VALUES (24, '82420964e8909075ab1fdab05540402e', 7, 0x6b6d76736961, '資訊媒體組', 0x796979656e323438, 'yiyen@mail.kmvs.km.edu.tw', '');
INSERT INTO `usertb` VALUES (25, '144dad8a6a38a5844a62bbf0c50d8198', 17, 0x6b6d76736931, '圖書館主任', 0x69756f386b2c, 'kmvsi@mail.kmvs.km.edu.tw', '');
INSERT INTO `usertb` VALUES (26, '4ddf5f8d16d49e15e492aaddfb238a1b', 18, 0x6b6d76736961, '資訊媒體組', 0x796979656e323438, 'yiyen@mail.kmvs.km.edu.tw', '');
INSERT INTO `usertb` VALUES (28, '6e5d0f8e2d42fbef71735594834cf7b0', 20, 0x6b6d7673636665, '實研組', 0x6b6d767363666539393939, '', '');
INSERT INTO `usertb` VALUES (29, 'dfaeb0394bddf61b82af1f914902f5df', 21, 0x6b6d7673656d77, '文書組', 0x6b6d7673656d773132, '', '');
INSERT INTO `usertb` VALUES (30, '', 24, 0x6b6d76736378, '均值化承辦人', 0x6162636431323334, '', '');
[root@life2 conf]#
(9)
[root@life2 conf]# mysql -u ann -p anndb < parttb.sql
Enter password:
[root@life2 conf]# mysql -u ann -p anndb < roottb.sql
Enter password:
ERROR 1146 (42S02) at line 1: Table 'anndb.roottb' doesn't exist
[root@life2 conf]#
|