Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save salvatorecapolupo/45abc03249949c8e5f7dd2f3609424f7 to your computer and use it in GitHub Desktop.
Save salvatorecapolupo/45abc03249949c8e5f7dd2f3609424f7 to your computer and use it in GitHub Desktop.
Step 1
SELECT CONCAT('ALTER TABLE ',TABLE_NAME,' ENGINE=InnoDB;')
FROM INFORMATION_SCHEMA.TABLES
WHERE ENGINE='MyISAM' AND table_schema = 'wordpress';
# wordpress = database name
Step 2
Copiare l'output generato dal precedente comando, ad esempio (PS copiare senza | orizzontali)
| ALTER TABLE wp_commentmeta ENGINE=InnoDB; |
| ALTER TABLE wp_comments ENGINE=InnoDB; |
| ALTER TABLE wp_links ENGINE=InnoDB; |
| ALTER TABLE wp_options ENGINE=InnoDB; |
| ALTER TABLE wp_postmeta ENGINE=InnoDB; |
| ALTER TABLE wp_posts ENGINE=InnoDB; |
| ALTER TABLE wp_term_relationships ENGINE=InnoDB; |
| ALTER TABLE wp_term_taxonomy ENGINE=InnoDB; |
| ALTER TABLE wp_termmeta ENGINE=InnoDB; |
| ALTER TABLE wp_terms ENGINE=InnoDB; |
| ALTER TABLE wp_usermeta ENGINE=InnoDB; |
| ALTER TABLE wp_users ENGINE=InnoDB; |
| ALTER TABLE wp_yoast_seo_links ENGINE=InnoDB; |
| ALTER TABLE wp_yoast_seo_meta ENGINE=InnoDB; |
Fatto
______
<((((((\\\
/ . }\
;--..--._|}
(\ '--/\--' )
\\ | '-' :'|
\\ . -==- .-|
\\ \.__.' \--._
[\\ __.--| // _/'--.
\ \\ .'-._ ('-----'/ __/ \
\ \\ / __>| | '--. |
\ \\ | \ | / / /
\ '\ / \ | | _/ /
\ \ \ | | / /
Miglio \ \ \ /
r
Robots.txt
Roma Sud
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment