-
-
Save flabernardez/f6287dfd7a350344b5096bd213728371 to your computer and use it in GitHub Desktop.
#wordpress Cambiar el prefijo de las tablas
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* En wp-config.php*/ | |
$table_prefix = 'tuprefijo_'; | |
/* En administrador de la base de datos, ejecutar los siguientes comandos SQL */ | |
RENAME TABLE wp_links TO tuprefijo_links; | |
RENAME TABLE wp_commentmeta TO tuprefijo_commentmeta; | |
RENAME TABLE wp_comments TO tuprefijo_comments; | |
RENAME TABLE wp_options TO tuprefijo_options; | |
RENAME TABLE wp_postmeta TO tuprefijo_postmeta; | |
RENAME TABLE wp_posts TO tuprefijo_posts; | |
RENAME TABLE wp_term_relationships TO tuprefijo_term_relationships; | |
RENAME TABLE wp_term_taxonomy TO tuprefijo_term_taxonomy; | |
RENAME TABLE wp_termmeta TO tuprefijo_termmeta; | |
RENAME TABLE wp_terms TO tuprefijo_terms; | |
RENAME TABLE wp_usermeta TO tuprefijo_usermeta; | |
RENAME TABLE wp_users TO tuprefijo_users; | |
UPDATE tuprefijo_options SET option_name = 'tuprefijo_user_roles' | |
WHERE option_name = 'wp_user_roles'; | |
UPDATE tuprefijo_usermeta SET meta_key = 'tuprefijo_capabilities' | |
WHERE meta_key = 'wp_capabilities'; | |
UPDATE tuprefijo_usermeta SET meta_key = 'tuprefijo_user_level' | |
WHERE meta_key = 'wp_user_level'; | |
UPDATE tuprefijo_usermeta SET meta_key = 'tuprefijo_user-settings' | |
WHERE meta_key = 'wp_user-settings'; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment