{"id":5860,"date":"2019-05-02T13:12:38","date_gmt":"2019-05-02T05:12:38","guid":{"rendered":"https:\/\/blog.hoyo.idv.tw\/?p=5860"},"modified":"2023-05-28T12:25:50","modified_gmt":"2023-05-28T04:25:50","slug":"mysql-%e5%8c%af%e5%87%ba%e3%80%81%e5%8c%af%e5%85%a5","status":"publish","type":"post","link":"https:\/\/blog.hoyo.idv.tw\/?p=5860","title":{"rendered":"MySQL - \u5099\u4efd\u3001\u9084\u539f\u8cc7\u6599\u5eab(\u532f\u51fa\u3001\u532f\u5165)"},"content":{"rendered":"<p>--<\/p>\n<ul>\n<li><a href=\"https:\/\/jax-work-archive.blogspot.com\/2009\/07\/mysqldump-51-mysql.html\" target=\"_blank\" rel=\"noopener\">(\u8f49\u8f09)mysqldump 5.1 \u8cc7\u6599\u5099\u4efd\u8a73\u7d30\u6307\u4ee4 [MySQL]<\/a><\/li>\n<li><a href=\"https:\/\/blog.csdn.net\/wll_1017\/article\/details\/54134817\" target=\"_blank\" rel=\"noopener\">mysqldmp \u53c2\u6570\u4e4b--skip-opt \u4e0e--opt<\/a><\/li>\n<\/ul>\n<p>--<\/p>\n<h2>\u532f\u51fa\u8cc7\u6599\u5eab - \u4e00\u500b\u8cc7\u6599\u5eab<\/h2>\n<ul>\n<li><a href=\"https:\/\/www.jinnsblog.com\/2018\/04\/mysql-export-import-db-table.html\" target=\"_blank\" rel=\"noopener\">[\u6559\u5b78] MariaDB\/MySQL\u5099\u4efd \u2013 \u5982\u4f55\u532f\u51fa\u3001\u532f\u5165\u8cc7\u6599\u5eab\u6216\u8868\u683c<\/a><\/li>\n<\/ul>\n<pre class=\"lang:default decode:true\"># mysqldump -u \u4f7f\u7528\u8005\u540d\u7a31 -p \u8cc7\u6599\u5eab\u540d\u7a31 &gt; db.sql<\/pre>\n<p>--<\/p>\n<h2>\u532f\u51fa\u8cc7\u6599\u5eab - \u5f9e\u8cc7\u6599\u5eab\u6311\u9078\u8cc7\u6599\u8868<\/h2>\n<p>\u6709\u6642\u5019\u532f\u51fa\u8cc7\u6599\u5eab\u4e26\u4e0d\u9700\u8981\u5168\u90e8\u7684\u8cc7\u6599\u8868\uff0c\u53ef\u4ee5\u624b\u52d5\u6216\u662f\u6839\u64da\u689d\u4ef6\u5f0f\u4f86\u6311\u9078<\/p>\n<p>\u5099\u4efd 1 2 3 \u8cc7\u6599\u8868<\/p>\n<pre class=\"lang:default decode:true\">mysqldump -u user -p database 1 2 3 &gt; backup.sql<\/pre>\n<p>\u4f7f\u7528 like \u904e\u6ffe\uff0c\u6311\u9078 user \u958b\u982d\u8cc7\u6599\u8868\uff0c--login-path=root \u662f\u8eab\u4efd\u9a57\u8b49\u65b9\u5f0f\u8acb\u6839\u64da MySQL \u6216 MariaDB \u81ea\u884c\u66ff\u63db<\/p>\n<pre class=\"lang:default decode:true\">mysqldump --login-path=root --databases $(mysql --login-path=root -Bse \"use database; show tables like 'user%'\") &gt; backup.sql\r\n<\/pre>\n<p>\u4f7f\u7528 not like \u904e\u6ffe\uff0c\u4e0d\u60f3\u5099\u4efd log \u53c8\u525b\u597d\u8cc7\u6599\u8868\u90fd\u662f _log \u7d50\u5c3e\u5c31\u53ef\u4ee5\u4f7f\u7528<\/p>\n<pre class=\"lang:default decode:true\">\"use database; show tables where Tables_in_bsb not like '%_log';\"<\/pre>\n<p>--<\/p>\n<h2>\u532f\u51fa\u4e0d\u5305\u542b\u8996\u5716 view<\/h2>\n<ul>\n<li><a href=\"https:\/\/dba.stackexchange.com\/questions\/314183\/skip-views-when-using-mysqldump\" target=\"_blank\" rel=\"noopener\">Skip views when using mysqldump<\/a><\/li>\n<\/ul>\n<p>\u96d6\u7136\u53ef\u4ee5\u4f7f\u7528 --ignore-table \u4f86\u6392\u9664 \"\u6307\u5b9a\" \u8cc7\u6599\u8868\uff0c\u53ef\u662f\u7576\u6709\u591a\u500b\u8cc7\u6599\u5eab\u4e26\u4e14\u90fd\u6709\u591a\u500b\u8cc7\u6599\u8868\u9700\u8981\u6392\u9664\u6642\uff0c\u6c92\u6709\u4eba\u6703\u4eba\u5de5\u8f38\u5165\u3002\u9019\u6642\u53ef\u4ee5\u5230 information_schema \u8cc7\u6599\u5eab\u7684 TABLES \u8cc7\u6599\u8868\u4f86\u67e5\u8a62<\/p>\n<p>\u67e5\u8a62\u6240\u6709 TABLE_TYPE \u70ba BASE TABLE \u7684\u8cc7\u6599\u8868\uff0cview \u7684 TYPE \u662f VIEW<\/p>\n<pre class=\"lang:default decode:true\">SELECT GROUP_CONCAT(TABLE_NAME SEPARATOR ' ') FROM information_schema.TABLES WHERE TABLE_SCHEMA='table name' AND TABLE_TYPE='BASE TABLE'<\/pre>\n<p>\u61c9\u7528<\/p>\n<pre class=\"lang:default decode:true \">MYSQLDUMP_SCHEMA=\"$MYSQLDUMP --skip-lock-tables --single-transaction --max_allowed_packet=512M --no-data\"\r\n$MYSQLDUMP_SCHEMA question_db $($MYSQL -u $db_user -h $db_host -p$db_passwd -Bse \"SELECT GROUP_CONCAT(TABLE_NAME SEPARATOR ' ') FROM information_schema.TABLES WHERE TABLE_SCHEMA='table name' AND TABLE_TYPE='BASE TABLE'\") &gt; question_db_schema.sql<\/pre>\n<p>--<\/p>\n<h2>\u5099\u4efd\u6240\u6709\u8cc7\u6599\u5eab\uff0c\u4e26\u4e14\u4e00\u500b\u8cc7\u6599\u5eab\u4e00\u500b\u6a94\u6848<\/h2>\n<ul>\n<li><a href=\"https:\/\/shazi.info\/mysql%E6%8E%92%E7%A8%8B%E5%82%99%E4%BB%BD%E4%B8%A6%E9%81%94%E6%88%90%E7%95%B0%E5%9C%B0%E5%82%99%E4%BB%BD%EF%BC%8Dshell-script%E7%AD%86%E8%A8%98\/\" target=\"_blank\" rel=\"noopener\">MYSQL\u6392\u7a0b\u5099\u4efd\u4e26\u9054\u6210\u7570\u5730\u5099\u4efd\uff0dshell script\u7b46\u8a18<\/a><\/li>\n<li><a href=\"https:\/\/ithelp.ithome.com.tw\/questions\/10192410\" target=\"_blank\" rel=\"noopener\">maria db \u5099\u4efd\u932f\u8aa4<\/a><\/li>\n<\/ul>\n<pre class=\"lang:default decode:true\">#!\/bin\/sh\r\n\r\ndb_user=\"root\"\r\ndb_passwd=\"root\"\r\ndb_host=\"192.168.6.100\"\r\nMYSQL=\"docker exec mariadb55 mysql\"\r\nMYSQLDUMP=\"docker exec mariadb55 mysqldump\"\r\n\r\n# get all databases\r\nall_db=\"$($MYSQL -u $db_user -h $db_host -p$db_passwd -Bse 'show databases')\"\r\n\r\nfor db in $all_db\r\ndo\r\n    $MYSQLDUMP -u $db_user -h $db_host -p$db_passwd $db &gt; $db.sql\r\ndone<\/pre>\n<p>--<\/p>\n<h2>\u532f\u51fa\u4e0d\u9396\u5b9a\u8cc7\u6599\u5eab<\/h2>\n<ul>\n<li><a href=\"https:\/\/stackoverflow.com\/questions\/104612\/run-mysqldump-without-locking-tables\" target=\"_blank\" rel=\"noopener\">Run MySQLDump without Locking Tables<\/a><\/li>\n<\/ul>\n<p>\u9810\u8a2d\u5099\u4efd\u8cc7\u6599\u5eab\u6703\u9396\u4f4f\u8cc7\u6599\u5eab\uff0c\u9019\u6642\u5c31\u7121\u6cd5\u505a\u4efb\u4f55\u64cd\u4f5c\uff0c\u5982\u679c\u4e0d\u9700\u8981\u4e00\u81f4\u6027\u7684\u5099\u4efd\u8cc7\u6599\u5eab\uff0c\u53ef\u4ee5\u8a2d\u5b9a\u4e0d\u9396\u5b9a<\/p>\n<pre class=\"lang:default decode:true\">--skip-lock-tables --single-transaction<\/pre>\n<p>\u7db2\u8def\u4e0a\u8aaa\u53ef\u4ee5\u52a0\u4e0a <code>--quick<\/code><\/p>\n<p>--<\/p>\n<h2>\u53ea\u532f\u51fa\u7d50\u69cb(\u5305\u542b\u9810\u5b58\u7a0b\u5e8f\u3001\u4e8b\u4ef6\u3001\u89f8\u767c\u5668)<\/h2>\n<ul>\n<li><a href=\"http:\/\/m.blog.chinaunix.net\/uid-20577907-id-3083217.html\" target=\"_blank\" rel=\"noopener\">Dumping MySQL Stored Procedures, Functions and Triggers<\/a><\/li>\n<\/ul>\n<pre class=\"lang:default decode:true \"># mysqldump -u root -p --no-data --no-create-info --no-create-db --skip-opt --routines --triggers --events bsb &gt; schema.sql<\/pre>\n<p>--<\/p>\n<h2>\u53ea\u532f\u51fa\u8cc7\u6599<\/h2>\n<ul>\n<li><a href=\"https:\/\/stackoverflow.com\/questions\/5109993\/dump-only-the-data-with-mysqldump-without-any-table-information\" target=\"_blank\" rel=\"noopener\">Dump only the data with mysqldump without any table information?<\/a><\/li>\n<\/ul>\n<pre class=\"lang:default decode:true \"># mysqldump --no-create-info<\/pre>\n<p>--<\/p>\n<h2>\u6b63\u78ba\u7684\u5099\u4efd\u3001\u5fa9\u539f\u8cc7\u6599\u5eab\u65b9\u5f0f<\/h2>\n<p>\u4f60\u53ef\u4ee5\u76f4\u63a5\u6574\u500b\u628a\u8cc7\u6599\u5eab\u532f\u51fa\uff0c\u4f46\u662f\u537b\u7121\u6cd5\u6b63\u78ba\u7684\u532f\u5165\uff01<\/p>\n<p>\u56e0\u70ba\u8cc7\u6599\u5efa\u7acb\u662f\u6709\u9806\u5e8f\u7684\uff0c\u70ba\u4ec0\u9ebc\u53ef\u4ee5\u5efa\u7acb view \u662f\u56e0\u70ba\u8cc7\u6599\u8868\u7d50\u69cb\u5df2\u7d93\u5b58\u5728\uff0croutine \u548c trigger \u4e5f\u662f\uff0c\u6240\u4ee5\u6309\u7167\u9810\u8a2d\u7684 mysqldump \u6703\u6839\u64da\u5b57\u6bcd\u9806\u5e8f\u532f\u51fa\uff0c\u53ea\u8981 view \u6709\u4f7f\u7528\u5230\u5f8c\u9762\u7684\u8cc7\u6599\u8868\u90a3\u532f\u5165\u5c31\u6703\u51fa\u932f\uff0c\u91cd\u8907\u532f\u5165\u53ef\u4ee5\u89e3\u6c7a\u4e0d\u904e\u4f60\u4e0d\u6703\u60f3\u6d6a\u8cbb\u597d\u5e7e\u500d\u7684\u6642\u9593\u3002<\/p>\n<p>\u6211\u5011\u9700\u8981\u5206\u958b\u5099\u4efd<\/p>\n<ol>\n<li>\u7d50\u69cb<\/li>\n<li>\u8996\u5716<\/li>\n<li>\u9810\u5b58\u7a0b\u5e8f\u3001\u89f8\u767c\u5668\u3001\u4e8b\u4ef6<\/li>\n<li>\u8cc7\u6599<\/li>\n<\/ol>\n<p>\u532f\u5165\u7684\u6642\u5019\u518d\u6309\u7167\u9806\u5e8f\u5c31\u4e0d\u6703\u770b\u5230\u4e00\u500b\u932f\u8aa4<\/p>\n<pre class=\"lang:sh decode:true\">#!\/bin\/sh\r\n\r\ndb_user=\"root\"\r\ndb_passwd=\"password\"\r\ndb_host=\"192.168.6.100\"\r\nMYSQL=\"docker exec mariadb55 mysql\"\r\nMYSQLDUMP=\"docker exec mariadb55 mysqldump -u $db_user -h $db_host -p$db_passwd --skip-lock-tables --single-transaction --max_allowed_packet=512M\"\r\nMYSQLDUMP_SCHEMA=\"$MYSQLDUMP --no-data\"\r\nMYSQLDUMP_ROUTE_TRIGGER_EVENT=\"$MYSQLDUMP --no-create-info --no-data --no-create-db --skip-opt --routines --triggers --events\"\r\n\r\n$MYSQLDUMP_SCHEMA database_name $($MYSQL -u $db_user -h $db_host -p$db_passwd -Bse \"SELECT GROUP_CONCAT(table_name SEPARATOR ' ') FROM information_schema.tables WHERE table_schema='question_db' AND engine IS NOT NULL\") &gt; question_db_schema.sql\r\n\r\n$MYSQLDUMP_ROUTE_TRIGGER_EVENT database_name$($MYSQL -u $db_user -h $db_host -p$db_passwd -Bse \"SELECT GROUP_CONCAT(table_name SEPARATOR ' ') FROM information_schema.tables WHERE table_schema='question_db' AND engine IS NOT NULL\") &gt; question_db_route_trigger_event.sql\r\n\r\n$MYSQLDUMP database_name$($MYSQL -u $db_user -h $db_host -p$db_passwd -Bse \"SELECT GROUP_CONCAT(table_name SEPARATOR ' ') FROM information_schema.tables WHERE table_schema='question_db' AND engine IS NULL\") &gt; question_db_view.sql\r\n\r\n$MYSQLDUMP --no-create-info database_name&gt; question_db_data.sql<\/pre>\n<p>--<\/p>\n<h2>\u4f7f\u7528 .sql \u532f\u5165\u8cc7\u6599\u5eab<\/h2>\n<ul>\n<li><a href=\"https:\/\/stackoverflow.com\/questions\/17666249\/how-to-import-an-sql-file-using-the-command-line-in-mysql\">How to import an SQL file using the command line in MySQL?<\/a><\/li>\n<\/ul>\n<p>\u52a0\u4e0a -f \u53ef\u4ee5\u8df3\u904e\u932f\u8aa4\u7e7c\u7e8c\u532f\u5165\uff0c\u4f8b\u5982\u91cd\u8907\u5efa\u7acb\u8cc7\u6599\u8868<\/p>\n<pre class=\"lang:default decode:true\"># mysql -f -u username -p database_name &lt; file.sql<\/pre>\n<p>\u4f7f\u7528 mysql shell<\/p>\n<pre class=\"lang:default decode:true\">mysql -u root -p\r\nmysql&gt; use database;\r\nmysql [database]&gt; source import_file.sql;<\/pre>\n<p>--<\/p>\n<h2>\u4f7f\u7528 gz \u532f\u5165\u8cc7\u6599\u5eab<\/h2>\n<ul>\n<li><a href=\"https:\/\/serverfault.com\/questions\/137965\/how-do-i-load-a-sql-gz-file-to-my-database-importing\" target=\"_blank\" rel=\"noopener\">How do I load a sql.gz file to my database? (importing)<\/a><\/li>\n<\/ul>\n<pre class=\"lang:default decode:true \">zcat \/path\/to\/file.sql.gz | mysql -u 'root' -p your_database<\/pre>\n<p>--<\/p>\n<h2>\u532f\u5165\u51fa\u73fe MySql server has gone away<\/h2>\n<ul>\n<li><a href=\"https:\/\/stackoverflow.com\/questions\/12425287\/mysql-server-has-gone-away-when-importing-large-sql-file\" target=\"_blank\" rel=\"noopener\">MySQL Server has gone away when importing large sql file<\/a><\/li>\n<\/ul>\n<pre class=\"lang:default decode:true \">wait_timeout\t\t= 28800\r\nmax_allowed_packet\t= 128M<\/pre>\n<p>--<\/p>\n<h2>\u4f7f\u7528 phpMyAdmin \u532f\u5165\u6709 foreign key \u7684\u8cc7\u6599\u8868\u8655\u7406\u65b9\u6848<\/h2>\n<p>\u532f\u5165 fk \u8cc7\u6599\u8868\u6642\uff0c\u5c31\u7b97\u6240\u6709\u95dc\u806f\u8cc7\u6599\u8868\u4e00\u8d77\u532f\u5165\u4e5f\u6703\u56e0\u70ba\u9806\u5e8f\u4e0d\u4e00\u81f4\u800c\u767c\u751f<\/p>\n<pre class=\"lang:default decode:true\">Cannot add or update a child row: a foreign key constraint fails<\/pre>\n<p>\u9019\u500b\u932f\u8aa4<\/p>\n<p>\u5f9e\u7db2\u7ad9\u4e0a\u53ef\u4ee5\u67e5\u8a62\u5230\u5fc5\u9808\u8a2d\u5b9a SET FOREIGN_KEY_CHECKS=0; \uff0c\u4f46\u662f\u4f7f\u7528 SQL \u6307\u4ee4\u57f7\u884c\u5f8c\u518d\u4f7f\u7528 SELECT @@FOREIGN_KEY_CHECKS; \u67e5\u770b\u6703\u767c\u73fe\u9084\u662f 1 \uff0c\u4e5f\u5c31\u662f\u6c92\u6709\u88ab\u95dc\u9589<\/p>\n<p>\u89e3\u6c7a\u7684\u65b9\u6cd5\u662f\u4fee\u6539\u532f\u5165 .sql \u6a94\u6848\uff0c\u5728\u6700\u958b\u982d\u52a0\u4e0a\u00a0SET FOREIGN_KEY_CHECKS=0; \u4ee5\u53ca\u7d50\u5c3e\u52a0\u4e0a\u00a0SET FOREIGN_KEY_CHECKS=1;<\/p>\n<p>\u985e\u4f3c\u50cf\u9019\u6a23<\/p>\n<pre class=\"lang:mysql decode:true\">SET FOREIGN_KEY_CHECKS=0;\r\n\r\n-- \r\n-- \u539f\u4f86\u7684 SQL \u6307\u4ee4\r\n--\r\n\r\nSET FOREIGN_KEY_CHECKS=1;<\/pre>\n<p>--<\/p>\n<p><strong><span style=\"color: #333333; font-style: normal;\">\u4f7f\u7528 LOAD DATA\u00a0<\/span>\u532f\u5165 CSV \u6a94\u6848<\/strong><\/p>\n<p>\u76f4\u63a5\u532f\u5165 CSV \u6a94\u6848\u5230 MySQL \u8cc7\u6599\u5eab<\/p>\n<ul>\n<li><a href=\"http:\/\/stackoverflow.com\/questions\/11448307\/importing-csv-data-using-php-mysql\">Importing CSV data using PHP\/MySQL<\/a><\/li>\n<li><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/load-data.html\" target=\"_blank\" rel=\"noopener\">14.2.6 LOAD DATA INFILE Syntax<\/a><\/li>\n<\/ul>\n<p>--<\/p>\n<h2>\u5be6\u969b\u7bc4\u4f8b<\/h2>\n<pre class=\"lang:default decode:true\">LOAD DATA LOCAL INFILE '\/tmp\/a.csv' INTO TABLE UserTemp FIELDS TERMINATED BY ',' ENCLOSED BY '\\\"' LINES TERMINATED BY '\\r\\n' IGNORE 1 LINES ( id, Name, position, `group`, recommend, IDNumber, Email, phone, city, province, JoinDate, ServerNo, status, status2 );<\/pre>\n<p>\u9700\u8981\u6ce8\u610f\u6307\u4ee4\u9806\u5e8f<\/p>\n<p>--<\/p>\n<h2>\u6548\u80fd<\/h2>\n<p>\u5982\u679c\u53ef\u4ee5\u4f7f\u7528 LOAD DATA \u4e00\u5b9a\u6703\u6bd4\u4f7f\u7528\u7a0b\u5f0f\u62c6\u89e3\u5f8c\u9010\u7b46\u63d2\u5165\u5feb\uff0c\u4e94\u842c\u7b46\u7684\u532f\u5165\u5728\u5c0f\u767d MacBook \u4e0a\u4e5f\u53ea\u9700\u4e0d\u5230 3 \u79d2<\/p>\n<pre class=\"lang:default decode:true\">mysql&gt; LOAD DATA LOCAL INFILE '\/tmp\/b.csv' INTO TABLE UserTemp FIELDS TERMINATED BY ',' ENCLOSED BY '\\\"' LINES TERMINATED BY '\\r\\n' IGNORE 1 LINES ( id, Name, position, `group`, recommend, IDNumber, Email, phone, city, province, JoinDate, ServerNo, status, status2 );\r\nQuery OK, 57378 rows affected, 3 warnings (2.75 sec)\r\nRecords: 57378  Deleted: 0  Skipped: 0  Warnings: 0<\/pre>\n<p>--<\/p>\n<h2>mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet'<\/h2>\n<ul>\n<li><a href=\"https:\/\/stackoverflow.com\/questions\/8815445\/mysqldump-error-got-packet-bigger-than-max-allowed-packet\" target=\"_blank\" rel=\"noopener\">mysqldump error: Got packet bigger than max_allowed_packet'<\/a><\/li>\n<\/ul>\n<pre class=\"lang:default decode:true\">mysqldump --max_allowed_packet=512M<\/pre>\n<p>--<\/p>\n<h2>Using a password on the command line interface can be insecure.<\/h2>\n<ul>\n<li><a href=\"https:\/\/shazi.info\/mysql-%E5%9F%B7%E8%A1%8C-bash-script-%E5%87%BA%E7%8F%BE-warning-using-a-password-on-the-command-line-interface-can-be-insecure\/\" target=\"_blank\" rel=\"noopener\">MySQL \u57f7\u884c bash script \u51fa\u73fe Warning: Using a password on the command line interface can be insecure<\/a><\/li>\n<\/ul>\n<p>MySQL \u5728 cli \u8981\u81ea\u52d5\u57f7\u884c\u5fc5\u9808\u4f7f\u7528 mysql_config_editor \u8a2d\u5b9a<\/p>\n<pre class=\"lang:default decode:true\">$ mysql_config_editor set --login-path=dbname --host=127.0.0.1 --user=root --password\r\n$ \/usr\/bin\/mysqldump --login-path=root --databases HOYO_Web &gt;\/tmp\/web$filename.sql<\/pre>\n<p>--<\/p>\n<h2>ERROR 1045 (28000): Access denied for user 'XXXXX'@'%' (using password: YES)<\/h2>\n<ul>\n<li><a href=\"http:\/\/stackoverflow.com\/questions\/2221335\/access-denied-for-load-data-infile-in-mysql\">access denied for load data infile in MySQL<\/a><\/li>\n<\/ul>\n<p>\u5c07\u00a0LOAD DATA INFILE \u6539\u6210\u00a0LOAD DATA <strong>LOCAL<\/strong> INFILE<\/p>\n<p>--<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p class=\"pvc_stats all \" data-element-id=\"5860\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> &nbsp;29,579&nbsp;total views<\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>-- (\u8f49\u8f09)mysqldum...<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p class=\"pvc_stats all \" data-element-id=\"5860\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> &nbsp;29,579&nbsp;total views<\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[258,337],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/5860"}],"collection":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5860"}],"version-history":[{"count":38,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/5860\/revisions"}],"predecessor-version":[{"id":11206,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/5860\/revisions\/11206"}],"wp:attachment":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}