skypream

หลังจาก musuperpump ดาวไปทำให้ผมเรียนรู้ ว่า multidatabase ทำยังไง

วันนี้เลยจะทำการสอน วิธีติดตั้ง  wpmu multidatabase ครับโดยผมจะสอนแบบ16databaseน่ะครับเพราะมันจะได้ไม่งงไปสำหรับมือใหม่อ่ะครับ

ก่อนอื่นให้ copy คำต่อไปนี้ไปใส่ใน้ notepadก่อนครับ

CREATE DATABASE `xxx_0` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_1` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_3` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_4` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_5` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_6` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_7` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_8` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_9` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_a` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_b` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_c` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_d` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_e` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_f` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE `xxx_global` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

// Usage: add_dc_ip(IP, DC)

// EX: add_dc_ip(’123.123.123.’, ‘dc1′);

add_dc_ip(’123.123.123.’, ‘dc1′);

add_db_server(‘global’, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_global’, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(’0′, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_0′, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(’1′, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_1′, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(’2′, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_2′, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(’3′, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_3′, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(’4′, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_4′, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(’5′, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_5′, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(’6′, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_6′, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(’7′, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_7′, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(’8′, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_8′, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(’9′, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_9′, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(‘a’, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_a’, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(‘b’, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_b’, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(‘c’, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_c’, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(‘d’, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_d’, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(‘e’, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_e’, ‘db_user_name’,  ’db_user_name_pass’);

add_db_server(‘f’, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101′, ‘wpmu_f’, ‘db_user_name’,  ’db_user_name_pass’);