{"id":233289,"date":"2023-02-10T15:04:00","date_gmt":"2023-02-10T12:04:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=233289"},"modified":"2023-02-10T15:16:24","modified_gmt":"2023-02-10T12:16:24","slug":"lihtne-php-kaesurea-toeoeriist-mysql-i-tabelite-teisendamiseks-myisamist-innodb-ks-maeaeratud-andmebaasis","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/et\/lihtne-php-kaesurea-toeoeriist-mysql-i-tabelite-teisendamiseks-myisamist-innodb-ks-maeaeratud-andmebaasis\/","title":{"rendered":"Lihtne PHP k\u00e4surea t\u00f6\u00f6riist MySQL-i tabelite teisendamiseks MyISAMist InnoDB-ks m\u00e4\u00e4ratud andmebaasis"},"content":{"rendered":"

MySQL<\/a> MyISAM andmebaasimootor on amortiseerunud viimases versioonis alates 5.5.1. MyISAM lukustab tabelit, samas kui InnoDB (n\u00fc\u00fcd MySQL-i vaikeandmebaasimootor alates versioonist 5.5.1) kasutab reatasemel kiigutamist. InnoDB peaks olema eelistatud ja soovitatav andmebaasimootor, kui soovite luua uusi rakendusi\/tabeleid. \u00dcks MyISAMi tabelite puudus on see, et nad ei toeta tehinguid. Nii InnoDB kui ka MyISAM toetavad t\u00e4istekstiotsingu indeksit.<\/p>\n

Tabeli muutmiseks InnoDB-ks saate kasutada ALTER TABLE tabelit ENGINE=INNODB, kuid kui teil on andmebaasis palju tabeleid, nt WordPress, on MyISAM-i tabelite otsimine ja \u00fckshaaval teisendamine t\u00fc\u00fctu.<\/p>\n

\u00d5nneks saab j\u00e4rgmist PHP<\/a> -d k\u00e4ivitada k\u00e4sureal ja see v\u00f5tab andmebaaside nimede parameetrid, mida saate edastada paljudele andmebaasidele, ning otsib nendest andmebaasidest need tabelid, mis on praegu MyISAM-i mootor ja annab k\u00e4su ALTER TABLE iga\u00fcks neist.<\/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
Kasutamise n\u00e4ide:<\/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
M\u00f5ned andmebaasid kuuluvad MySQL-i, nt sys, mysql \u2013 nendel tabelitel on mootorit\u00fc\u00fcbid nagu m\u00e4lu, csv \u2013 palun \u00e4ra konverteeri neid InnoDB-ks.<\/p>\n
MySQL<\/p>\n
Samuti v\u00f5ivad teile meeldida: PHP vidin MySQL-i MyISAMi tabelite teisendamiseks InnoDB-ks<\/a><\/p>\n
:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Lihtne PHP k\u00e4surea t\u00f6\u00f6riist MySQL-i tabelite teisendamiseks MyISAMist InnoDB-ks m\u00e4\u00e4ratud andmebaasis<\/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":[718,894,718,833,894,916,916,1110,842,802,802,833,842,863,863],"tags":[1165],"class_list":{"0":"post-233289","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-arendaja","8":"category-kood","10":"category-juhend-algajatele","12":"category-muud","14":"category-n-a","15":"category-opetused","16":"category-php-4","20":"category-wordpress-4","22":"tag-affiai-et"},"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/posts\/233289","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/comments?post=233289"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/posts\/233289\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/media\/224526"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/media?parent=233289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/categories?post=233289"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/et\/wp-json\/wp\/v2\/tags?post=233289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}