{"id":233274,"date":"2023-02-10T15:38:00","date_gmt":"2023-02-10T12:38:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=233274"},"modified":"2023-02-10T15:38:43","modified_gmt":"2023-02-10T12:38:43","slug":"prostij-instrument-komandnogo-rjadka-php-dlja-peretvorennja-tablic-mysql-iz-myisam-na-innodb-u-vkazanij-bazi-danih","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/uk\/prostij-instrument-komandnogo-rjadka-php-dlja-peretvorennja-tablic-mysql-iz-myisam-na-innodb-u-vkazanij-bazi-danih\/","title":{"rendered":"\u041f\u0440\u043e\u0441\u0442\u0438\u0439 \u0456\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442 \u043a\u043e\u043c\u0430\u043d\u0434\u043d\u043e\u0433\u043e \u0440\u044f\u0434\u043a\u0430 PHP \u0434\u043b\u044f \u043f\u0435\u0440\u0435\u0442\u0432\u043e\u0440\u0435\u043d\u043d\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044c MySQL \u0456\u0437 MyISAM \u043d\u0430 InnoDB \u0443 \u0432\u043a\u0430\u0437\u0430\u043d\u0456\u0439 \u0431\u0430\u0437\u0456 \u0434\u0430\u043d\u0438\u0445"},"content":{"rendered":"

\u041c\u0435\u0445\u0430\u043d\u0456\u0437\u043c \u0431\u0430\u0437 \u0434\u0430\u043d\u0438\u0445 MySQL<\/a> MyISAM \u0437\u0430\u0441\u0442\u0430\u0440\u0456\u0432 \u0432 \u043e\u0441\u0442\u0430\u043d\u043d\u0456\u0439 \u0432\u0435\u0440\u0441\u0456\u0457 \u0437 5.5.1. MyISAM \u0431\u043b\u043e\u043a\u0443\u0454 \u0442\u0430\u0431\u043b\u0438\u0446\u044e, \u0442\u043e\u0434\u0456 \u044f\u043a InnoDB (\u0442\u0435\u043f\u0435\u0440 \u043c\u0435\u0445\u0430\u043d\u0456\u0437\u043c \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445 \u0437\u0430 \u0437\u0430\u043c\u043e\u0432\u0447\u0443\u0432\u0430\u043d\u043d\u044f\u043c \u0434\u043b\u044f MySQL \u0437 5.5.1) \u0432\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u043e\u0432\u0443\u0454 \u0440\u043e\u0437\u0433\u043e\u0439\u0434\u0443\u0432\u0430\u043d\u043d\u044f \u043d\u0430 \u0440\u0456\u0432\u043d\u0456 \u0440\u044f\u0434\u043a\u0456\u0432. \u042f\u043a\u0449\u043e \u0432\u0438 \u0445\u043e\u0447\u0435\u0442\u0435 \u0441\u0442\u0432\u043e\u0440\u044e\u0432\u0430\u0442\u0438 \u043d\u043e\u0432\u0456 \u0434\u043e\u0434\u0430\u0442\u043a\u0438\/\u0442\u0430\u0431\u043b\u0438\u0446\u0456, \u0431\u0430\u0436\u0430\u043d\u0438\u043c \u0456 \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u043e\u0432\u0430\u043d\u0438\u043c \u0434\u0432\u0438\u0433\u0443\u043d\u043e\u043c \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445 \u043c\u0430\u0454 \u0431\u0443\u0442\u0438 InnoDB. \u041e\u0434\u043d\u0438\u043c \u0456\u0437 \u043d\u0435\u0434\u043e\u043b\u0456\u043a\u0456\u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u044c MyISAM \u0454 \u0442\u0435, \u0449\u043e \u0432\u043e\u043d\u0438 \u043d\u0435 \u043f\u0456\u0434\u0442\u0440\u0438\u043c\u0443\u044e\u0442\u044c \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0456\u0457. \u0406 InnoDB, \u0456 MyISAM \u043f\u0456\u0434\u0442\u0440\u0438\u043c\u0443\u044e\u0442\u044c \u0456\u043d\u0434\u0435\u043a\u0441 \u043f\u043e\u0432\u043d\u043e\u0433\u043e \u0442\u0435\u043a\u0441\u0442\u043e\u0432\u043e\u0433\u043e \u043f\u043e\u0448\u0443\u043a\u0443.<\/p>\n

\u0412\u0438 \u043c\u043e\u0436\u0435\u0442\u0435 \u0432\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u0430\u0442\u0438 ALTER TABLE table ENGINE=INNODB, \u0449\u043e\u0431 \u0437\u043c\u0456\u043d\u0438\u0442\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u044e \u043d\u0430 InnoDB, \u0430\u043b\u0435 \u044f\u043a\u0449\u043e \u0443 \u0432\u0430\u0441 \u0454 \u0431\u0430\u0433\u0430\u0442\u043e \u0442\u0430\u0431\u043b\u0438\u0446\u044c \u0443 \u0431\u0430\u0437\u0456 \u0434\u0430\u043d\u0438\u0445, \u043d\u0430\u043f\u0440\u0438\u043a\u043b\u0430\u0434 WordPress, \u0446\u0435 \u0431\u0443\u0434\u0435 \u0432\u0442\u043e\u043c\u043b\u0438\u0432\u043e \u0448\u0443\u043a\u0430\u0442\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u0456 MyISAM \u0456 \u043f\u0435\u0440\u0435\u0442\u0432\u043e\u0440\u044e\u0432\u0430\u0442\u0438 \u043e\u0434\u043d\u0443 \u0437\u0430 \u043e\u0434\u043d\u043e\u044e.<\/p>\n

\u041d\u0430 \u0449\u0430\u0441\u0442\u044f, \u043d\u0430\u0441\u0442\u0443\u043f\u043d\u0438\u0439 PHP<\/a> \u043c\u043e\u0436\u043d\u0430 \u0437\u0430\u043f\u0443\u0441\u0442\u0438\u0442\u0438 \u0432 \u043a\u043e\u043c\u0430\u043d\u0434\u043d\u043e\u043c\u0443 \u0440\u044f\u0434\u043a\u0443, \u0456 \u0432\u0456\u043d \u043f\u0440\u0438\u0439\u043c\u0430\u0454 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0438 \u0456\u043c\u0435\u043d \u0431\u0430\u0437 \u0434\u0430\u043d\u0438\u0445, \u044f\u043a\u0456 \u0432\u0438 \u043c\u043e\u0436\u0435\u0442\u0435 \u043f\u0435\u0440\u0435\u0434\u0430\u0442\u0438 \u0431\u0430\u0433\u0430\u0442\u044c\u043e\u043c \u0431\u0430\u0437\u0430\u043c \u0434\u0430\u043d\u0438\u0445, \u0456 \u0432\u0456\u043d \u0448\u0443\u043a\u0430\u0442\u0438\u043c\u0435 \u0442\u0456 \u0442\u0430\u0431\u043b\u0438\u0446\u0456 \u0432 \u0446\u0438\u0445 \u0431\u0430\u0437\u0430\u0445 \u0434\u0430\u043d\u0438\u0445, \u044f\u043a\u0456 \u043d\u0430\u0440\u0430\u0437\u0456 \u0454 \u0441\u0438\u0441\u0442\u0435\u043c\u043e\u044e MyISAM, \u0456 \u0432\u0438\u0434\u0430\u0441\u0442\u044c \u043a\u043e\u043c\u0430\u043d\u0434\u0443 ALTER TABLE \u0434\u043b\u044f \u043a\u043e\u0436\u0435\u043d \u0437 \u043d\u0438\u0445.<\/p>\n

<?php\n\/\/ <a class=\"vglnk\" target=\"_blank\" href=\"https:\/\/helloacm.com\/a-simple-php-command-line-tool-to-convert-mysql-tables-from-myisam-to-innodb-in-specified-database\/\" rel=\"nofollow\"><span>https<\/span><span>:\/\/<\/span><span>helloacm<\/span><span>.<\/span><span>com<\/span><span>\/<\/span><span>a<\/span><span>-<\/span><span>simple<\/span><span>-<\/span><span>php<\/span><span>-<\/span><span>command<\/span><span>-<\/span><span>line<\/span><span>-<\/span><span>tool<\/span><span>-<\/span><span>to<\/span><span>-<\/span><span>convert<\/span><span>-<\/span><span>mysql<\/span><span>-<\/span><span>tables<\/span><span>-<\/span><span>from<\/span><span>-<\/span><span>myisam<\/span><span>-<\/span><span>to<\/span><span>-<\/span><span>innodb<\/span><span>-<\/span><span>in<\/span><span>-<\/span><span>specified<\/span><span>-<\/span><span>database<\/span><span>\/<\/span><\/a>\nfunction ConvertAllTablesToInnoDB($database) {\n\u00a0 define(\"DB_HOST\", \"localhost\");\n\u00a0 define(\"DB_USER\", \"root\");\n\u00a0 define(\"DB_PASSWORD\", \"password\"); \u00a0\n\u00a0 $conn = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, $database);\n\u00a0 if (!$conn) {\n\u00a0 \u00a0 \u00a0 echo \"Error: Unable to connect to MySQL.\". PHP_EOL;\n\u00a0 \u00a0 \u00a0 echo \"Debugging errno: \". mysqli_connect_errno(). PHP_EOL;\n\u00a0 \u00a0 \u00a0 echo \"Debugging error: \". mysqli_connect_error(). PHP_EOL;\n\u00a0 \u00a0 \u00a0 exit; \u00a0 \u00a0 \u00a0 \u00a0\n\u00a0 } \u00a0 \u00a0 \u00a0\n\u00a0 $sql = \"SELECT TABLE_NAME FROM \n \u00a0 \u00a0 \u00a0INFORMATION_SCHEMA.TABLES\n \u00a0 \u00a0 \u00a0WHERE TABLE_SCHEMA = '$database' \n \u00a0 \u00a0 \u00a0AND ENGINE = 'MyISAM'\n \u00a0\";\n\u00a0 \n\u00a0 $rs = mysqli_query($conn, $sql);\n\u00a0 \n\u00a0 while ($row = mysqli_fetch_array($rs)) {\n\u00a0 \u00a0 \u00a0 $tbl = $row[0];\n\u00a0 \u00a0 \u00a0 $sql = \"ALTER TABLE `$tbl` ENGINE=INNODB\";\n\u00a0 \u00a0 \u00a0 echo $sql. \"n\";\n\u00a0 \u00a0 \u00a0 mysqli_query($conn, $sql);\n\u00a0 }\n}\n\u00a0 \u00a0 \nif ($argc < 2) {\n\u00a0 \u00a0 \u00a0 exit( \"Usage: php $argv[0] database1 database2 ...n\" );\n}\n\u00a0\nfor ($i = 1; $i < $argc; ++ $i) {\n\u00a0 \u00a0 \u00a0 echo \"ConvertAllTablesToInnoDB \". $argv[$i]. \"... n\";\n\u00a0 \u00a0 \u00a0 ConvertAllTablesToInnoDB($argv[$i]);\n}<\/code><\/pre>\n
\u041f\u0440\u0438\u043a\u043b\u0430\u0434 \u0432\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u0430\u043d\u043d\u044f:<\/p>\n
# php convert_to_innodb.php wordpress\nConvertAllTablesToInnoDB wordpress... \nALTER TABLE `wp_commentmeta` ENGINE=INNODB\nALTER TABLE `wp_comments` ENGINE=INNODB\nALTER TABLE `wp_icl_string_translations` ENGINE=INNODB\nALTER TABLE `wp_imagify_files` ENGINE=INNODB\nALTER TABLE `wp_imagify_folders` ENGINE=INNODB\nALTER TABLE `wp_itsec_lockouts` ENGINE=INNODB\nALTER TABLE `wp_itsec_log` ENGINE=INNODB\nALTER TABLE `wp_itsec_temp` ENGINE=INNODB\nALTER TABLE `wp_links` ENGINE=INNODB\nALTER TABLE `wp_options` ENGINE=INNODB\nALTER TABLE `wp_postmeta` ENGINE=INNODB\nALTER TABLE `wp_posts` ENGINE=INNODB\nALTER TABLE `wp_term_relationships` ENGINE=INNODB\nALTER TABLE `wp_term_taxonomy` ENGINE=INNODB\nALTER TABLE `wp_termmeta` ENGINE=INNODB\nALTER TABLE `wp_terms` ENGINE=INNODB\nALTER TABLE `wp_usermeta` ENGINE=INNODB\nALTER TABLE `wp_users` ENGINE=INNODB\nALTER TABLE `wp_wc_download_log` ENGINE=INNODB\nALTER TABLE `wp_wc_webhooks` ENGINE=INNODB\nALTER TABLE `wp_woocommerce_api_keys` ENGINE=INNODB\nALTER TABLE `wp_woocommerce_attribute_taxonomies` ENGINE=INNODB\nALTER TABLE `wp_woocommerce_downloadable_product_permissions` ENGINE=INNODB\nALTER TABLE `wp_woocommerce_log` ENGINE=INNODB\nALTER TABLE `wp_woocommerce_order_itemmeta` ENGINE=INNODB\nALTER TABLE `wp_woocommerce_order_items` ENGINE=INNODB\nALTER TABLE `wp_woocommerce_payment_tokenmeta` ENGINE=INNODB\nALTER TABLE `wp_woocommerce_payment_tokens` ENGINE=INNODB\nALTER TABLE `wp_woocommerce_sessions` ENGINE=INNODB\nALTER TABLE `wp_woocommerce_shipping_zone_locations` ENGINE=INNODB\nALTER TABLE `wp_woocommerce_shipping_zone_methods` ENGINE=INNODB\nALTER TABLE `wp_woocommerce_shipping_zones` ENGINE=INNODB\nALTER TABLE `wp_woocommerce_tax_rate_locations` ENGINE=INNODB\nALTER TABLE `wp_woocommerce_tax_rates` ENGINE=INNODB\nALTER TABLE `wp_wpio_images` ENGINE=INNODB\nALTER TABLE `wp_yith_ywpar_points_log` ENGINE=INNODB<\/code><\/pre>\n
\u0404 \u0434\u0435\u044f\u043a\u0456 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445, \u044f\u043a\u0456 \u043d\u0430\u043b\u0435\u0436\u0430\u0442\u044c \u0434\u043e MySQL, \u043d\u0430\u043f\u0440\u0438\u043a\u043b\u0430\u0434 sys, mysql \u2013 \u0446\u0456 \u0442\u0430\u0431\u043b\u0438\u0446\u0456 \u043c\u0430\u044e\u0442\u044c \u0442\u0430\u043a\u0456 \u0442\u0438\u043f\u0438 \u043c\u0435\u0445\u0430\u043d\u0456\u0437\u043c\u0456\u0432, \u044f\u043a \u043f\u0430\u043c’\u044f\u0442\u044c, csv \u2013 \u0431\u0443\u0434\u044c \u043b\u0430\u0441\u043a\u0430, \u043d\u0435 \u043f\u0435\u0440\u0435\u0442\u0432\u043e\u0440\u044e\u0439\u0442\u0435 \u0457\u0445 \u043d\u0430 InnoDB.<\/p>\n
MySQL<\/p>\n
\u0412\u0430\u043c \u0442\u0430\u043a\u043e\u0436 \u043c\u043e\u0436\u0435 \u0441\u043f\u043e\u0434\u043e\u0431\u0430\u0442\u0438\u0441\u044f: \u0433\u0430\u0434\u0436\u0435\u0442 PHP \u0434\u043b\u044f \u043f\u0435\u0440\u0435\u0442\u0432\u043e\u0440\u0435\u043d\u043d\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044c MyISAM \u0443 MySQL \u043d\u0430 InnoDB<\/a><\/p>\n
\u0414\u0436\u0435\u0440\u0435\u043b\u043e \u0437\u0430\u043f\u0438\u0441\u0443:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
\u041f\u0440\u043e\u0441\u0442\u0438\u0439 \u0456\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442 \u043a\u043e\u043c\u0430\u043d\u0434\u043d\u043e\u0433\u043e \u0440\u044f\u0434\u043a\u0430 PHP \u0434\u043b\u044f \u043f\u0435\u0440\u0435\u0442\u0432\u043e\u0440\u0435\u043d\u043d\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044c MySQL \u0456\u0437 MyISAM \u043d\u0430 InnoDB \u0443 \u0432\u043a\u0430\u0437\u0430\u043d\u0456\u0439 \u0431\u0430\u0437\u0456 \u0434\u0430\u043d\u0438\u0445<\/p>\n","protected":false},"author":1,"featured_media":224526,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[902,725,923,1110,808,808,839,849,869,869,839,902,849,923,725],"tags":[1174],"class_list":{"0":"post-233274","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-kod-3","8":"category-rozrobnyk","9":"category-inshyj","10":"category-n-a","11":"category-php-10","13":"category-kerivnytstvo-dlia-pochatkivtsiv","14":"category-pidruchnyky","15":"category-wordpress-10","22":"tag-affiai-uk"},"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/posts\/233274","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/comments?post=233274"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/posts\/233274\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/media\/224526"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/media?parent=233274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/categories?post=233274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/uk\/wp-json\/wp\/v2\/tags?post=233274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}