{"id":233265,"date":"2023-02-10T15:22:00","date_gmt":"2023-02-10T12:22:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=233265"},"modified":"2023-02-10T15:31:45","modified_gmt":"2023-02-10T12:31:45","slug":"una-herramienta-de-linea-de-comandos-php-simple-para-convertir-tablas-mysql-de-myisam-a-innodb-en-una-base-de-datos-especificada","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/es\/una-herramienta-de-linea-de-comandos-php-simple-para-convertir-tablas-mysql-de-myisam-a-innodb-en-una-base-de-datos-especificada\/","title":{"rendered":"Una herramienta de l\u00ednea de comandos PHP simple para convertir tablas MySQL de MyISAM a InnoDB en una base de datos especificada"},"content":{"rendered":"

El motor de base de datos MySQL<\/a> MyISAM se depreci\u00f3 en la \u00faltima versi\u00f3n desde 5.5.1. MyISAM es el bloqueo de tablas, mientras que InnoDB (ahora el motor de base de datos predeterminado para MySQL desde 5.5.1) emplea el balanceo de nivel de fila. InnoDB deber\u00eda ser el motor de base de datos preferido y recomendado si desea crear nuevas aplicaciones\/tablas. Una deficiencia de las tablas MyISAM es que no admiten transacciones. Tanto InnoDB como MyISAM admiten el \u00edndice de b\u00fasqueda de texto completo.<\/p>\n

Puede usar ALTER TABLE table ENGINE=INNODB para cambiar una tabla a InnoDB, pero si tiene muchas tablas en una base de datos, por ejemplo, WordPress, ser\u00e1 tedioso buscar tablas MyISAM y convertirlas una por una.<\/p>\n

Afortunadamente, el siguiente PHP<\/a> se puede ejecutar en la l\u00ednea de comandos y toma par\u00e1metros de nombres de bases de datos, que puede pasar a muchas bases de datos, y buscar\u00e1 esas tablas en estas bases de datos que actualmente son el motor MyISAM y emitir\u00e1 un comando de ALTER TABLE para cada uno de ellos.<\/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
Ejemplo de uso:<\/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
Hay algunas bases de datos que pertenecen a MySQL, por ejemplo, sys, mysql; estas tablas tienen tipos de motor, como memoria, csv; no las convierta a InnoDB.<\/p>\n
mysql<\/p>\n
Tambi\u00e9n te puede interesar: Gadget PHP para convertir tablas MyISAM en MySQL a InnoDB<\/a><\/p>\n
Fuente de grabaci\u00f3n:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Una herramienta de l\u00ednea de comandos PHP simple para convertir tablas MySQL de MyISAM a InnoDB en una base de datos especificada<\/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":[892,892,716,716,831,914,1110,914,800,800,831,840,840,861,861],"tags":[1172],"class_list":["post-233265","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-codigo","category-desarrollador","category-guia-para-principiantes","category-otro","category-n-a","category-php-2","category-tutoriales","category-wordpress-2","tag-affiai-es"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/posts\/233265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/comments?post=233265"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/posts\/233265\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/media\/224526"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/media?parent=233265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/categories?post=233265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/tags?post=233265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}