I have an old fashioned WPMU version (2.6) and something like 7 000 blogs installed.
My SQL can handle the database but I'm not able anymore to use MySQL tools such as phpmyadmin, because "show table status" command takes too long and returns too much infos.
I'd like to install multi-DB, and I ahve some questions for you. Can you please help me ?
Q1: Characters set of new databases : my current main database is latin1_swedish_ci, not utf8_general_ci. BUT wpmu tables do are utf8_general_ci. While using your https://premium.wpmudev.org/db-tools/db_sql.php, to create new tables, should I create databases like :
wpmu00 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
or like :
wpmu00 DEFAULT CHARACTER SET utf8 COLLATE latin1_swedish_ci;
or like :
wpmu00 DEFAULT CHARACTER SET latin1_swedish_ci COLLATE latin1_swedish_ci;
Depending on what I do, every texts could be broken, or not; so it's very important to do the right choice...
Q2 : I don't understand the global table thing. It says :
"// Do not include default global tables"
and we have an eg. : add_global_table('global');
and below :
add_db_server('global', 'dc1', 1, 1,'18.104.22.168','192.168.0.101', 'wpmu_global', 'db_user_name', 'db_user_name_pass');
I have global tables used by plugins, what will happen to them ? Will they be moved or will they remain in the former database ?
Q3 : Not well coded plugins. I may have plugins that do hard SQL queries such as :
SELECT ID from mytable WHERE ...
They don't use the "$wpdb->" prefix while querying. Is it a problem ? Queries are only done to global tables, not blogs.
Q4 : list-hashes.php : what is the aim of this script ? And why there is an MD5 tool here : https://premium.wpmudev.org/db-tools/db_sql.php ? Shoulf I do something with it ? what ?
Q5 : Always in https://premium.wpmudev.org/db-tools/db_sql.php there is a "DB Array" tool, same question ?
Q6 : Your db.php calls a file named "wp-content/db-list.php" (line 54) but it's not in my server. What is it and what should we find in it ?
Your help will be much appreciated !